[Bucardo-general] Bucardo Postgres Replication from Master to Slave Read Only Replica

[jay saini]

I have successfully performed replication from Master to Master from
Bucardo. I am stucked in Master-Slave replication. When I am trying to add
a sync it gives me the following error:

root at ip-172-31-XX-XX:~# *bucardo add sync test relgroup=herd_pg
dbs=SRC,DEST_SLAVE*

*WARNING: Issuing rollback() due to DESTROY without explicit disconnect()
of DBD::Pg::db handle dbname=migratedb;host=35.243.157.109;port=5432 at
line 207. Failed to add sync: DBD::Pg::st execute failed: ERROR:
DBD::Pg::db do failed: ERROR: cannot set transaction read-write mode during
recovery at line 207. at line 30. CONTEXT: PL/Perl function "validate_sync"
at /usr/bin/bucardo line 4670.*

To give you more context: My master is AWS Aurora Postgres RDS and My slave
is on Google CloudSQL which is a read-only replica.

Looking forward for response
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20201016/8545adc7/attachment.htm>