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

Валера Харсеко vharseko at xxlive.ru
Thu Apr 21 11:51:04 CEST 2011


We use for production NetSys
Very good decision for asynchronous the master to the master of replication with system of a resolution of conflicts: http://bucardo.org/ wiki/Swap

20.04.2011, в 1:22, Martijn Brinkers написал(а):

> Interesting. I will check whether I can add the primary keys. Right now
> the SQL schema is generated by Hibernate. I need to add these just after
> the schema is generated.
> 
> It's the first time I read about bucardo and it's interesting because
> they say it can work as multi-master. Do you have it running or are you
> still experimenting? is it reliable?
> 
> Kind regards,
> 
> Martijn
> 
> On 01/-10/-28163 08:59 PM, Валера Харсеко wrote:
>> 
>> 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"
> 
> 
> -- 
> Djigzo open source email encryption
> _______________________________________________
> Users mailing list
> Users at lists.djigzo.com
> http://lists.djigzo.com/lists/listinfo/users

-------------- 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/20110421/1a19d1be/attachment-0001.p7s>


More information about the Users mailing list