Re: [HACKERS] Incrementally Updated Backup

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] Incrementally Updated Backup
Дата
Msg-id 18412.1158783990@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] Incrementally Updated Backup  ("Jim C. Nasby" <jim@nasby.net>)
Ответы Re: [HACKERS] Incrementally Updated Backup  ("Jim C. Nasby" <jim@nasby.net>)
Список pgsql-patches
"Jim C. Nasby" <jim@nasby.net> writes:
> An advantage to being able to stop the server is that you could have one
> server processing backups for multiple PostgreSQL clusters by going
> through them 1 (or more likely, 2, 4, etc) at a time, essentially
> providing N+1 capability.

Why wouldn't you implement that by putting N postmasters onto the backup
server?  It'd be far more efficient than the proposed patch, which by
aborting at random points is essentially guaranteeing a whole lot of
useless re-replay of WAL whenever you restart it.

            regards, tom lane

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

Предыдущее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: [HACKERS] Incrementally Updated Backup
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: [HACKERS] Incrementally Updated Backup