pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedCan I delete all WAL logfiles if the database is shutdown without errors?
3+ messages / 2 participants
[nested] [flat]
* Can I delete all WAL logfiles if the database is shutdown without errors?
@ 2006-03-07 12:54 Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
2006-03-07 15:07 ` Re: Can I delete all WAL logfiles if the database is shutdown without errors? Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 3+ messages in thread
From: Joost Kraaijeveld @ 2006-03-07 12:54 UTC (permalink / raw)
To: pgsql-admin
Hi,
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?
Groeten,
Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: J.Kraaijeveld@Askesis.nl
web: www.askesis.nl
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Can I delete all WAL logfiles if the database is shutdown without errors?
2006-03-07 12:54 Can I delete all WAL logfiles if the database is shutdown without errors? Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
@ 2006-03-07 15:07 ` Tom Lane <tgl@sss.pgh.pa.us>
2006-03-07 15:11 ` Re: Can I delete all WAL logfiles if the database is Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
0 siblings, 1 reply; 3+ messages in thread
From: Tom Lane @ 2006-03-07 15:07 UTC (permalink / raw)
To: Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>; +Cc: pgsql-admin
"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, 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Can I delete all WAL logfiles if the database is
2006-03-07 12:54 Can I delete all WAL logfiles if the database is shutdown without errors? Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
2006-03-07 15:07 ` Re: Can I delete all WAL logfiles if the database is shutdown without errors? Tom Lane <tgl@sss.pgh.pa.us>
@ 2006-03-07 15:11 ` Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
0 siblings, 0 replies; 3+ messages in thread
From: Joost Kraaijeveld @ 2006-03-07 15:11 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin
Hi Tom,
On Tue, 2006-03-07 at 10:07 -0500, Tom Lane wrote:
> "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, 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@Askesis.nl
web: www.askesis.nl
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2006-03-07 15:11 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-03-07 12:54 Can I delete all WAL logfiles if the database is shutdown without errors? Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
2006-03-07 15:07 ` Tom Lane <tgl@sss.pgh.pa.us>
2006-03-07 15:11 ` Re: Can I delete all WAL logfiles if the database is Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox