Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 386439F98F1 for ; Sun, 7 Oct 2007 22:58:34 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 01575-05 for ; Sun, 7 Oct 2007 22:58:22 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from rv-out-0910.google.com (rv-out-0910.google.com [209.85.198.188]) by postgresql.org (Postfix) with ESMTP id BE09B9F9753 for ; Sun, 7 Oct 2007 22:58:30 -0300 (ADT) Received: by rv-out-0910.google.com with SMTP id l15so550461rvb for ; Sun, 07 Oct 2007 18:58:28 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=iPDPeOLoIINb1DUQHY4i2KhACKyTxn/jUKjrS38rcmo=; b=qUJe7354d7PvD63d5Ya2ck5HkCCwjAzLp4M4ulZpvQve5NMfUmSLQXIGITRSl2AeavJMyP9tjGWjGeePZYhGeDUPMRMTI5wI7j2ydpQUaYrJG7V6Mi+ZhkMbpfl+XAVOmREQN25WM8Z2oLN5RjarWWA2UjtbmCKhXJWfFDGEoNc= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=QNI5VNtdFOdV1xNq4l2g1hX8Dr9RH8XlSA8ZrFxwAp7OXu9HxvoDaH6dtE5P9XKKpx/XCBFehUeGVE35agqb1bW9ivkAxHS03UilJ0TK6hvBAaL8pod2jpLqeHz2vRFax1b+4oYPeOhoFDxOfCCYMl4CB7AUHTcb82mSaLmneR8= Received: by 10.141.34.12 with SMTP id m12mr206775rvj.1191808708344; Sun, 07 Oct 2007 18:58:28 -0700 (PDT) Received: by 10.141.84.12 with HTTP; Sun, 7 Oct 2007 18:58:28 -0700 (PDT) Message-ID: Date: Mon, 8 Oct 2007 14:58:28 +1300 From: "Mike C" To: pgsql-admin@postgresql.org Subject: Re: Database Recovery In-Reply-To: <26143.1191808096@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <26143.1191808096@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/43 X-Sequence-Number: 26957 On 10/8/07, Tom Lane wrote: > "Mike C" writes: > > I have a corrupt database. I copied the database directory offsite and > > restored from a backup. I'm now trying to recover data in the corrupt > > database added since the last backup. Any advice on how to approach > > this? > > If you're lucky, REINDEX might solve your problems. The messages you > showed are all about index corruption, which REINDEX can fix. If you've > got corruption in the tables themselves then you might be screwed, but > try reindexing and see what happens ... My problem is that I can't even start postmaster to perform the reindex on now. As soon as I try start (via pg_ctl, 8.1.10): postgres_report[24165]: [1-1] LOG: database system was interrupted while in recovery at 2007-10-04 12:32:46 NZST postgres_report[24165]: [1-2] HINT: This probably means that some data is corrupted and you will have to use the last backup for recovery. postgres_report[24165]: [2-1] LOG: checkpoint record is at 520/66DDD00 postgres_report[24165]: [3-1] LOG: redo record is at 520/66DDD00; undo record is at 0/0; shutdown FALSE postgres_report[24165]: [4-1] LOG: next transaction ID: 334746303; next OID: 32829 postgres_report[24165]: [5-1] LOG: next MultiXactId: 1; next MultiXactOffset: 0 postgres_report[24165]: [6-1] LOG: database system was not properly shut down; automatic recovery in progress postgres_report[24165]: [7-1] LOG: redo starts at 520/66DDD50 postgres_report[24165]: [8-1] LOG: record with zero length at 520/6E2D130 postgres_report[24165]: [9-1] LOG: redo done at 520/6E2D100 postgres_report[24165]: [10-1] PANIC: failed to re-find parent key in "24977" for split pages 230790/263989 postgres_report[24164]: [1-1] LOG: startup process (PID 24165) was terminated by signal 6 Oct 4 12:32:57 serena postgres_report[24164]: [2-1] LOG: aborting startup due to startup process failure Thanks, Mike