Re: Old WAL files under pg_xlog not getting delete - Mailing list pgsql-admin

From Ron
Subject Re: Old WAL files under pg_xlog not getting delete
Date
Msg-id ff52b4a5-5232-abec-f148-a223b048f138@gmail.com
Whole thread Raw
In response to Re: Old WAL files under pg_xlog not getting delete  (rammohan ganapavarapu <rammohanganap@gmail.com>)
Responses Re: Old WAL files under pg_xlog not getting delete  (rammohan ganapavarapu <rammohanganap@gmail.com>)
List pgsql-admin
On 1/30/19 9:09 PM, rammohan ganapavarapu wrote:
Thank you all, but irrespective of count i have why is it keeping old files?

Because you're telling it to!!

max_wal_size= 1GB
wal_keep_segments=500

and how is it using those files? Is there any processes that can flush or remove those files?

Change the parameter and restart the server...


On Wed, Jan 30, 2019, 4:11 PM David G. Johnston <david.g.johnston@gmail.com wrote:
On Wed, Jan 30, 2019 at 5:00 PM Alvaro Herrera <alvherre@2ndquadrant.com> wrote:
> Hmm ... I would recommend to keep the xlog files in a subdir, not the
> root of the filesystem.

They are in a subdir (under /opt/pgdata), and the OP seems likely to
have omitted the self/parent hidden directories during his check as
well.  Plus per the docs we actually expect 501 so there isn't a need
to account for 6 extra, just 5.

Dave


--
Angular momentum makes the world go 'round.

pgsql-admin by date:

Previous
From: rammohan ganapavarapu
Date:
Subject: Re: Old WAL files under pg_xlog not getting delete
Next
From: Scott Ribe
Date:
Subject: Re: Old WAL files under pg_xlog not getting delete