Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 4A56C632941 for ; Sun, 22 Feb 2009 19:12:20 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 29206-06 for ; Sun, 22 Feb 2009 19:12:17 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id 3E1E4632369 for ; Sun, 22 Feb 2009 19:12:17 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id n1MNCEYF015371; Sun, 22 Feb 2009 18:12:15 -0500 (EST) To: Ken.Colson@sage.com cc: pgsql-admin@postgresql.org Subject: Re: database corruption help needed In-reply-to: <057BEBE753E8AD4D8F202B35578D8169090C0040@gnvalex004.hs.mdmgr.net> References: <057BEBE753E8AD4D8F202B35578D8169090C0040@gnvalex004.hs.mdmgr.net> Comments: In-reply-to Ken.Colson@sage.com message dated "Sun, 22 Feb 2009 15:53:12 -0500" Date: Sun, 22 Feb 2009 18:12:14 -0500 Message-ID: <15370.1235344334@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200902/189 X-Sequence-Number: 31410 Ken.Colson@sage.com writes: > I had a hardware problem this morning, which I believe is now resolved, but > I seem to have a little database corruption issue. This is what I am seeing > when I restart postgres: > PANIC: right sibling's left-link doesn't match 8.2.6 and later provide a little more detail in that message --- try updating. (Be sure the update is built with same options as your existing 8.2.5 installation.) regards, tom lane