24/7 database uptime for PostgreSQL.

Failover and disaster recovery without application programming changes.

OpenSCG’s recommended High Availability solution for PostgreSQL is based on Patroni and included in the BigSQL package manager. This proven template leverages PostgreSQL’s native streaming replication and pgBouncer to provide a robust HA configuration. It efficiently supports multiple read-only slaves, seamless DDL replication, and various failover and disaster recovery modes of operation on Linux.

Key features:

  • monitor the states of primary, standby, and app servers

  • load balancing and failover

  • single button actions

  • an enjoyable experience that just works

  • the capability to eliminate repetitive tasks

  • architecture that behaves as documented


OpenSCG’s pgHA - High Availability Solution
Try It Now