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/