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

[David Christensen]

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 <jay00725 at gmail.com> 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 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
> _______________________________________________
> Bucardo-general mailing list
> Bucardo-general at bucardo.org
> https://bucardo.org/mailman/listinfo/bucardo-general
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20201016/d59e79df/attachment.htm>