Hi All. I am trying to setup master master replication using bucardo. i have just set this up successfully but while testing i came to know that bucardo takes too long time to write data, and due to this slow process i am getting "duplicate key value violates unique constraint" error.
how to fix this error, i mean how to make this process smoother. i have one script which writes 10 records. below are the steps. bucardo_ctl add db node1 host=192.168.1.61 bucardo_ctl add db node2 host=192.168.1.62 bucardo_ctl add all tables db=node1 herd=node1_herd bucardo_ctl add sync node1_to_node2 type=pushdelta source=node1_herd targetdb=node2 bucardo_ctl add all tables db=node2 herd=node2_herd bucardo_ctl add sync node2_to_node1 type=pushdelta source=node2_herd targetdb=node1 After just executing this script on one system when i am trying to run same script on another system its giving below errors. root@juned:~# php psql.php PHP Warning: pg_query(): Query failed: ERROR: duplicate key value violates unique constraint "ip_map_id_pkey" DETAIL: Key (id)=(76) already exists. in /root/psql.php on line 18 PHP Warning: pg_query(): Query failed: ERROR: duplicate key value violates unique constraint "ip_map_id_pkey" DETAIL: Key (id)=(77) already exists. in /root/psql.php on line 18 PHP Warning: pg_query(): Query failed: ERROR: duplicate key value violates unique constraint "ip_map_id_pkey" DETAIL: Key (id)=(78) already exists. in /root/psql.php on line 18 PHP Warning: pg_query(): Query failed: ERROR: duplicate key value violates unique constraint "ip_map_id_pkey" But after 2-3 trials it works, it inserts records. that means its taking much time to write data. How make this process faster ? -- Thanks, Juned Khan <http://www.inextrix.com/>
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
