Hi Jay, You need to target a writable database since it is trying to insert rows; you can’t use a readonly standby for the target. Could you use the source for the readonly standby as the target?
Best, David > On Oct 16, 2020, at 8:26 AM, jay saini <[email protected]> wrote: > > > 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
_______________________________________________ Bucardo-general mailing list [email protected] https://bucardo.org/mailman/listinfo/bucardo-general
