[Pgcluster-general] PGcluster recovery error with -R option

Pedro Delgado pdelgado at iten.es
Thu Jul 2 08:17:24 UTC 2009


Hi, I configured pgcluster with 2 data base servers.
All it works fine, but when I start a database in recovery mode con -R option and I make a lot of insert/update in the other database, I lost some rows in the process.
This problem it's so stragne because a big number of rows are correctly replicated when the data base it's in recovery mode, but a few number no. 
I tryed tu insert 100 rows in the started database when one data base it's recoveryng with -R. When the process ended i checked the content of two databases. The first (active) have the 100 rows, the second (recover) have 96 rows, it lost four rows.
This fail it's critical because the database cluster it's inconsistent.
Some one know about this problem? it's that a problem o a configuration error? 
In my configuration all the features works fine (cluster, load balancer, replication server) and i think that it's a bug of pgcluster, but I'm not sure.
If some one can help me I'll be very agreed.
Greetings.


More information about the Pgcluster-general mailing list