- Why PostgreSQL Database?
- PostgreSQL Introduction
- History of PostgreSQL Database.
PostgreSQL Database Administration (DBA) Course Catalogue
- General Architecture
- Memory Based Architecture
- Process Based Architecture
- Source Code Installation
- RPM Installation
- Run installation
- PostgreSQL Cluster initialization
- DATA directory Explanation
- Starting and Stopping PostgreSQL cluster Services
- Automatic Startup / Shutdown
- Common Issues & Troubleshooting
- Installation Lab setup for PostgreSQL configuration
- Host Based Authentication and Access Management
- Benefits of Vacuuming
- Recovering Disk Space
- Updating Planner statistics
- Transaction ID explanation
- Transactions & concurrency Control
- Routine DBA Tasks and Best Practices
- Audit Log Management
- Query Analysis
- Monitoring and Statistics
- Database Logs
- OS Process Monitoring
- PostgreSQL Statistics
- Collector Statistics
- Views
- Statistics Functions
- HW Configuration
- Transaction Logs
- Tablespaces
- Partitioning
- Data Import and Export
- PG Badger
- PG Pool
- PG Admin
- PG Bench
- Logical Backup & Restore
- PG_DUMP
- PG_DUMPALL
- PG_RESTORE
- PSQL RESTORE
- Physical Backup and Restore:
- PG_BASEBACKUP
- PG_RECIVEXLOG
- VACUUM
- ANALYZE
- VACUUM FULL
- VACUMM FREEZE
- REINDEX
- PostgreSQL contrib module installation
- PostgreSQL database upgrade Methods
- Major Upgrade
- Minor Upgrade
- Upgrade Roll Back
- ostgreSQL Streaming Replication
- understanding Recovery.conf
- understanding Initializing Streaming Replication
- Recovery Options
- Standby Promotion
- Cascading Replication
- Replication Slots
- Synchronous Replication
- Replication Type Selection
- Cascading Replication
- Replication Slots
- Synchronous Replication
- Switchover Scenarios
- Failover Scenarios
- PostgreSQL High Availability
- Failing Back Scenarios
- Standby Conflicts
- Standby Promotion
- WAL Shipping process
- Replication Overview
- Replication Configuration & Setup
- Replication Monitoring
- pg_rewind usage
- Inheritance and Partitioning
- PostgreSQL self-Partitioning
- PostgreSQL Trigger Based Partitioning
- Operating System Level Performance Tuning
- Query Level Performance Tuning
- Database Level Performance Tuning
- User Level Performance Tuning.
- Object Level Performance Tuning
- Ways of Migration
- Types of Migration
- Tools using for migration
- Oracle to PostgreSQL Migration Demo