X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C8D0A53737 for ; Fri, 1 Apr 2005 11:02:28 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 48414-10 for ; Fri, 1 Apr 2005 10:02:22 +0000 (GMT) Received: from otto2.isd-holland.nl (otto.isd-holland.nl [62.221.254.21]) by svr1.postgresql.org (Postfix) with ESMTP id 24D5C53A11 for ; Fri, 1 Apr 2005 11:02:21 +0100 (BST) Received: from shell.dds.nl (shell.dds.nl [213.196.11.31]) by otto2.isd-holland.nl (Postfix) with ESMTP id 16E4C364136 for ; Fri, 1 Apr 2005 12:02:20 +0200 (CEST) Date: Fri, 1 Apr 2005 12:02:21 +0200 (CEST) From: "L.Boldareva" X-X-Sender: pierro@yafa.dds.nl To: pgsql-admin@postgresql.org Subject: How to recover when can't start database Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200504/9 X-Sequence-Number: 17022 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.