| 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: | Whole Thread | Raw Message | 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? |