Re: Recovery of PGSQL after system crash failing!!! - Mailing list pgsql-hackers

From Vadim Mikheev
Subject Re: Recovery of PGSQL after system crash failing!!!
Date
Msg-id 001101c094a7$c73a2620$4a79583f@sectorbase.com
Whole thread Raw
In response to Recovery of PGSQL after system crash failing!!!  (Ryan Kirkpatrick <pgsql@rkirkpat.net>)
Responses Re: Recovery of PGSQL after system crash failing!!!  (Ryan Kirkpatrick <pgsql@rkirkpat.net>)
List pgsql-hackers
> 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

Please try to restart with option wal_debug = 1 so postmaster log
will be more informative and send this log me.

> data; initdb'? A quick response would be greatly appreciated. Thanks.

Please archieve PG' data dir - it probably will be useful to find bug.

Vadim




pgsql-hackers by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: ODBC backward versions
Next
From: "Christopher Kings-Lynne"
Date:
Subject: 7.0.3 spelling error