Re: Can I delete all WAL logfiles if the database is shutdown without errors?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Joost Kraaijeveld" <J(dot)Kraaijeveld(at)Askesis(dot)nl>
Cc: "Pgsql-Admin (E-mail)" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Can I delete all WAL logfiles if the database is shutdown without errors?
Date: 2006-03-07 15:07:39
Message-ID: 18484.1141744059@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"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.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Joost Kraaijeveld 2006-03-07 15:11:15 Re: Can I delete all WAL logfiles if the database is
Previous Message Tom Lane 2006-03-07 14:52:46 Re: VACUUM Error?