Re: Restore postgres to specific time

Поиск
Список
Период
Сортировка
От wd
Тема Re: Restore postgres to specific time
Дата
Msg-id CABexzmhwQ6tMRoYHoQ7R9Ktfwp1GZX-N6C79KNqpU8YhB6dejQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Restore postgres to specific time  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
Ответы Re: Restore postgres to specific time  (raghu ram <raghuchennuru@gmail.com>)
Re: Restore postgres to specific time  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
Re: Restore postgres to specific time  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-general
Дерево обсуждения
Thanks for your reply, the logs are something like bellow，postgres will restore every wal log I put in the xlog directory，and then continues waiting for next wal log. The postgres version is 9.1.6.

[    2012-11-22 18:49:24.175 CST 25744 50ae0334.6490 1 0]LOG:  database system was shut down in recovery at 2012-11-22 18:49:22 CST
[    2012-11-22 18:49:24.176 CST 25744 50ae0334.6490 2 0]LOG:  entering standby mode
[    2012-11-22 18:49:24.210 CST 25744 50ae0334.6490 3 0]LOG:  restored log file "000000010000002800000023" from archive
[    2012-11-22 18:49:24.213 CST 25744 50ae0334.6490 4 0]LOG:  redo starts at 28/23001900
[    2012-11-22 18:49:24.619 CST 25744 50ae0334.6490 5 0]LOG:  consistent recovery state reached at 28/23FFFFC8
[    2012-11-22 18:49:24.620 CST 25736 50ae0333.6488 2 0]LOG:  database system is ready to accept read only connections
cp: cannot stat `/export/t/xlog/000000010000002800000024': No such file or directory
cp: cannot stat `/export/t/xlog/000000010000002800000024': No such file or directory
cp: cannot stat `/export/t/xlog/000000010000002800000024': No such file or directory
cp: cannot stat `/export/t/xlog/000000010000002800000024': No such file or directory
cp: cannot stat `/export/t/xlog/000000010000002800000024': No such file or directory
cp: cannot stat `/export/t/xlog/000000010000002800000024': No such file or directory
cp: cannot stat `/export/t/xlog/000000010000002800000024': No such file or directory
cp: cannot stat `/export/t/xlog/000000010000002800000024': No such file or directory
cp: cannot stat `/export/t/xlog/000000010000002800000024': No such file or directory
cp: cannot stat `/export/t/xlog/000000010000002800000024': No such file or directory
cp: cannot stat `/export/t/xlog/000000010000002800000024': No such file or directory
cp: cannot stat `/export/t/xlog/000000010000002800000024': No such file or directory
cp: cannot stat `/export/t/xlog/000000010000002800000024': No such file or directory
cp: cannot stat `/export/t/xlog/000000010000002800000024': No such file or directory
cp: cannot stat `/export/t/xlog/000000010000002800000024': No such file or directory
cp: cannot stat `/export/t/xlog/000000010000002800000024': No such file or directory
cp: cannot stat `/export/t/xlog/000000010000002800000024': No such file or directory
cp: cannot stat `/export/t/xlog/000000010000002800000024': No such file or directory
[    2012-11-22 18:50:49.828 CST 25744 50ae0334.6490 6 0]LOG:  restored log file "000000010000002800000024" from archive
[    2012-11-22 18:50:50.291 CST 25744 50ae0334.6490 7 0]LOG:  restored log file "000000010000002800000025" from archive
[    2012-11-22 18:50:50.759 CST 25744 50ae0334.6490 8 0]LOG:  restored log file "000000010000002800000026" from archive
[    2012-11-22 18:50:51.220 CST 25744 50ae0334.6490 9 0]LOG:  restored log file "000000010000002800000027" from archive
[    2012-11-22 18:50:51.686 CST 25744 50ae0334.6490 10 0]LOG:  restored log file "000000010000002800000028" from archive
[    2012-11-22 18:50:52.145 CST 25744 50ae0334.6490 11 0]LOG:  restored log file "000000010000002800000029" from archive
[    2012-11-22 18:50:52.613 CST 25744 50ae0334.6490 12 0]LOG:  restored log file "00000001000000280000002A" from archive
[    2012-11-22 18:50:53.073 CST 25744 50ae0334.6490 13 0]LOG:  restored log file "00000001000000280000002B" from archive
[    2012-11-22 18:50:53.538 CST 25744 50ae0334.6490 14 0]LOG:  restored log file "00000001000000280000002C" from archive
[    2012-11-22 18:50:53.999 CST 25744 50ae0334.6490 15 0]LOG:  restored log file "00000001000000280000002D" from archive
[    2012-11-22 18:50:54.459 CST 25744 50ae0334.6490 16 0]LOG:  restored log file "00000001000000280000002E" from archive
[    2012-11-22 18:50:54.920 CST 25744 50ae0334.6490 17 0]LOG:  restored log file "00000001000000280000002F" from archive
cp: cannot stat `/export/t/xlog/000000010000002800000030': No such file or directory
cp: cannot stat `/export/t/xlog/000000010000002800000030': No such file or directory



On Thu, Nov 22, 2012 at 10:39 PM, Albe Laurenz <laurenz.albe@wien.gv.at> wrote:
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 по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: get column name passed to a function
Следующее
От: raghu ram
Дата:
Сообщение: Re: Restore postgres to specific time