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