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 _______________________________________________ Pgcluster-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgcluster-general
