<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body dir="auto">Hi Jay,<div><br></div><div>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?<br><br><div dir="ltr">Best,</div><div dir="ltr"><br></div><div dir="ltr">David</div><div dir="ltr"><br><blockquote type="cite">On Oct 16, 2020, at 8:26 AM, jay saini <jay00725@gmail.com> wrote:<br><br></blockquote></div><blockquote type="cite"><div dir="ltr"><div dir="ltr"><p style="margin-top:0px;margin-right:0px;margin-left:0px;padding:0px;border:0px;font-variant-numeric:inherit;font-variant-east-asian:inherit;font-stretch:inherit;line-height:inherit;font-family:Arial,"Helvetica Neue",Helvetica,sans-serif;font-size:15px;vertical-align:baseline;box-sizing:inherit;clear:both;color:rgb(36,39,41)">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:</p><p style="margin-top:0px;margin-right:0px;margin-left:0px;padding:0px;border:0px;font-variant-numeric:inherit;font-variant-east-asian:inherit;font-stretch:inherit;line-height:inherit;font-family:Arial,"Helvetica Neue",Helvetica,sans-serif;font-size:15px;vertical-align:baseline;box-sizing:inherit;clear:both;color:rgb(36,39,41)">root@ip-172-31-XX-XX:~# <strong style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;box-sizing:inherit">bucardo add sync test relgroup=herd_pg dbs=SRC,DEST_SLAVE</strong></p><p style="margin-top:0px;margin-right:0px;margin-left:0px;padding:0px;border:0px;font-variant-numeric:inherit;font-variant-east-asian:inherit;font-stretch:inherit;line-height:inherit;font-family:Arial,"Helvetica Neue",Helvetica,sans-serif;font-size:15px;vertical-align:baseline;box-sizing:inherit;clear:both;color:rgb(36,39,41)"><em style="margin:0px;padding:0px;border:0px;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;box-sizing:inherit">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.</em></p><p style="margin-top:0px;margin-right:0px;margin-left:0px;padding:0px;border:0px;font-variant-numeric:inherit;font-variant-east-asian:inherit;font-stretch:inherit;line-height:inherit;font-family:Arial,"Helvetica Neue",Helvetica,sans-serif;font-size:15px;vertical-align:baseline;box-sizing:inherit;clear:both;color:rgb(36,39,41)">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.</p><p style="margin:0px;padding:0px;border:0px;font-variant-numeric:inherit;font-variant-east-asian:inherit;font-stretch:inherit;line-height:inherit;font-family:Arial,"Helvetica Neue",Helvetica,sans-serif;font-size:15px;vertical-align:baseline;box-sizing:inherit;clear:both;color:rgb(36,39,41)">Looking forward for response</p></div>
<span>_______________________________________________</span><br><span>Bucardo-general mailing list</span><br><span>Bucardo-general@bucardo.org</span><br><span>https://bucardo.org/mailman/listinfo/bucardo-general</span><br></div></blockquote></div></body></html>