Re: WAL retention

[Bert <biertie@xxxxxxxxx>]

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@xxxxxxxxx> 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