HOWTO: Provision PostgreSQL HA with pgBackRest and Patroni¶
The PostgreSQL HA reference path applies the HybridOps database-availability contract through a primary, streaming replica, pgBackRest repository, and Patroni-managed failover. This HOWTO covers module inputs, DCS integration, preflight, ordered deployment, and cluster-state verification from the run record. The same contract continues into the DR failover and failback paths.
What this covers:
- PostgreSQL HA cluster provisioning via
platform/onprem/postgresql-ha@v1with Patroni and pgBackRest - Module input map: node count, DCS backend, replication slots, and pgBackRest repository target
- Post-deployment validation: Patroni cluster status, replication lag, and pgBackRest stanza check