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/
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? |