PostgreSQL Software
:Cluster ManagementCluster Management software enables Postgres to keep serving up data even when hardware fails, allowing you to keep your applications and users up and running.
Postgres-BDR
Postgres-BDR provides true high availability for PostgreSQL databases, providing up to five 9s of availability and flexible deployment options.
Also supported by EDB
Failover Manager
An EDB tool for managing high availability for PostgreSQL and EDB Postgres Advanced clusters using physical streaming replication on Linux
Replication Manager (repmgr)
An open-source tool for creating and managing PostgreSQL and EDB Postgres Extended clusters using physical streaming replication on Linux
Feature Comparison | Postgres-BDR | Failover Manager | repmgr |
|---|---|---|---|
Continuous availability | |||
Automatic failover | |||
Manages multi-master BDR clusters | |||
Manages primary/standby streaming replication clusters | |||
Protection against common split-brain scenarios | |||
Quorum and consensus resolution | |||
Set up new standbys with a single command | |||
Switchover with a single command | |||
Enables 99.999% availability requirements | |||
Configure prioritization rules for which standby to promote | |||
Reconfigure standbys to follow newly promoted primary | |||
Reconfigure synchronous replication parameters on cluster changes | |||
Event logging for cluster events | |||
Virtual IP management | |||
Built-in integration for traffic routing management | |||
Event notifications using SNMP and email | |||
Customizable with scripts |