| From: | "Vadim Mikheev" <vmikheev(at)sectorbase(dot)com> |
|---|---|
| To: | "Ryan Kirkpatrick" <pgsql(at)rkirkpat(dot)net>, <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Recovery of PGSQL after system crash failing!!! |
| Date: | 2001-02-12 03:56:27 |
| Message-ID: | 001101c094a7$c73a2620$4a79583f@sectorbase.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Kings-Lynne | 2001-02-12 07:40:29 | 7.0.3 spelling error |
| Previous Message | Hiroshi Inoue | 2001-02-12 02:07:20 | Re: ODBC backward versions |