After a server crash, it would seem that all transactions going back a number of months are not showing up in the live Postgres DB. Investigation has found all xlog files that does contain the data but how do you commit these?
I would assume that you would need to do so sequentially from the oldest xlog file through to the most recent one (in date order).
Postgres Version 8.0 DB Size is around 500MB Number of xlog files is 14 files, each 16MB
Any help would be much appreciated.