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

From David G. Johnston
Subject Re: Old WAL files under pg_xlog not getting delete
Date
Msg-id CAKFQuwaF2WXY=0Z8s=1eKkUME-b_Fp0=NsO8zxhU7bjBeqMkgA@mail.gmail.com
Whole thread Raw
In response to Re: Old WAL files under pg_xlog not getting delete  (rammohan ganapavarapu <rammohanganap@gmail.com>)
List pgsql-admin
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.


pgsql-admin by date:

Previous
From: Scott Ribe
Date:
Subject: Re: insert aborted commands ignored
Next
From: Andrew Gierth
Date:
Subject: Re: insert aborted commands ignored