Re: Out of space situation and WAL log pre-allocation (was Tablespaces)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Out of space situation and WAL log pre-allocation (was Tablespaces)
Дата
Msg-id 8478.1078289703@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Out of space situation and WAL log pre-allocation (was  (Joe Conway <mail@joeconway.com>)
Ответы Re: Out of space situation and WAL log pre-allocation (was  (Joe Conway <mail@joeconway.com>)
Список pgsql-hackers
Joe Conway <mail@joeconway.com> writes:
> Tom Lane wrote:
>> facing the possibility of an out-of-WAL-space panic.  I suspect that we
>> cannot really do anything about that, but it's annoying.  Any bright
>> ideas out there?

> Maybe specify an archive location (that of course could be on a separate 
> partition) that the external archiver should check in addition to the 
> normal WAL location. At some predetermined interval, push WAL log 
> segments no longer needed to the archive location.

Does that really help?  The panic happens when you fill the "normal" and
"archive" partitions, how's that different from one partition?
        regards, tom lane


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

Предыдущее
От: Gavin Sherry
Дата:
Сообщение: Re: Tablespaces
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Tablespaces