Skip to content

HOWTO: Provision a Cloud SQL Standby for PostgreSQL DR

Cloud SQL is the managed PostgreSQL standby in the HybridOps DR architecture — the failover target when the on-prem cluster is unavailable and recovery time matters most. This HOWTO covers provisioning the Cloud SQL instance through the HybridOps gcp/cloudsql-dr-standby module, configuring the logical replication feed from the on-prem primary, wiring the Cloud SQL health signal into the DR decision service, and validating connectivity before the first drill. The Cloud SQL path is one of the two PostgreSQL DR lanes in the HybridOps architecture.

What this covers:

  • Cloud SQL instance provisioning via gcp/cloudsql-dr-standby with Terraform-managed configuration
  • Logical replication feed configuration from on-prem primary to Cloud SQL standby
  • Health signal wiring into the DR decision service and pre-drill connectivity validation

Learn this in Academy: Disaster Recovery Automation track