From: cristi <cristi@dmhi.ct.ro>
To: pgsql-sql@postgresql.org
Subject: Re: FATAL 2: PageIndexTupleDelete
Date: Fri, 21 Nov 2003 08:20:10 +0200
Message-ID: <003e01c3aff7$8475c740$7202a8c0@aaa> (raw)
References: <004801c3acfc$c6b395e0$7201a8c0@aaa>
<1036.1069301945@sss.pgh.pa.us>
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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: cristi@dmhi.ct.ro
Subject: Re: FATAL 2: PageIndexTupleDelete
In-Reply-To: <003e01c3aff7$8475c740$7202a8c0@aaa>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox