Thread: Recycle The Wal logs

Recycle The Wal logs

From
Vasilis Ventirozos
Date:
I have some Gigs of useless transaction logs from databases that i have
created-droped etc..
can i recycle the logs or i have to run initdb again ?


Vasilis Ventirozos

Re: Recycle The Wal logs

From
Tom Lane
Date:
Vasilis Ventirozos <vendi@cosmoline.com> writes:
> I have some Gigs of useless transaction logs from databases that i have
> created-droped etc..
> can i recycle the logs or i have to run initdb again ?

They're supposed to be recycled automatically during checkpoints.  What
PG version are you using?  Do you have any nonstandard settings in
postgresql.conf?  Also, use "ps auxww" (or "ps -ef" depending on your
platform) to look and see if the postmaster has a child "checkpoint"
process that's not doing anything ...

            regards, tom lane