Re: warm standby issues

Поиск
Список
Период
Сортировка
От Charles Duffy
Тема Re: warm standby issues
Дата
Msg-id dfdaea8f0804271658s5366836qb0248d5c63d45562@mail.gmail.com
обсуждение исходный текст
Ответ на warm standby issues  (kevin kempter <kevin@kevinkempterllc.com>)
Ответы Re: warm standby issues
Список pgsql-admin
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

В списке pgsql-admin по дате отправления:

Предыдущее
От: kevin kempter
Дата:
Сообщение: warm standby issues
Следующее
От: J Fran
Дата:
Сообщение: Problem with GeomFromText('POINT(...