Ecosystem:PostgreSQL only:Clustering
From PostgreSQL wiki
Jump to navigationJump to searchEDB Postgres Failover Manager
- Provider -- EnterpriseDB Corporation
- Website -- https://www.enterprisedb.com/products/edb-postgres-platform/edb-postgres-failover-manager
- License -- proprietary
- Interoperability level -- explicitly supports PostgreSQL 9.5 or higher
- Verified PostgreSQL versions -- See: https://www.enterprisedb.com/services/edb-supported-products-and-platforms#EFM
- Last update (YYYY-MM-DD) -- 2017-6-7
- Description -- Failover Manager creates highly available fault tolerant clusters minimizing database downtime with health monitoring, failure detection/notification, and automatic failover required in stringent 9s based high availability solutions. A simple and lightweight architecture without a single point of failure protects against a variety of failure scenarios that can be customized to specific application needs.
- Additional info -- click here
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