Hi, I need urgent help. I am using PostgreSQL version 8.0.1. postmaster fails to start and the log file looks as follow:
LOG: database system was shut down at 2005-05-24 15:50:46 MSD LOG: checkpoint record is at 1/8D117BE4 LOG: redo record is at 1/8D117BE4; undo record is at 0/0; shutdown TRUE LOG: next transaction ID: 3859443; next OID: 1904360
Actually, it might be possible to use the PITR system to restore up to just before the error (the transaction-id above might be a good start point).
You'll want to move your WAL files to a different directory so it looks like they've been copied from another machine. See this section of the manuals for details of how to set up the recovery. Take your time reading it thoroughly.
http://www.postgresql.org/docs/8.0/static/backup-online.html
IMPORTANT - make sure you have a backup copy of the entire data directory before trying this.
A warning - I've not tried this particular idea out, but as long as you can partially replay the first WAL file, I don't see why it shouldn't work.
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)
