On Mon, Apr 28, 2008 at 7:34 AM, kevin kempter
> Hi List;
> I'm setting up a warm standby server on version 8.1.9
I didn't think 8.1 supported warm-standby...
> I setup a recovery.sh script to keep the standby cluster in recovery mode
> waiting for the next WAL segment. everything works fine as long as the
> standby server is in recovery mode. I see the recovery taking place in the
> postgres log of the standby server. I've set it up to exit the recovery.sh
> script if it see's a trigger file (to bring the standby online).
> when I create the trigger file I see this:
> copy /home/postgres/healthCareCoding/WAL/000000010000000000000004
Try with 8.2 or above, and see if that makes your problem go away. Use
pg_standby instead of shell scripts.
In response to
pgsql-admin by date
|Next:||From: J Fran||Date: 2008-04-28 07:34:49|
|Subject: Problem with GeomFromText('POINT(...|
|Previous:||From: kevin kempter||Date: 2008-04-27 21:34:01|
|Subject: warm standby issues|