[Bucardo-general] Primary Key Collisions in Multi-Master Environment

Rodrigo Rodovalho rodrigo.rodovalho at gmail.com
Mon Apr 12 19:48:39 UTC 2021


I have two Postgres instances running in a multi-master environment. It
works but my application keeps getting violations of unique constraint in
the primary keys when simultaneous changes are made in each of the DB
instances at the same time.

At this point I just would like to separate the origin of this issue: is it
my web framework of choice  (Django) that keeps the last sequential primary
key stored in some memory variable, or is it something in Bucardo that I

Users of Django or others frameworks, do you experience some issues like
this? I'm also using Django REST.

Thanks in advance for any help!

Ps.: I'm also posting in some Django forums about this and promise to add
here if anything helpful comes up.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20210412/7faa27b6/attachment.htm>

More information about the Bucardo-general mailing list