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