[Pgcluster-general] ClusterDB will not recover

[a.mitani at sra-europe.com]

Hi,

> 1) When I was trying to bring everything back up, I had pgreplicate
> running, then started the DB on db3. pgreplicate did not seem to setup
> a MasterDB until I ran BEGIN;END; on db3, at which point I could run:
> pg_ctl start -o '-R'   on db2, and then it would recover. I thought
> with Life Check this wasn't necessary anymore?
No, it does not need if you are using the latest version of PGCluster.

> 2) When starting up db1 with: pg_ctl start -o '-R'      I get the
> following messages on pgreplicate. It would get through all its 1st
> recovery step, but then it would just fail, not attempting the 2nd
> recovery step. pgreplicate then goes into a loop... ? The hostnames
> have been changes to db1, db2, db3 to protect the innocent :)
>
> 2007-02-28 09:21:27 [8707] DEBUG:hostName = db1
> 2007-02-28 09:21:27 [8707] DEBUG:pg_data = /var/lib/pgsql/data
> 2007-02-28 09:21:27 [8707] DEBUG:pgrecovery_loop():receive packet no:1
> 2007-02-28 09:21:27 [8707] DEBUG:pgrecovery_loop():1st master db3 - 5432
> 2007-02-28 09:21:27 [8707] DEBUG:pgrecovery_loop():1st target db2 - 5432

Is this hostname (db2) may typo?

At.Mitani