Re: PITR, checkpoint, and local relations

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: PITR, checkpoint, and local relations
Дата
Msg-id 29163.1028333148@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: PITR, checkpoint, and local relations  ("Mikheev, Vadim" <vmikheev@SECTORBASE.COM>)
Ответы Re: PITR, checkpoint, and local relations
Re: PITR, checkpoint, and local relations
Список pgsql-hackers
"Mikheev, Vadim" <vmikheev@SECTORBASE.COM> writes:
>> It should be sufficient to force a checkpoint when you
>> start and when you're done --- altering normal operation in between is
>> a bad design.

> But you have to prevent log files reusing while you copy data files.

No, I don't think so.  If you are using PITR then you presumably have
some process responsible for archiving off log files on a continuous
basis.  The backup process should leave that normal operational behavior
in place, not muck with it.
        regards, tom lane


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

Предыдущее
От: "Mikheev, Vadim"
Дата:
Сообщение: Re: PITR, checkpoint, and local relations
Следующее
От: "Mikheev, Vadim"
Дата:
Сообщение: Re: PITR, checkpoint, and local relations