<br>Hi all pgcluster users :)<br><br>I am evaluating pgcluster ( postgresql-8.3.0 + pgcluster-1.9.0rc1-patch<span></span> )<br><br>the setup consists of 2x clusterdb, 2x pgreplicate and one pglb. <br>(this makes 3 physical hosts, 2x(postgres+pgreplicate) and 1x pglb)<br>
<br>
config files:<br><a href="http://filip.rembialkowski.net/wp-content/uploads/2008/02/pgcluster_setup/">http://filip.rembialkowski.net/wp-content/uploads/2008/02/pgcluster_setup/</a><br><br>I am connecting to cluster via pglb running on lb_3<br>
<br>First I am trying to test pgcluster in "degraded" mode:<br><br>1) initialize everything from scratch (see scripts under above url)<br> cluster_1 $ ~/pgcluster_setup/cluster_1/reinit.sh <br> cluster_2 $ ~/pgcluster_setup/cluster_2/reinit.sh<br>
lb_3 $ ~/pgcluster_setup/lb_3/reinit.sh<br>2) create database "pgbench100"<br> $ psql -h lb_3 -p 5433 -U pgcluster postgres -c 'create database pgbench100'<br>3) fire up pgbench -i (db population mode)<br>
$ pgbench -h lb_3 -p 5433 -U pgcluster -i -s100 pgbench100<br>4) while pgbench is running, I put cluster_1 down with<br> cluster_1 $ pg_ctl stop -m fast<br><br>pgbench fails ( I take it as normal behaviour ) with: <br>
...<br>260000 tuples done.<br>270000 tuples done.<br>server closed the connection unexpectedly<br> This probably means the server terminated abnormally<br> before or while processing the request.<br>PQendcopy failed<br>
<br><br>Also, in pglb logs I have:<br>Wed Feb 13 13:51:46 2008 pool_read: EOF encountered<br><br>At this moment I expect pgcluster to switch to "degraded" mode and serve (at least R/O trafic) normally.<br><br>But, this is not the case. First probe works:<br>
$ psql -h lb_3 -p 5433 -U pgcluster postgres -qAtc 'select 1'<br> 1<br><br>but next probe fails:<br>$ psql -h lb_3 -p 5433 -U pgcluster postgres -qAtc 'select 1'<br>psql: expected authentication request from server, but received S<br>
<br><br>this is not acceptable, at least R/O traffic should work...<br><br>actually R/W also should work, because there is still 2x pgreplicate and 1x postgres running!<br><br>can someone please point me in the right direction? <br>
<br>thanks in advance<br><br><br>-- <br>Filip Rembiałkowski