[Pgcluster-general] Recovery questions

[Filip Rembiałkowski]

postgresql-8.3.0 + pgcluster-1.9.0rc2-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

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) put cluster_1 down in "simulate disaster" mode
    cluster_1 $ pg_ctl stop -m immediate

pgcluster works now in "degraded mode" - only one clusterdb.

3) create database "pgbench10"
    $ psql -h lb_3 -p 5433 -U pgcluster postgres -c 'create database pgbench10'
first try fails with "server closed the connection unexpectedly", but
second try succeeds.

4) populate this new database with pgbench
    $ pgbench -h lb_3 -p 5433 -U pgcluster -i -s10 pgbench10
    blah... blah... done.

5) now I try to bring cluster_1 back, imagine that someone just
plugged in the power cable:
    cluster_1 $ pg_ctl start

at this moment cluster_1 is not synchronised - so the load balancer is
still using only cluster_2.

what should I do now?

I tried to start cluster_1 with "-R" option, but after this the load
balancer still does not use it.


-- 
Filip Rembiałkowski