Re: Old WAL files under pg_xlog not getting delete

On Thu, Jan 31, 2019 at 11:52 AM rammohan ganapavarapu
<rammohanganap@gmail.com> wrote:
> But from postgres documentation "The number of WAL segment files in pg_xlog directory depends on min_wal_size,
max_wal_sizeand the amount of WAL generated in previous checkpoint cycles.
 

You are quoting from the v10+ documentation but using 9.6

You also need to read about archiving[1] since when it is enabled the
rules for WAL retention are modified to meet the needs of archiving,
specifically WAL cannot be removed from the host system until the
host's archiving system knows that the same file exists in the
archive.

[1] https://www.postgresql.org/docs/9.6/continuous-archiving.html#BACKUP-ARCHIVING-WAL

David J.