Skip site navigation (1) Skip section navigation (2)

database corruption help needed

From: Ken(dot)Colson(at)sage(dot)com
To: pgsql-admin(at)postgresql(dot)org
Subject: database corruption help needed
Date: 2009-02-22 20:53:12
Message-ID: 057BEBE753E8AD4D8F202B35578D8169090C0040@gnvalex004.hs.mdmgr.net (view raw or flat)
Thread:
Lists: 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

 

Responses

pgsql-admin by date

Next:From: Tom LaneDate: 2009-02-22 23:12:14
Subject: Re: database corruption help needed
Previous:From: Tena SakaiDate: 2009-02-22 19:45:28
Subject: Re: trouble restoring data from postgres 8.3.3 to freshly installed 8.3.6

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group