root@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@netsys-m9 ~]# bucardo_ctl add sync netsys_m9_v6 source=netsys_m9
targetdb=netsys_v6 type=swap --verbose
Added sync "netsys_m9_v6"
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ Users mailing list [email protected] http://lists.djigzo.com/lists/listinfo/users
