From: L.Boldareva <pg@pierro.dds.nl>
To: pgsql-admin@postgresql.org
Subject: How to recover when can't start database
Date: Fri, 1 Apr 2005 12:02:21 +0200 (CEST)
Message-ID: <Pine.LNX.4.58.0504011149340.17008@yafa.dds.nl> (raw)
Hi!
(Hope this is the right place to post)
I crashed the postmaster and cannot start it anymore, with the error
LOG: database system was interrupted while in recovery at 2005-04-01 11:04:33 CEST
HINT: This probably means that some data is corrupted and you will have to use the last backup for recovery.
LOG: checkpoint record is at 5/6F00C540
LOG: redo record is at 5/6F000ABC; undo record is at 0/0; shutdown FALSE
LOG: next transaction ID: 599824; next OID: 147679259
LOG: database system was not properly shut down; automatic recovery in
progress
LOG: redo starts at 5/6F000ABC
PANIC: btree_split_redo: lost left sibling
LOG: startup process (PID 5603) was terminated by signal 6
LOG: aborting startup due to startup process failure
Is there a way to recover from that?
I don't have a fresh backup, but loosing some couple of days won't be a
problem.
I use PG 8.0 on a linux box, with standard postgresq.conf (except some
increased memory settings).
thanks,
L.B.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: pg@pierro.dds.nl
Subject: Re: How to recover when can't start database
In-Reply-To: <Pine.LNX.4.58.0504011149340.17008@yafa.dds.nl>
References: <Pine.LNX.4.58.0504011149340.17008@yafa.dds.nl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox