Re: BUG #14963: Number of wal files are keep on increasing

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(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> On Mon, Dec 11, 2017 at 7:18 AM, <raghavendrajsv(at)gmail(dot)com> wrote:
>
>> The following bug has been logged on the website:
>>
>> Bug reference: 14963
>> Logged by: Raghav Rao
>> Email address: raghavendrajsv(at)gmail(dot)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(at)lists(dot)postgresql(dot)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