PostgreSQL Advanced DBA Training in Kuala Lumpur, Malaysia

This advanced PostgreSQL DBA course is designed for experienced database administrators who wish to deepen their knowledge of PostgreSQL internals, performance tuning, replication, high availability, and advanced security. The course covers in-depth topics through hands-on labs and real-world scenarios to enable DBAs to efficiently manage, monitor, and scale enterprise-grade PostgreSQL deployments.

Course Agenda:

Advanced Architecture and Performance Tuning

• PostgreSQL internals and process architecture

• Query execution lifecycle and planner

• Indexing strategies (BRIN, GIN, GiST, Partial Indexes)

• Query performance analysis with EXPLAIN and ANALYZE

• Memory, autovacuum, and resource tuning

Backup, Recovery, and PITR

• Advanced backup strategies: pg_basebackup, pgBackRest, Barman

• Point-in-time recovery (PITR) configuration and testing

• WAL archiving and log shipping

• Best practices for backup automation and verification

• Disaster recovery scenarios and simulations

Replication and High Availability

• Overview of replication types: Streaming, Logical, and Synchronous

• Configuring streaming replication with multiple nodes

• Switchover and failover management

• Setting up high availability using tools:

  • repmgr

  • Patroni

  • Pgpool-II and HAProxy

• Troubleshooting replication lag and conflicts

Security, Monitoring, and Automation

• Securing PostgreSQL using roles and permissions

• Configuring SSL/TLS for encrypted connections

• pg_hba.conf and authentication best practices

• Monitoring tools:

  • pg_stat_activity, pg_stat_user_tables

  • Prometheus and Grafana integration

• Automating routine maintenance with shell scripts and cron

• Log analysis and alerting