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,
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2009-02-22 23:12:14|
|Subject: Re: database corruption help needed |
|Previous:||From: Tena Sakai||Date: 2009-02-22 19:45:28|
|Subject: Re: trouble restoring data from postgres 8.3.3 to freshly installed 8.3.6|