Re: Forcing current WAL file to be archived

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Forcing current WAL file to be archived
Дата
Msg-id 10713.1153842786@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Forcing current WAL file to be archived  (Simon Riggs <simon@2ndquadrant.com>)
Ответы Re: Forcing current WAL file to be archived  (Bruce Momjian <bruce@momjian.us>)
Re: Forcing current WAL file to be archived  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-hackers
Simon Riggs <simon@2ndquadrant.com> writes:
> I was planning to add a new GUC
>     archive_timeout (integer) = max # secs between log file switches

That's fine, but feature freeze is in a week and we don't even have the
basic function for manually doing a log file switch.  Let's get that
done first and then think about automatic switches.

Also, forcing another 16M of WAL out every few seconds is a pretty crude
and inefficient way of making sure your hot standby server is up to
date.  As Hannu noted, an archiving script can do better than that if it
can access the current WAL file name and offset.  So we really want to
get the function to return that info done as well.
        regards, tom lane


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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Forcing current WAL file to be archived
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Forcing current WAL file to be archived