PostgreSQL Replication

/ home / computer / postgresql / postgresql for mysql admins / .

1. Reasons for HA

   • Availability / failover
   • Reporting replica
   • Backup replica?
   • Read scale-out?
   • Delayed replica?
   • Upgrade path

2. Logical Replication

   • Preparation
   • Set-up
   • Operations
   • Monitoring
   • Failover
   • Advanced topics
     • Replication filtering
       • Hubert ‘depesz’ Lubaczewski, 2026-03-26: Waiting for PostgreSQL 19 – Add support for EXCEPT TABLE in ALTER PUBLICATION

3. Physical Replication

   • Preparation
   • Set-up
   • Operations
   • Monitoring
   • Failover
   • Advanced topics