View Single Post

   
  #2 (permalink)  
Old 04-29-2008, 08:29 PM
Charles Duffy
 
Posts: n/a
Default Re: warm standby issues

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

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Reply With Quote