database corruption help needed - Mailing list pgsql-admin

From Ken.Colson@sage.com
Subject database corruption help needed
Date
Msg-id 057BEBE753E8AD4D8F202B35578D8169090C0040@gnvalex004.hs.mdmgr.net
Whole thread Raw
Responses Re: database corruption help needed  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: database corruption help needed  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-admin

Greetings,

 

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

 

So I attempted to reindex the database and now I get this error:

 

ERROR:  could not create unique index

DETAIL:  Table contains duplicated values.

 

But it does not mention which index it is trying to build, so I am at a little bit of a stand still.  I am currently vaccuming the database to see if that helps, but...I don't know what else to do from here.

 

Any suggestions?  I am running 8.2.5 on 64bit Linux.

 

Thanks in advance,

Ken

 

pgsql-admin by date:

Previous
From: "Tena Sakai"
Date:
Subject: Re: trouble restoring data from postgres 8.3.3 to freshly installed 8.3.6
Next
From: Tom Lane
Date:
Subject: Re: database corruption help needed