Ecosystem:PostgreSQL only:Clustering

From PostgreSQL wiki
Jump to navigationJump to search

EDB Postgres Failover Manager

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

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

Pgpool-II

  • Provider -- Pgpool-II Global Development Group
  • Website -- https://pgpool.net
  • License -- PostgreSQL License
  • Interoperability level -- PostgreSQL 7.3 or higher
  • Verified PostgreSQL versions -- PostgreSQL 7.3 or higher
  • Last update (YYYY-MM-DD) -- 2018-04-26
  • Description -- Pgpool-II is a cluster management tool for PostgreSQL. It provides features currently lacking in PostgreSQL: automatic failover, automatic query dispatching to master (primary) server and standby servers, load balancing for SELECTs, session level connection pooling, in memory query cache and more. Pgpool-II is mostly transparent to non-cluster-aware PostgreSQL applications. Also Pgpool-II provides built-in High Availability feature to protect Pgpool-II itself.
  • Additional info -- click here