Hi, Is there a way to exclude specific schemas from BDR replication or is it all-or-nothing? From what I could see, it looks like you can set up replication sets and the like, but maybe it’s a different version.
Could you instead disable DDL replication in BDR so the new tables aren’t considered for replication? Again, I have no hands-on experience with BDR. It shouldn’t be too hard to define PKs on the delta tables, etc (though it will likely incur a slowdown of sorts, as you now need to not just add rows to tables, you need to update a unique index on *every* row change, so it’ll add up speed-wise, prob the reason they don’t have them to begin with. HTH, David > On Apr 3, 2019, at 6:49 AM, Mauricio Tassara <[email protected]> > wrote: > > Thanks David, > > A comment about your answer: The master will be the same database, but we are > targeting different databases with BDR and Bucardo, so we will not have > conflicts in replay if the same rows were changed by different replication > tools. > > Advancing with Bucardo's configuration on a master database with BDR, we have > one drawback: the tables created in the database with BDR must have a primary > key, otherwise it is not possible to perform UPDATE or DELETE operations. > > So, when we add a synchronization with Bucardo, defining as Master a database > with BDR, the bucardo scheme is created with the tables bucardo_xxx and > tables delta_xxxx, stage_xxxx and track_xxxx, but all of them without Primary > Key. > > Then the following error occurs: > WARNING: Issuing rollback() due to DESTROY without explicit disconnect() of > DBD::Pg::db handle dbname=test_reforma;host=xxx.xx.xxx.x;port=5432 at line > 833. > Failed to add sync: DBD::Pg::st execute failed: ERROR: DBD::Pg::db do > failed: ERROR: Cannot run UPDATE or DELETE on table bucardo_delta_targets > because it does not have a PRIMARY KEY. > HINT: Add a PRIMARY KEY to the table at line 833. at line 30. > CONTEXT: PL/Perl function "validate_sync" at /usr/local/bin/bucardo line > 4670. > > Can you think of a possible solution? > > Are there possibilities that the bucardo scheme and its tables are created on > a database different from the one that will act as master? To use one without > BDR. > > Or would it be possible to define primary keys to the tables in the bucardo > schema? > > Thank you very much! > > -----Mensaje original----- From: David Christensen > Sent: Monday, April 01, 2019 12:13 PM > To: Mauricio Tassara > Cc: [email protected] ; Gustavo Motti > Subject: Re: [Bucardo-general] BUCARDO and BDR > -- David Christensen End Point Corporation [email protected] 785-727-1171
signature.asc
Description: Message signed with OpenPGP
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
