Re: Restore postgres to specific time

Поиск
Список
Период
Сортировка
От wd
Тема Re: Restore postgres to specific time
Дата
Msg-id CABexzmiJ7s3+F05OapU+X_RsDm3CNJMbMu22y3uSxSsZ7uXbig@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Restore postgres to specific time  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
Список pgsql-general



On Mon, Nov 26, 2012 at 11:32 PM, Albe Laurenz <laurenz.albe@wien.gv.at> wrote:
wd wrote:
>>> Logs are something like this:
>>>
>>> [    2012-11-24 21:51:33.591 CST 583 50b0d0e5.247 9 0]LOG:  recovery
has paused
>>> [    2012-11-24 21:51:33.591 CST 583 50b0d0e5.247 10 0]HINT:
Execute pg_xlog_replay_resume() to continue.
>>
>> Well, try
>>
>> SELECT pg_xlog_replay_resume();
>
> I can't connect to postgres at that time.

Duh.
Then the trick is not to pause at all.
Make sure that pause_at_recovery_target is not set in
recovery.conf.
Stop the recovering server, then start it again.
That should do the trick.

I've tried set pause_at_recovery_target to true, it's not work. and also tried comment out this setting it's the same.

Restart have no effect, the recovery.conf is always there, I think it's should be rename to recovery.done if it's work.
 

Yours,
Laurenz Albe

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

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: Restore postgres to specific time
Следующее
От: wd
Дата:
Сообщение: Re: Restore postgres to specific time