Skip site navigation (1) Skip section navigation (2)

Re: warm standby issues

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: (view raw or whole 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 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
> 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.


Charles Duffy

In response to


pgsql-admin by date

Next:From: J FranDate: 2008-04-28 07:34:49
Subject: Problem with GeomFromText('POINT(...
Previous:From: kevin kempterDate: 2008-04-27 21:34:01
Subject: warm standby issues

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group