I am running postgres 7.4.9 on an LFS system , and had a long outstanding pg_checkpoint that seemed to prevent the DB from being cleanly shutdown.
The box was power cycled (not my choice...) and when it came up Postgres did it's recovery and seemed to be fine.
Checkpoints appear to be up to date (via pg_controldata), but the pg_xlog directory has 95 files, of which 90 are dated before midnight yesterday or earlier.
Can I just delete them safely? Or is there some recovery method I can do?
Thanks.