[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