Table of Contents

PostgreSQL

  1. Installation & Configuration
  2. Database Overview
  3. Management
  4. Database Creation
  5. Enable Write Ahead Log (WAL)
  6. Locking in PostgreSQL
  7. LDAP Authentication
  8. Monitoring
  9. Database Upgrade
  10. Barman Configuration
  11. Backup & Recovery

PostgreSQL Cluster Solutions

  1. Load balancing: Pgpool-II
  2. HAProxy Stack
  3. PGBouncer Stack
  4. PostgreSQL-XL Installation & Configuration
  5. PostgreSQL-XL Management
  6. Repmgr
  7. Patroni & ETCD

PostgreSQL High Availability

  1. Basic Replication
  2. Advanced Replication: Streaming & Slots
  3. Performance Investigation