Re: [GENERAL] Logging the fact that a log was shipped

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: [GENERAL] Logging the fact that a log was shipped
Дата
Msg-id 20170828172844.GS4628@tamriel.snowman.net
обсуждение исходный текст
Ответ на Re: [GENERAL] Logging the fact that a log was shipped  (Christoph Moench-Tegeder <cmt@burggraben.net>)
Список pgsql-general
* Christoph Moench-Tegeder (cmt@burggraben.net) wrote:
> ## Stephen Frost (sfrost@snowman.net):
>
> > Worse, such scripts run the serious risk of losing WAL if a crash
> > happens because nothing is ensuring that the WAL has been sync'd to disk
> > before returning from the archive_command.
>
> That risk already exists when using rsync/scp/scp/... and should be
> mitigated by filesystem settings on the receiving side.

I was including rsync/scp/similar based tools, yes, just pointing out
that such tools should be avoided when doing PG backups and WAL
archiving.

I have a hard time seeing "require filesystems be mounted as sync" to
really be a viable solution, though I suppose it would be technically
correct.

Thanks!

Stephen

Вложения

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

Предыдущее
От: Christoph Moench-Tegeder
Дата:
Сообщение: Re: [GENERAL] Logging the fact that a log was shipped
Следующее
От: Gabriel Furstenheim Milerud
Дата:
Сообщение: Re: [GENERAL] Extension coverage