> 1) Start postgres node2 > 2) Start postgres node1 > 3) start pgpool (node1) > 4) From a remote terminal (client1): > for i in $(seq 0 2000); do { echo $(date +%H:%M:%S); psql > -d database -p > 9999 -h 192.168.1.5 -U postgres -c "insert into pri values > ($i, 'nom$i');"; > echo $i; sleep 1; }; done > 5) Unplug node2 > Here the inserts on client terminal stops. It restarts more > or less 5 min > and a half later. > 6)After 10 second (more or les) after unplug the > wire, From a remote > terminal (client2): > for i in $(seq 0 2000); do { echo $(date +%H:%M:%S); psql > -d database -p > 9999 -h 192.168.1.5 -U postgres -c "insert into pri values > ($i, 'nom$i');"; > echo $i; sleep 1; }; done > Works perfectly!! I mean, pgpool is not blocked, it > works,... there is just > some problem in the first session.
Is there any lost execution / data in table "pri" ?. _______________________________________________ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general