4

From my understanding of their documentation, the cloud postgresql service, being beta, does not yet support external replicas, which is what i thought i could use if i wanted a database to be replicated cross region.

This could very well end up being a blocker for our setup, since we need the data in separate regions.

I thought i'd investigate all the streaming replication options out there, and perhaps find one that does not require touching the host folder or custom config wise, which in my mind would end up looking like

master => streaming_replication_app => slave

but what from I've researched so far, no real streaming replication options are possible that are non intrusive.

Can you guys confirm or deny this and point me in the right direction? I need to decide if the Cloud postgres is too limited as a solution or not

Thanks in advance, Gabriel

omu_negru
  • 4,642
  • 4
  • 27
  • 38

1 Answers1

0

Cross region replica is supported in Google Cloud Sql.

https://cloud.google.com/blog/products/databases/introducing-cross-region-replica-for-cloud-sql

user2760286
  • 1
  • While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes. - [From Review](/review/late-answers/32348303) – bfris Jul 31 '22 at 22:36