Re: BUG #14963: Number of wal files are keep on increasing - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: BUG #14963: Number of wal files are keep on increasing
Date
Msg-id CAKFQuwawUOnNGRXdJGX5dgQ71hdY8MAfxzPW=1deJ1z8FS=u5Q@mail.gmail.com
Whole thread Raw
In response to BUG #14963: Number of wal files are keep on increasing  (raghavendrajsv@gmail.com)
Responses Re: BUG #14963: Number of wal files are keep on increasing  (Raghavendra Rao J S V <raghavendrajsv@gmail.com>)
List pgsql-bugs
On Mon, Dec 11, 2017 at 7:18 AM, <raghavendrajsv@gmail.com> wrote:
The following bug has been logged on the website:

Bug reference:      14963
Logged by:          Raghav Rao
Email address:      raghavendrajsv@gmail.com
PostgreSQL version: Unsupported/Unknown
Operating system:   Centos
Description:

pg_xlog file the log files are keep on increasing day by day. Due to this
disk is full unable to proceed further. Please help me.

checkpoint_segments = 50
wal_keep_segments = 8
​0

This is not a bug report.  Please use "pgsql-general@lists.postgresql.org" for usage assistance requests.  Stating your version and describing what kinds of backups you are performing are necessary for help on this topic.

If you have limited drive space the choice of 80 for "wal_keep_segments" in not advisable - though it is only a minimum and if your backup routine is not working properly the behavior you are seeing can result.

David J.

pgsql-bugs by date:

Previous
From: digoal@126.com
Date:
Subject: BUG #14964: statement_timeout cann't set in plpgsql
Next
From: "David G. Johnston"
Date:
Subject: Re: BUG #14964: statement_timeout cann't set in plpgsql