[Pgpool-general] Pgpool-general Digest, Vol 64, Issue 8

[Muhammad Isnaini]

> 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" ?.