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@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"
>
>
> --
> Djigzo open source email encryption
> _______________________________________________
> Users mailing list
> [email protected]
> http://lists.djigzo.com/lists/listinfo/users
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ Users mailing list [email protected] http://lists.djigzo.com/lists/listinfo/users
