From: Charles Duffy <charles.duffy@gmail.com>
To: kevin kempter <kevin@kevinkempterllc.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: warm standby issues
Date: Mon, 28 Apr 2008 09:58:28 +1000
Message-ID: <dfdaea8f0804271658s5366836qb0248d5c63d45562@mail.gmail.com> (raw)
In-Reply-To: <932B6BCD-0917-49BD-96B7-91395A4EC397@kevinkempterllc.com>
References: <932B6BCD-0917-49BD-96B7-91395A4EC397@kevinkempterllc.com>
Hi Kevin,
On Mon, Apr 28, 2008 at 7:34 AM, kevin kempter
<kevin@kevinkempterllc.com> wrote:
> 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
> pg_xlog/RECOVERYXLOG
Try with 8.2 or above, and see if that makes your problem go away. Use
pg_standby instead of shell scripts.
Thanks,
Charles Duffy
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: charles.duffy@gmail.com, kevin@kevinkempterllc.com
Subject: Re: warm standby issues
In-Reply-To: <dfdaea8f0804271658s5366836qb0248d5c63d45562@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox