Re: [HACKERS] Automatic cleanup of oldest WAL segments withpg_receivexlog

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: [HACKERS] Automatic cleanup of oldest WAL segments withpg_receivexlog
Дата
Msg-id f8d97d0c-be69-038b-621f-0dda6fa629e8@2ndquadrant.com
обсуждение исходный текст
Ответ на Re: [HACKERS] Automatic cleanup of oldest WAL segments with pg_receivexlog  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: [HACKERS] Automatic cleanup of oldest WAL segments with pg_receivexlog  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
On 3/6/17 17:16, Robert Haas wrote:
> What if we told pg_receivewal (or pg_receivexlog, whatever that is) a
> maximum number of segments to retain before removing old ones?  Like
> pg_receivewal --limit-retained-segments=50GB, or something like that.

That would be doable, but would it solve anyone's problem?  I think
pg_receivewal retention would usually be governed either by the
available base backups, or by some time-based business metric.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: [HACKERS] Parallel bitmap heap scan
Следующее
От: Dilip Kumar
Дата:
Сообщение: Re: [HACKERS] Parallel bitmap heap scan