Postgres High Availability Cluster Management
Cluster Management software enables Postgres to keep serving up data even when hardware fails, so you can keep your applications and users up and running. However, not all cluster management solutions are equal when it comes to maintaining your operational resiliency.
EDB High Availability Solutions
EDB Postgres Distributed (PGD)
EDB’s Always On solution with up to 99.999% high availability for leveraging active-active architecture, whether self-managed (EDB Postgres Advanced Server, EDB Postgres Extended Server or PostgreSQL) or fully-managed (EDB BigAnimal).
Failover Manager
A streaming replication tool that can be used for virtual IP management, event notifications using SNMP/email, and is customizable with scripts.
Replication Manager (repmgr)
An open-source tool suite for managing replication and failover in a cluster of PostgreSQL servers. Repmgr is not certified for EDB Postgres Advanced Server.
Patroni
An open-source template for high availability PostgreSQL solutions using streaming physical replication.
Cluster Management Without the Hassle
With EDB BigAnimal, we manage clusters for you to keep your applications running in the cloud.
Not ready for fully managed?
Self-manage your Postgres clusters with EDB Postgres Distributed - on-premises, in the cloud or in a hybrid environment.
High Availability cluster management software can be classified into Always On multi-master and Primary-standby solutions
| EDB Postgres Distributed (PGD) |
Failover Manager/Repmgr/Patroni |
|
|---|---|---|
| Architecture | Multi Master and Primary Standby | Primary Standby |
| Number of concurrent writable nodes | One or More | One |
|
Availability |
Best in class - up to 99.999% (self-managed) and 99.995% on BigAnimal | up to 99.99% availability |
|
Replication Type |
Logical - PGD has up to 5X throughput than native logical replication | Physical Streaming Replication (PSR) only |
|
Consistency |
"Asynchronous or Synchronous (Custom Options - CAMO, Group Commit, Eager)" |
Asynchronous or Synchronous |
|
Rolling Upgrades |
Yes | No |
|
Cross Version Compatibility |
Yes | No |
|
Support for Data Sovereignty |
Yes | No |
|
Support for Selective Data Replication |
Yes | No |
|
Multi-cloud Deployment |
Yes | Yes |
|
Multiple data centers |
Yes | Yes |