Ecosystem:PostgreSQL only:Replication

From PostgreSQL wiki
Jump to navigationJump to search

Postgres-BDR®

  • Provider -- 2ndQuadrant
  • Website -- https://www.2ndquadrant.com/
  • License -- Proprietary
  • Interoperability level -- explicitly supports PostgreSQL 9.4 or higher
  • Verified PostgreSQL versions -- https://www.2ndquadrant.com/en/resources/bdr/
  • Last update (YYYY-MM-DD) -- 2020-08-14
  • Description -- Postgres-BDR® from 2ndQuadrant is a ground-breaking multi-master technology stack that presents true high availability (up to six 9s) for mission critical databases running on PostgreSQL. It supports geographically distributed clusters and provides efficient replication for both DDL and DML with automatic conflict resolution.
  • Additional info -- click here

pglogical

  • Provider -- 2ndQuadrant
  • Website -- https://www.2ndquadrant.com/
  • License -- The PostgreSQL Licence
  • Interoperability level -- explicitly supports PostgreSQL 9.4 or higher
  • Verified PostgreSQL versions -- https://www.2ndquadrant.com/en/resources/pglogical/
  • Last update (YYYY-MM-DD) -- 2020-10-05
  • Description -- pglogical is a logical replication system implemented entirely as a PostgreSQL extension. Fully integrated, it requires no triggers or external programs. This alternative to physical replication is a highly efficient method of replicating data using a publish/subscribe model for selective replication.
  • Additional info -- click here

repmgr

  • Provider -- 2ndQuadrant
  • Website -- https://www.2ndquadrant.com/
  • License -- GPL v3
  • Interoperability level -- explicitly supports PostgreSQL 9.1 or higher
  • Verified PostgreSQL versions -- https://www.2ndquadrant.com/en/resources/repmgr/
  • Last update (YYYY-MM-DD) -- 2020-04-13
  • Description -- repmgr helps DBAs and System Administrators manage a cluster of PostgreSQL databases. It simplifies administration and daily management, enhances productivity and reduces the overall costs of a PostgreSQL cluster.
  • Additional info -- click here