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 offers solutions to maximize availability and operational resiliency to zonal or regional failures, while also supporting open-source. See table for details.

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

Ready to get started?

Sign up for an EDB account to access free trials, software, training and support. Signing up is free and takes less than 60 seconds.