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

From rammohan ganapavarapu
Subject Re: Old WAL files under pg_xlog not getting delete
Date
Msg-id CALm_Vjhf4AJF_=rvOMmmwKcaN3CN0YNnm7Q8RwivpLio8G+i7A@mail.gmail.com
Whole thread Raw
In response to Re: Old WAL files under pg_xlog not getting delete  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Old WAL files under pg_xlog not getting delete  (Ron <ronljohnsonjr@gmail.com>)
Re: Old WAL files under pg_xlog not getting delete  (Scott Ribe <scott_ribe@elevated-dev.com>)
Re: Old WAL files under pg_xlog not getting delete  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-admin
Thank you all, but irrespective of count i have why is it keeping old files? and how is it using those files? Is there any processes that can flush or remove those files?

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

pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Old WAL files under pg_xlog not getting delete
Next
From: Ron
Date:
Subject: Re: Old WAL files under pg_xlog not getting delete