Hi Tom, On Tue, 2006-03-07 at 10:07 -0500, Tom Lane wrote: > "Joost Kraaijeveld" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] web: www.askesis.nl ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
