| From: | "cristi" <cristi(at)dmhi(dot)ct(dot)ro> |
|---|---|
| To: | <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: FATAL 2: PageIndexTupleDelete |
| Date: | 2003-11-21 06:20:10 |
| Message-ID: | 003e01c3aff7$8475c740$7202a8c0@aaa |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-11-21 06:45:16 | Re: Expressional Indexes |
| Previous Message | Jerry Wintrode | 2003-11-20 23:26:00 | Re: Need another way to do this, my sql much to slow... |