Ecosystem:PostgreSQL only:Replication

From PostgreSQL wiki

Jump to: navigation, 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) -- 2018-06-25
  • Description --Postgres-BDR (Bi-Directional Replication for PostgreSQL) is a ground-breaking multi-master replication tool for PostgreSQL databases that has been in full production status since 2014. In the complex environment of replication, BDR achieves efficiency and accuracy, ensuring very high availability of all nodes in a geographically distributed cluster.
  • 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) -- 2018-03-20
  • 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) -- 2018-03-09
  • 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
Personal tools