wal recycling problem

Поиск
Список
Период
Сортировка
От Fabrice Chapuis
Тема wal recycling problem
Дата
Msg-id CAA5-nLCrbc90DHbX_9Yav72hEXUetkZ9iO8zmKvCvYNZkDHx9g@mail.gmail.com
обсуждение исходный текст
Ответы Re: wal recycling problem  (Christoph Moench-Tegeder <cmt@burggraben.net>)
Список pgsql-hackers
Hello,

I have a question about the automatic removal of unused WAL files. When loading data with pg_restore (200Gb) we noticed that a lot of WALs files are generated and they are not purged automatically nor recycled despite frequent checkpoints, then pg_wal folder (150Gb) fill and become out of space.
We have a cluster of 2 members (1 primary and 1 standby) with Postgres version 14.9 and 2 barman server, slots are only configured for barman, barman is version 3.7.
The archive command is desactivated (archive_command=':')
I use pg_archivecleanup (with the wal file generated from the last checkpoint in parameter) to remove files manually before the limit of 150Gb so that the restore can terminate.

Why does postgres do not this cleanup automatically, which part of the code is responsible for removing or recycling the wals?

Thanks for your help

Fabrice

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: remaining sql/json patches
Следующее
От: David Rowley
Дата:
Сообщение: Is it worth adding Assert(false) for iso-8859-1 paths in print_path()?