PostgreSQL HA Design (Patroni / EFM / Repmgr)

Choosing between Patroni+etcd+HAProxy, EDB Failover Manager (EFM), or Repmgr isn't a one-size-fits-all decision. This session walks through your infrastructure, workload, and compliance needs to design (or review) an HA architecture — covering automated failover, switchover procedures, streaming/cascading replication topology, and connection routing.

What you'll get

• Architecture recommendation (Patroni vs EFM vs Repmgr) based on your environment
• Replication topology design (streaming, cascading, sync/async trade-offs)
• Failover/switchover runbook guidance
• Connection routing plan (HAProxy / PgBouncer / PgPool-II)
• Reference walkthroughs from my open-source HA PostgreSQL documentation repo

Who this is for

Teams moving off manual failover, or planning their first production-grade PostgreSQL HA cluster.