[Bucardo-general] BUCARDO and BDR
Mauricio Tassara
mtassara at jusrionegro.gov.ar
Thu Apr 11 16:47:53 UTC 2019
Hi David,
BDR allows you to replicate specific tables on specific schemas, but the
need to create primary keys applies to the entire database independently
that some tables will not replicate.
We did the following test and it worked: 1) We configured Bucardo defining
the master database on an installation without BDR.
2) We defined primary keys for all delta_xxxx, stage_xxxx and track_xxxx
tables.
3) We defined tentative primary keys for the bucardo's tables:
bucardo.bucardo_delta_names
bucardo.bucardo_delta_targets
bucardo.bucardo_sequences
bucardo.bucardo_truncate_trigger
bucardo.bucardo_truncate_trigger_log
4) We imported the modified bucardo schema in the database with BDR.
5) We added a synchronization with the database with BDR and everything
worked correctly.
We would like to validate with you the primary kyes to assign to the
Bucardo's tables detailed in step 3 to avoid problems in the future. Wich
fields should we select as primary key for each Bucardo's tables?
Thank you.
-----Mensaje original-----
From: David Christensen
Sent: Wednesday, April 03, 2019 6:23 PM
To: Mauricio Tassara
Cc: bucardo-general at bucardo.org List ; Gustavo Motti
Subject: Re: [Bucardo-general] BUCARDO and BDR
More information about the Bucardo-general
mailing list