Re: Restore postgres to specific time

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: Restore postgres to specific time
Дата
Msg-id D960CB61B694CF459DCFB4B0128514C208B888B4@exadv11.host.magwien.gv.at
обсуждение исходный текст
Ответ на Restore postgres to specific time  (wd <wd@wdicc.com>)
Ответы Re: Restore postgres to specific time  (wd <wd@wdicc.com>)
Список pgsql-general
wd wrote:
> I've try to restore Postgres to a specific time but failed.
> 
> The recovery.conf as bellow
> restore_command='cp /t/xlog/%f %p'
> recovery_target_time='2012-11-22 5:01:09 CST'
> pause_at_recovery_target=true
> recovery_target_inclusive=false
> 
> The basebackup was made at 2012-11-22 3:10 CST, I've copy wal log files at 3:00 to 5:10 into /t/xlog,
> but the recovery will not stop at 2012-11-22 5:01:09。
> 
> How to do this?

Looks ok.
What does the server log say during the restore?

Yours,
Laurenz Albe

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

Предыдущее
От: wd
Дата:
Сообщение: Restore postgres to specific time
Следующее
От: "Rhys A.D. Stewart"
Дата:
Сообщение: Re: get column name passed to a function