Re: FATAL 2: PageIndexTupleDelete
От | cristi |
---|---|
Тема | Re: FATAL 2: PageIndexTupleDelete |
Дата | |
Msg-id | 003e01c3aff7$8475c740$7202a8c0@aaa обсуждение исходный текст |
Ответ на | FATAL 2: PageIndexTupleDelete ("cristi" <cristi@dmhi.ct.ro>) |
Список | 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 по дате отправления: