PostgreSQL DBA

Database Software Installation:

PostgreSQL Opensource orCommunity Edition Installation in RHEL or OEL 8 and above (postgresql.org)

EDB Advanced Server (enterprisedb.com)

PostgreSQL Administration Support:

1. PostgreSQL Architecture and Components
2. PostgreSQL Memory Buffers
3. PostgreSQL Background Process
4. PostgreSQL Query Flow
5. PostgreSQL Physical Storage
6. Managing Tablespace
7. PostgreSQL Create and Accessing a Database
8. PostgreSQL Schema Management
9. PostgreSQL Pages and Tuples
10. Managing Users, Roles and Privileges
11. PostgreSQL Views and Materialized Views
12. PostgreSQL Indexes
13. PostgreSQL Vacuum Process
14. PostgreSQL Partition
15. PostgreSQL Lock Management
16. PostgreSQL Performance Tuning
17. PostgreSQL DB Link and FDW
18. PostgreSQL Physical Backup & Restore
19. PostgreSQL Logical Backup & Restore
20. PostgreSQL Base Backup & Restore
21. PostgreSQL Point in Time Recovery (PITR)
22. PostgreSQL Upgradation
23. PostgreSQL Streaming Replication
24. PostgreSQL Monitoring Queries

 

    PostgreSQL Extensions

• pgcrypto

 

    PostgreSQL Opensource Tools:

1. Backup and Recovery Manager(Barman) Installation, Configuration and Backup Restore Commands
2. PgBackRest Backup and recovery Tool
3. Replication Manager (Repmgr) Installation, Configuration and Commands
4. PG-POOL-II PostgreSQL Connection Pooling Tool Installation and Conigurations
5. PgBadger Reporting Tool Installation, Configuration and Commands
6. Oracle to PostgreSQL Migration Using ORA2PG Installation, Configuration and Migration Commands

PostgreSQL EnterpriseDB (EDB) Tools:

1. EDB Backup and Restore Tool (BART) Installation, Configuration and Backup Restore Commands
2. EnterpriseDB Migration Toolkit (EDB-MTK) Installation, Configuration and Commands
3. EnterpriseDB (EDB-XDB) Replication Tool Installation & Configuration