PITR and tar

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема PITR and tar
Дата
Msg-id 1178564286.23358.7.camel@dogma.v10.wvs
обсуждение исходный текст
Ответы Re: PITR and tar
Список pgsql-general
The docs recommend using tar to perform a base backup for PITR.

Usually, tar reports notices like:
"tar: Truncated write; file may have grown while being archived."

First of all, is the tar archive still safe if those errors occur?

Second, it seems that it can cause a bad backup to occur if you pass the
"z" option to tar. Instead, piping the output of tar through the
compression program seems to avoid that problem (i.e. "tar cf - ... |
gzip > ..."). I am using FreeBSD's tar, other implementations may be
different.

Are my observations correct, and if so, should they be documented as a
potential "gotcha" when making base backups?

Regards,
    Jeff Davis


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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Date Math
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Date Math