[Djigzo users] bucardo swap master to master sync: must specify a primary key

Валера Харсеко vharseko at xxlive.ru
Tue Apr 19 14:30:45 CEST 2011


root at netsys-m9 ~]# bucardo_ctl add sync netsys_m9_v6 source=netsys_m9 targetdb=netsys_v6 type=swap --verbose
NOTICE:  Issuing rollback() due to DESTROY without explicit disconnect() of DBD::Pg::db handle dbname=netsys;host=netsys-m9;port=5432 at line 29.

CONTEXT:  SQL function "validate_sync" statement 1
SQL statement "SELECT validate_sync('netsys_m9_v6')"
Failed to add sync: DBD::Pg::st execute failed: ERROR:  error from Perl trigger function: error from Perl function: Table "public.certificates_email" must specify a primary key when using a sync of 'swap' at line 263. at line 30. at /usr/bin/bucardo_ctl line 3362.


FIX conf/djigzo.sql

alter table certificates_email add primary key (certificates_id);
alter table mail_repository_recipients add primary key (id);
alter table userpreferences_named_certificates  add primary key (userpreferences_id);

[root at netsys-m9 ~]# bucardo_ctl add sync netsys_m9_v6 source=netsys_m9 targetdb=netsys_v6 type=swap --verbose
Added sync "netsys_m9_v6"
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 3733 bytes
Desc: not available
URL: <http://lists.ciphermail.com/pipermail/users/attachments/20110419/c5901a96/attachment-0001.p7s>


More information about the Users mailing list