Google Cloud SQL Postgres(Set Session_Replication_Role='Replica') || Bucardo

Asked Nov 01 '18 at 20:22

Active Nov 01 '18 at 21:57

Viewed 431 times

I'm trying to replicate the PostgresDB from AWS to GoogleCloudSQL using Bucardo in order to avoid live transactions.

Here, Bucardo needs to set session_replication_role='replica' using user credentials on googlecloudsql postgres user. The postgres user on cloudsql needs superuser privileges to do this.

Is their any other way we could set role using any other users?

edited Nov 01 '18 at 21:57

Pierre Arlaud

4,040
3
28
42

asked Nov 01 '18 at 20:22

Satish Athukuri

Any new findings on this? – Jonathan Lin Dec 05 '18 at 09:47
1

Ruby rep framework supports replication without superuser privileges. I did used #ruby-rep [http://www.rubyrep.org] instead #bucardo. But both were trigger based. – Satish Athukuri Dec 06 '18 at 21:09
Thanks for this lead. Will check it out! – Jonathan Lin Dec 07 '18 at 02:02

Google Cloud SQL Postgres(Set Session_Replication_Role='Replica') || Bucardo

0 Answers0

Linked