[Bucardo-general] Infromation how can run master-master replication system with sync=swap

francescoboccacci at libero.it francescoboccacci at libero.it
Wed Nov 17 13:27:49 UTC 2010


Hi,
i try to create a master-master replication system.

I create 2 database bucardo1 and bucardo 2 (have the same structure and both 
empty).

These are the command that i run:

1 -bucardo_ctl install --piddir=/tmp/bucardo (and after i press P)


2 -bucardo_ctl add db bucardo1

3 -bucardo_ctl add db bucardo2


4 -bucardo_ctl add table users db=bucardo1 herd=all

5 - bucardo_ctl add sync master_master source=all targetdb=bucardo2 type=swap


but at this time i received this error


NOTICE:  Issuing rollback() due to DESTROY without explicit disconnect() of 
DBD::Pg::db handle dbname=bucardo1;port=5432 at line 29.

CONTEXT:  SQL statement "SELECT validate_sync('master_master')"
Failed to add sync: DBD::Pg::st execute failed: ERROR:  error from Perl 
function "validate_sync": error from Perl function "validate_sync": Table 
"public.users" must specify a way to handle conflicts at line 285. at line 30. 
at /usr/local/bin/bucardo_ctl line 3349.


How can set and handle the conflict between both databases?
Where and when i wrong?

Thanks

Francesco Boccacci



More information about the Bucardo-general mailing list