Re: Recovery target 'immediate'

Поиск
Список
Период
Сортировка
От Sergey Burladyan
Тема Re: Recovery target 'immediate'
Дата
Msg-id CAJ2ymdiL-GXm=nMDP_K_0-oR8VSMsXjQjsFKf1XkpbBKZMiqmQ@mail.gmail.com
обсуждение исходный текст
Ответ на Recovery target 'immediate'  (Heikki Linnakangas <hlinnakangas@vmware.com>)
Список pgsql-hackers
On Thu, Apr 18, 2013 at 10:11 PM, Heikki Linnakangas <hlinnakangas@vmware.com> wrote:
I just found out that if you use continuous archiving and online backups, it's surprisingly difficult to restore a backup, without replaying any more WAL than necessary.

You can find first WAL file name in backup_label "START WAL LOCATION". Last WAL file name location depends on source type, if backup from slave - use pg_control from backup and "Minimum recovery ending location", if backup from master - use "STOP WAL LOCATION" from backup .history file :-) Then I just copy needed WALs from archive into pg_xlog and remove recovery.conf.

It seems that we're missing a setting, something like recovery_target = 'immediate', which would mean "stop as soon as consistency is reached". Or am I missing some trick?

This will be helpful :)

--
Sergey Burladyan

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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: 9.3 Beta1 status report
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Recovery target 'immediate'