Hi Jay, Bucardo uses triggers to capture data changes (and clean up after itself) so it has to run on a writeable server.
What is the use case you’re looking at, and what are the versions of the databases involved? Best, David -- David Christensen Senior Software and Database Engineer End Point Corporation [email protected] 785-727-1171 > On Oct 16, 2020, at 10:35 AM, jay saini <[email protected]> wrote: > > Hi David, > > Thanks for your reply. I have tested both the writable dbs and it works fine > for me. The use case is to use read only replica (slave) which will act as > source and replicate it to writable db? Is this possible with Bucardo? Or we > need to have both the dbs as Writable. > > Expecting your response on this. > > Regards > Jaydeep > > On Fri, 16 Oct 2020 at 8:09 PM, David Christensen <[email protected]> wrote: > 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
signature.asc
Description: Message signed with OpenPGP
_______________________________________________ Bucardo-general mailing list [email protected] https://bucardo.org/mailman/listinfo/bucardo-general
