Re: Streaming Rep - 2-phase backups and reducing time to full replication

Поиск
Список
Период
Сортировка
От Fujii Masao
Тема Re: Streaming Rep - 2-phase backups and reducing time to full replication
Дата
Msg-id 3f0b79eb0912242133y2e5bdf9dq754ff187dfc8e2cc@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Streaming Rep - 2-phase backups and reducing time to full replication  (Simon Riggs <simon@2ndQuadrant.com>)
Ответы Re: Streaming Rep - 2-phase backups and reducing time to full replication
Список pgsql-hackers
On Thu, Dec 24, 2009 at 6:03 PM, Simon Riggs <simon@2ndquadrant.com> wrote:
> I see it would work like this: Add a new option to recovery.conf,
> perhaps two_phase_backup = on. Startup creates a file called
> backup_in_progress then waits. When second phase of backup is complete
> (7b), delete the file and then Startup process will continue. Very few
> lines of code to make this work.

Where do you think the WAL files shipped before doing (7b) are stored?
If it's pg_xlog, the disk full failure would occur in the standby. If
it's an archive, restore_command would have to be supplied the same as
my idea.

Regards,

-- 
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Removing pg_migrator limitations
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Removing pg_migrator limitations