Re: Can I delete all WAL logfiles if the database is

Hi Tom,

On Tue, 2006-03-07 at 10:07 -0500, Tom Lane wrote:
> "Joost Kraaijeveld" <J(dot)Kraaijeveld(at)Askesis(dot)nl> writes:
> > Can I safely delete all the WAL log files in PGDATA/pg_xlog directory if the database has been shut down correctly, because I lowered the number of logfiles in postgresql.conf?
>
> All but the one holding the latest checkpoint record (pg_controldata
> will tell you which one that is). I'm not sure why you'd bother though.
> The next checkpoint should remove any excess log files, there's no need
> to do it manually.
Ah, I did not know that. I will wait and do nothing.

Thanks

--
Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: J(dot)Kraaijeveld(at)Askesis(dot)nl
web: www.askesis.nl