corrupted pg_xlog/0000000000000000

From: Scott Parish <sRp(at)srparish(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: corrupted pg_xlog/0000000000000000
Date: 2001-02-27 01:29:55
Message-ID: 20010227012955.C27362@aspen.srparish.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message GH 2001-02-27 01:42:46 Re: difficulty building PostgreSQL with PHP4?
Previous Message Phil Glatz 2001-02-27 01:18:46 difficulty building PostgreSQL with PHP4?