Re: FATAL 2: PageIndexTupleDelete - Mailing list pgsql-sql

From cristi
Subject Re: FATAL 2: PageIndexTupleDelete
Date
Msg-id 003e01c3aff7$8475c740$7202a8c0@aaa
Whole thread Raw
In response to FATAL 2: PageIndexTupleDelete  ("cristi" <cristi@dmhi.ct.ro>)
List pgsql-sql
Yes, you right!
I used pg_dump command and now is working.
Thank you very much!

PS.
I have version 7.2.2 on RH 8.0

> > FATAL 2: PageIndexTupleDelete: corrupted page pointers: lower =3D 12289,
up=
> > per =3D
> > 1, special =3D 60672
>
> > Why do I have this error message and how can I fix it?
>
> This is a data-corruption problem.  Have you had any system crashes or
> other odd behavior lately?
>
> As far as recovering, you can probably fix the broken index with
> REINDEX, if the corruption doesn't extend further than the index that's
> being complained of.  Otherwise you might have to resort to a dump and
> reload.
>
> You should also think about updating your Postgres installation.  You
> didn't say what version you're running (naughty naughty, that's required
> info in any trouble report) but I can tell from the spelling of the
> error message that it's not a current release.
>
> regards, tom lane
>




pgsql-sql by date:

Previous
From: "Jerry Wintrode"
Date:
Subject: Re: Need another way to do this, my sql much to slow...
Next
From: Tom Lane
Date:
Subject: Re: Expressional Indexes