Re: pg_standby / WAL archive-restore through system restarts

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: pg_standby / WAL archive-restore through system restarts
Дата
Msg-id 20080513153158.GG6966@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: pg_standby / WAL archive-restore through system restarts  (David Wall <d.wall@computer.org>)
Ответы Re: pg_standby / WAL archive-restore through system restarts
Список pgsql-general
someone wrote:

>>> Can I shutdown Server B (backup/recovery postmaster) simply by
>>> killing the postmaster and restart it back in recovery mode to
>>> continue re-syncing where it left off?  Or does stopping Server B
>>> while in recovery mode require any manual re-sync steps before it can
>>> resume recovery?
>>
>> I think you'll need to redo the whole process : restore the full data
>> backup, create the recovery.conf file, etc.

No, you don't.  The server can continue replaying files.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

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

Предыдущее
От: Justin
Дата:
Сообщение: Re: rounding problems
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Making sure \timing is on