Re: Don't removes/recycles WAL files at all

Michael Govorun <mike(at)shpion(dot)ru> writes:
> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
>> There's something broken there. Check to see why checkpoint operations
>> are not completing (look in the postmaster log for relevant error
>> messages). Open transactions should not affect this.

> No other errors messages in my log.

Maybe you have a checkpoint process that's just stuck, and is not
getting anything done yet is preventing the postmaster from launching
new checkpoints? Use ps to look for postmaster child processes that
have been around a long time.

I seem to recall a similar report of a stuck checkpoint a few weeks ago
... check the archives.

regards, tom lane