From: | "Nick Fankhauser" <nickf(at)ontko(dot)com> |
---|---|
To: | "pgsql-admin" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Another WAL question |
Date: | 2001-09-12 14:40:24 |
Message-ID: | NEBBLAAHGLEEPCGOBHDGKEIGDKAA.nickf@ontko.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Robert F. mentioned that there is a config parameter controlling the number
of WAL files in postgresql.conf.
I just looked at the Doc on this & I found WAL_FILES, which appears to
specify the number of files to create in advance, but it is no clear to me
that this limits the total number of WAL files created. Can this number be
exceeded as needed by the postmaster? If so, is there another parameter that
I'm missing to set a limit?
Are old WAL files deleted or re-used automatically when all of their
contents have been flushed to the DB, or should we be watching these &
either archiving or deleting old ones?
TIA,
-Nick
---------------------------------------------------------------------
Nick Fankhauser
Business:
nickf(at)doxpop(dot)com Phone 1.765.965.7363 Fax 1.765.962.9788
doxpop - Court records at your fingertips - http://www.doxpop.com/
Personal:
nick(at)fankhausers(dot)com http://www.fankhausers.com
From | Date | Subject | |
---|---|---|---|
Next Message | Robert.Farrugia | 2001-09-12 16:24:18 | Re: Can't get postmaster to restart after removing WAL files |
Previous Message | Nick Fankhauser | 2001-09-12 14:12:40 | Re: Can't get postmaster to restart after removing WAL files |