[Pgcluster-general] Recovery questions

At.Mitani mitani at sraw.co.jp
Mon Feb 25 08:50:19 UTC 2008


Hi Filip,

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

Yes, for that reason, load balancer uses only cluster_2.
In order to back cluster_1 to replication table, it needs restart with -R option as you did.

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

please check cluster db's status in the "pglb.sts".
If status of cluster_1 is neither 'initialize' nor 'start use',
recovery might be failed.
If so, please check the debug log of replication server.
Probably, you can find something.

Regards,

-- 
At.Mitani <mitani at sraw.co.jp>


More information about the Pgcluster-general mailing list