Hi Tom, On Tue, 2006-03-07 at 10:07 -0500, Tom Lane wrote: > "Joost Kraaijeveld" <J.Kraaijeveld@xxxxxxxxxx> 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.Kraaijeveld@xxxxxxxxxx web: www.askesis.nl
