From: | "Charles Duffy" <charles(dot)duffy(at)gmail(dot)com> |
---|---|
To: | "kevin kempter" <kevin(at)kevinkempterllc(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: warm standby issues |
Date: | 2008-04-27 23:58:28 |
Message-ID: | dfdaea8f0804271658s5366836qb0248d5c63d45562@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi Kevin,
On Mon, Apr 28, 2008 at 7:34 AM, kevin kempter
<kevin(at)kevinkempterllc(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | J Fran | 2008-04-28 07:34:49 | Problem with GeomFromText('POINT(... |
Previous Message | kevin kempter | 2008-04-27 21:34:01 | warm standby issues |