I have changed the wal_keep_segments=100 and restarted the postgresql processes but i still see 500+ files under pg_xlog, i had to run checkpoint manually to clean.
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.