Re: WAL retention

[Slavcho Trnkovski <strnkovski@xxxxxxxxx>]

Hi,

I use version 9.4. 

If I create physical replication slot, I'll need standby server to use it. I can use pg_receivexlog but it will not prevent removing WAL files, it will just stream it to some other location.

Do you maybe have an idea how backup can use replication slot (without standby)?

Regards,

Slavcho

On Mon, Jun 20, 2016 at 3:52 PM, Bert <biertie@xxxxxxxxx> wrote:

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