|
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. |
|||||||||
migrated from stackoverflow.com Jan 17 '13 at 18:04This question came from our site for professional and enthusiast programmers. |
|||||||||
|
|||||||||
|
This is a case where frankly the best thing to do is call for professional help. It is a best effort basis. If you are lucky someone can help process the data in the xlog files. The same would go through at least 9.3 The xlogs are normally run when the db starts. You can't just run them against an exiting db because they are binary patch files against the actual table files and so once the db starts running in read/write mode, these cannot be properly validated. Your first orders of business should be finding out why you had the crash, why these were not properly re-run when you started up, and seeing if you can take a properly done base (file-level) backup to get running again. If not, you are going to have a lot of work ahead. |
|||
|
|
