Postgres Pro
Downloads
Home   >   mailing lists

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

From Raghavendra Rao J S V
Subject Re: BUG #14963: Number of wal files are keep on increasing
Date
Msg-id CAEHH7R7vxmAQjBYz89uVr76HsFLiXC8P2EHU4_+7mr1f4Qfa_A@mail.gmail.com
Whole thread Raw
In response to Re: BUG #14963: Number of wal files are keep on increasing  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: BUG #14963: Number of wal files are keep on increasing  (Sergei Kornilov <sk@zsrv.org>)
List pgsql-bugs
Tree view
Hi David,

We are using pg_basebackup to take the backup of the database. The version of PostgreSQL is  9.2.9. My Postgres database configs are as below.  

wal_buffers = 16MB
max_wal_senders = 1
wal_level = archive
archive_mode = on
checkpoint_segments = 50
wal_keep_segments = 80
checkpoint_completion_target = 0.9
synchronous_commit = on   

Do we have any command to minimize the wall files. Day by day number of wal files are increasing due to that slowly disk will be full. 

Regards,
Raghavendra Rao



On Mon, Dec 11, 2017 at 8:06 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:
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.




--
Regards,
Raghavendra Rao J S V
Mobile- 8861161425

pgsql-bugs by date:

Previous
From: Devrim Gündüz
Date:
Subject: Re: BUG #14959: init script is trying to run postmaster withforground
Next
From: Michael Paquier
Date:
Subject: Re: PostgreSQL crashes with SIGSEGV