Automating multi region Cloud SQL for PostgreSQL failover (read replica promotion) using Terraform

[slaksh10]

Hello All,

As anyone used Terraform to automate your multi region Cloud SQL for PostgreSQL failover (read replica promotion) using Terraform? If so, How did you manage to keep the TF state file always in SYNC?

regards,

Sridhar

[christianpaula]

Hi @slaksh10,

Welcome to Google Cloud Community!

You may wanna check this documentation about Using Cloud SQL cross-region replicas. However, for the "TF state file can be synced" you can reach out to Terraform Support and file a ticket.  You may can also check their community to find a similar case of yours.

Thanks

[slaksh10]

Yes we have tested the cross region failover which is working. but we wanted it to be implemented in terraform.