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@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
_______________________________________________ Bucardo-general mailing list [email protected] https://bucardo.org/mailman/listinfo/bucardo-general
