WAL retention

From: Slavcho Trnkovski <strnkovski(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: WAL retention
Date: 2016-06-20 08:38:23
Message-ID: CACwHmfHGBmw46Rrdf7HbFb+=2jF-2ZAmxi8orJZWGYaT95--+g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Michael JOIGNY 2016-06-20 08:50:21 RAM/CPU running queries
Previous Message Magnus Hagander 2016-06-20 08:17:57 Re: problems using pg_start_backup/pg_stop_backup and pg_basebackup at same time