Postgres Pro
Downloads
Home   >   mailing lists

Re: Can I delete all WAL logfiles if the database is shutdown without errors? - Mailing list pgsql-admin

From Tom Lane
Subject Re: Can I delete all WAL logfiles if the database is shutdown without errors?
Date
Msg-id 18484.1141744059@sss.pgh.pa.us
Whole thread Raw
In response to Can I delete all WAL logfiles if the database is shutdown without errors?  ("Joost Kraaijeveld" <J.Kraaijeveld@Askesis.nl>)
Responses Re: Can I delete all WAL logfiles if the database is  (Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>)
List pgsql-admin
Tree view 
"Joost Kraaijeveld" <J.Kraaijeveld@Askesis.nl> writes:
> Can I safely delete all the WAL log files in PGDATA/pg_xlog directory if the database has been shut down correctly,
becauseI 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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: VACUUM Error?
Next
From: Joost Kraaijeveld
Date:
Subject: Re: Can I delete all WAL logfiles if the database is