Synchronous replication

Google Cloud Database
1

Hello Everyone,

We have a requirement to implement multi-region DB for PostgreSQL database. Already we have a database in one region and to achieve HA, i am looking for an read replica for primary database in another region.

But I have a question on how can we implement synchronous replication between primary DB and read replica which is absolutely in another region. Please help.

Thanks & Regards

Srivatsasa

2

Cloud SQL for Postgres is using streaming replication which is asynchronous by default. You can get some information how to check and monitor the replication mode and lag on the documentation page

https://cloud.google.com/sql/docs/postgres/replication/replication-lag

Thanks