[Bucardo-general] BUCARDO and BDR

David Christensen david at endpoint.com
Thu Apr 11 18:40:47 UTC 2019

> 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

There are unique constraints for some of these which could be turned into PKs instead;

- bucardo_delta_names (sync, tablename)
- bucardo_delta_targets (tablename, target)  (technically not unique, but could probably be so)
- bucardo_sequences (schemaname, seqname, syncname, targetname)
- bucardo_truncate_trigger (sync, tablename)   (not unique, but could probably be so)
- bucardo_truncate_trigger_log (tablename, sname, tname, sync, target)  (not unique but could probably be so)

I can’t guarantee that this will definitely work with the above, but I would expect that it should probably work. :)


David Christensen
End Point Corporation
david at endpoint.com

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: Message signed with OpenPGP
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20190411/937df6aa/attachment.sig>

More information about the Bucardo-general mailing list