PostgreSQL v13 Database Administration & High Availability - PostgreSQL v13 Database Administration with High Availability
- Hot & New
- Created by Data Leads
- English
Description
PostgreSQL is an advanced, enterprise class open source Object-Relational Database Management System (ORDBMS). Its is a relational database that supports both SQL (relational) and JSON (non-relational) querying.
The course provides the candidate with an extensive knowledge of PostgreSQL Database Administration with real life scenarios .
Topics discussed are:
PostgreSQL v13 Overview
PostgreSQL and its history
Installing PostgreSQL v13 on Red Hat Linux 8
PostgreSQL Architecture
Database Cluster
PostgreSQL Database Administration
PostgreSQL Configuration Files
PSQL utility and commands
PG System Catalog
CRUD Operations
Backup & Restore
Physical Backup
Logical Backup
Archie mode enabling
Overview of Barman
Different use cases in Barman
Streaming backup vs rsync/SSH
Requirements for backup
Requirements for recovery
Configuration in Barman
PostgreSQL connection
SSH configuration of postgres user
From PostgreSQL to Barman
From Barman to PostgreSQL
WAL streaming
Replication slots
How to configure the WAL streaming
Verification of WAL archiving configuration
PostgreSQL Maintenance
PostgreSQL Database Upgrade
PgAdmin 4
User Management
Grants/Revoking privileges
High Availability
Failover
Log Shipping
Alternative method of Log Shipping
Hot Standby
Types of Replication
Demos on:
Understand PostgreSQL Process and Memory Architecture.
Partitioning in PostgreSQL using Table Inheritance.
Copy table from/to PostgreSQL.
How to Create/Move/Drop Tablespace.
Logical (pg dump, pgdumpall), Physical backup (Offline, Online).
Continuous Archiving and PITR.
Install PostgreSQL v13 on Linux.
PostgreSQL Directory Structure.
PostgreSQL Configuration Files.
How to use PSQL command line interface to connect to PostgreSQL.
How to Create Database/User/Schema from utility and Psql commands.
Learn how to use pg system catalogs.
CRUD operations on PostgreSQL.
Table Inheritance in PostgreSQL.
Maintenance (Updating planner statistics, Vacuum, Routine Reindex, Cluster).
What is Transaction Id Wraparound Failure and Vacuum Freeze.
How to use Pgadmin 4 Interface.
Who this course is for:
- DBA's
- Developers
- Students