Обсуждение: database corruption help needed
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
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
On Sun, Feb 22, 2009 at 1:53 PM, <Ken.Colson@sage.com> wrote: > 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 > Know that if you do get the database mostly or all the way back up, it is not to be trusted, and you should make a backup, reinitdb and then restore to a fresh database cluster.