From: | Ryan Kirkpatrick <pgsql(at)rkirkpat(dot)net> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Recovery of PGSQL after system crash failing!!! |
Date: | 2001-02-11 22:03:33 |
Message-ID: | Pine.LNX.4.21.0102111457050.22868-100000@saratoga.rkirkpat.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Guess this what I get for attempting to use a beta version of
pgsql in a production system. :( My database server crashed (kernel
paging fault it looks like) and after reboot, postmaster refuses to start
up. There error it gives is:
DEBUG: starting up
DEBUG: database system was interrupted at 2001-02-11 04:08:12
DEBUG: Checkpoint record at (0, 805076492)
postmaster: reaping dead processes...
Startup failed - abort
And that is it, from running 'postmaster -D /usr/local/pgsql/data/'. I get
the same thing each time I run it. I assume that WAL is for some reason
failing to restore/recover the database.
The system is a stock Debian 2.2 system, Dual PPro200, w/pgsql
7.1beta4. The system crash occured during the nightly update of the
databases (from another, internal, non-pgsql, database system). Is there
anyway to recover the database, or do I need to do a 'rm -rf
data; initdb'? A quick response would be greatly appreciated. Thanks.
---------------------------------------------------------------------------
| "For to me to live is Christ, and to die is gain." |
| --- Philippians 1:21 (KJV) |
---------------------------------------------------------------------------
| Ryan Kirkpatrick | Boulder, Colorado | http://www.rkirkpat.net/ |
---------------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-02-11 23:13:57 | Re: Recovery of PGSQL after system crash failing!!! |
Previous Message | Dave Page | 2001-02-11 19:17:45 | RE: [ODBC] RE: [PATCHES] Fix for ODBC close |