Friday, May 22, 2020

[google-cloud-sql-discuss] Re: What is the replication mode for Postgres Cloud SQL read replicas?

Postgres uses Write Ahead Logs for it's replication. Based on the Postgres documentation that you provided, we notice that this method is Streaming Replication and is asynchronous. More details regarding Write Ahead Logs can be found on our community docs[1].

The value of the synchronus_commit flag is on, as is set by default[2].

I hope this helps.

[1]: https://cloud.google.com/community/tutorials/setting-up-postgres-hot-standby#understanding_hot_standby

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/ecc1c697-8496-4c50-96b8-df6ffd13158c%40googlegroups.com.

No comments:

Post a Comment