PostgreSQL Replication

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

Table of Contents

Physical Replication

Also called “Write-Ahead Log Shipping”. Can be synchronous or asynchronous. Implemented using file-based log shipping or streaming replication.

…

• Log-Shipping Standby Servers
• Streaming Replication Protocol

Logical Replication

…

• Logical Replication
• Logical Streaming Replication Protocol
• Semab Tariq, Stormatics, 2026-06-16: How To Run Logical Replication On A Production PostgreSQL Cluster

PostgreSQL high availability setups

• High Availability, Load Balancing, and Replication
• A Comparison of High Availability PostgreSQL Solutions
• Why PostgreSQL High Availability Matters and How to Achieve It

Cluster manager

Patroni

Based on PostgreSQL (physical) Streaming Replication (async or sync).

• Mouhamadou Diaw, dbi services, 2021-02-03: PostgreSQL High Availability: Patroni, Ectd , HAProxy , Keepalived
• Mehman Jafarov, 2025-11-14: PostgreSQL High Availability in Action
• Patroni: Replication modes
• Ibrar Ahmed, pgEdge, 2024-05-22: Achieving PostgreSQL High Availability: Strategies, Tools, and Best Practices

Patroni + etcd HaProxy PgBouncer

etcd or Zookeeper

https://www.dbi-services.com/blog/setup-a-two-node-postgres-ha-cluster-using-edb-advanced-server-and-efm/ https://indico.cern.ch/event/1471762/contributions/6280213/attachments/2998599/5283395/P-DBI-E-20240323-PGconf-Architecture-for-Seamless-PostgreSQL-Upgrades.pdf https://www.dbi-services.com/blog/the-dbi-services-postgresql-reference-architecture-1-the-commercial-approach/ https://www.dbi-services.com/blog/the-dbi-services-postgresql-reference-architecture-2-the-community-approach/

• Semab Tariq, Stormatics, 2026-06-12: When Patroni Silently Deletes Your Replication Slots EDB: Multi-master replication https://www.enterprisedb.com/docs/eprs/latest/02_overview/02_replication_concepts_and_definitions/04_mmr_replication/ EDB: EDB Postgres Distributed (PGD): https://www.enterprisedb.com/docs/pgd/latest/ Understanding Multi-Master Architecture in PostgreSQL: Benefits and Trade-offs: https://stormatics.tech/blogs/understanding-multi-master-architecture-in-postgresql-benefits-and-trade-offs

Proxy / Load balancer

• Which PostgreSQL HA Solution Fits Your Needs: Pgpool or Patroni?

PostgreSQL 16 Brings Native Load Balancing to libpq for Improved Scalability https://medium.com/@mydbopsdatabasemanagement/postgresql-16-brings-native-load-balancing-to-libpq-for-improved-scalability-54a0a2588552

https://dhamaniasad.github.io/awesome-postgres/ https://github.com/stars/tbussmann/lists/postgresql

mails von daniel und tobias

Pgpool-II

https://www.pgpool.net/docs/latest/en/html/example-cluster.html

Based on PostgreSQL Streaming Replication

Slony-I

(outdated?) https://www.slony.info/ https://wiki.postgresql.org/wiki/Slony

HAproxy

…

ProxySQL

https://proxysql.com/documentation/proxysql-configuration-postgresql/

Spock pgEdge (Enterprise) https://docs.pgedge.com/spock-v5/development/install_spock/#creating-a-replication-scenario

EDB Failover manager

https://www.reddit.com/r/PostgreSQL/comments/1j0chnt/what_solution_do_you_use_for_automatic_failover/

Introduction to pg_auto_failover (Citus) https://pg-auto-failover.readthedocs.io/en/main/intro.html

Repmgr https://wiki.postgresql.org/wiki/Repmgr