[Bucardo-general] Replication of tables without primary keys

Joseph W jbw at hilltopgroup.com
Tue Sep 13 02:07:44 UTC 2016

Hi all,

I'm attempting to get a redundant Davical installation online (I have a
standalone installation my company has been using for several years) and
after a lot of searching, Bucardo looked like the best of the
master-master postgres replication solutions I could find.

Davical, unfortunately, has several tables with no primary key or unique
ID; I of course find this out after I've gotten all the way to creating
the Bucardo sync between the two devices.

The first table it got to without a primary key threw the following message:

Failed to add sync: DBD::Pg::st execute failed: ERROR:  Table
"public.addressbook_address_adr" must specify a primary key! at line
117. at line 30.
CONTEXT:  PL/Perl function "validate_sync" at /usr/local/bin/bucardo
line 4612

Is there anything I've missed so far as making Bucardo replicate those
tables, or do I have to look for another solution (and if that's the
case, does anyone have a suggestion so far as tools go)? 



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20160912/69755dde/attachment.html>

More information about the Bucardo-general mailing list