Re: WAL retention

Поиск
Список
Период
Сортировка
От Bert
Тема Re: WAL retention
Дата
Msg-id CAFCtE1n2L7i6ySD+3F=e-KRm6POCC6Wu+U3FshRHN_hmpAsPZw@mail.gmail.com
обсуждение исходный текст
Ответ на WAL retention  (Slavcho Trnkovski <strnkovski@gmail.com>)
Ответы Re: WAL retention
Список pgsql-admin
Дерево обсуждения
Hello,

Which version of PostgreSQL are you using?
If you are using version 9.4 or newer you can use the concept of 'replication slots' to block the removal or archiving of WAL files.
But do not forgot to remove the slot again, else PostgreSQL will never remove the wall files again!

Bert

On Mon, Jun 20, 2016 at 10:38 AM, Slavcho Trnkovski <strnkovski@gmail.com> wrote:
Hi Guys,

Is there a way to set retention policy for removing WAL files in hours/days instead of number of WAL files (wal_keep_segments)?

I have a problem when backup is running, it complains that some files are missing. The problem is that i have situation when data load is running and a lot of WAL files are generated.

Regards,
Slavcho




--
Bert Desmet
0477/305361

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