Skip to content

HOWTO: Provision PostgreSQL HA with pgBackRest and Patroni

This HOWTO covers deploying a production-grade PostgreSQL HA cluster through the HybridOps platform module — primary, streaming replica, and pgBackRest repository node, orchestrated by Patroni with automatic failover. You will work through the module inputs, understand how Patroni DCS integration is configured, run the deployment with full preflight coverage, and validate the cluster state from the run record. The same module underpins the DR failover and failback workflows in Track 06.

What this covers:

  • PostgreSQL HA cluster provisioning via platform/onprem/postgresql-ha@v1 with 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

Learn this in Academy: Platform Services track