Another WAL question

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

Responses

Browse pgsql-admin by date

  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