[Pgcluster-general] Duplicate inserts, cluster node no recovering

Raúl Alexis Betancor Santana rabs at dimension-virtual.com
Mon Jun 4 06:13:10 UTC 2007


Hi all, I'm testing PostgreSQL 8.2.4 with PGCluster 1.7.0rc5 patch.

My setup is 2 lb + 2 db node + 2 replicator

What happens to me is that if I connect to the first LB with client software, 
all insert queries are duplicated, so I ended with a messed database with 
duplicate rows on my tables.

I had tryied with lb1, db1, db2 and rep1 up, without rep2 and lb2 with the 
same results.

I have followed pgcluster.org examples for the conf files.

Testing platform is Debian Etch(64 bits version) on AMD64 DualCore, 8Gb RAM

Any hints for debugging this .. ?

-- 
Saludos.

Raúl Alexis Betancor Santana
Dimensión Virtual S.L.


More information about the Pgcluster-general mailing list