| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | rammohan ganapavarapu <rammohanganap(at)gmail(dot)com> |
| Cc: | John Scalia <jayknowsunix(at)gmail(dot)com>, Ron <ronljohnsonjr(at)gmail(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Old WAL files under pg_xlog not getting delete |
| Date: | 2019-01-31 20:59:54 |
| Message-ID: | CAKFQuwaF2WXY=0Z8s=1eKkUME-b_Fp0=NsO8zxhU7bjBeqMkgA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Thu, Jan 31, 2019 at 11:52 AM rammohan ganapavarapu
<rammohanganap(at)gmail(dot)com> wrote:
> But from postgres documentation "The number of WAL segment files in pg_xlog directory depends on min_wal_size, max_wal_size and 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Gierth | 2019-01-31 21:09:18 | Re: insert aborted commands ignored |
| Previous Message | Scott Ribe | 2019-01-31 20:57:30 | Re: insert aborted commands ignored |