I have a production database running postgresql 7.1beta4. Everything
was great untill '/etc/rc.d/init.d/pgsql stop' was ran. Now when ever a
person makes an attempt to start the database postmaster refuses to
start saying:
DEBUG: starting up
DEBUG: database system was interrupted at 2001-02-26 14:34:09
DEBUG: CheckPoint record at (0, 5962224)
FATAL 2: Invalid RMID in checkPoint record
DEBUG: proc_exit(2)
DEBUG: shmem_exit(2)
DEBUG: exit(2)
/apps/pgsql/bin/postmaster: reaping dead processes...
Startup failed - abort
After doing a lot of probing around it appears that all the base/* files
and global/* files are fine, however these seem to be useless without
the pg_xlog/0000000000000000 file, which appears to contain the
structure for the tables of the database.
Are there any suggestions on how i may go about recovering from this
incident without starting from scratch?
Thank
sRp
--
Scott Parish
http://srparish.net/