X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 43FBCD1B510 for ; Thu, 20 Nov 2003 04:19:57 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 37422-09 for ; Thu, 20 Nov 2003 00:19:25 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id D4AF3D1B4F6 for ; Thu, 20 Nov 2003 00:19:24 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.10/8.12.10) with ESMTP id hAK4J619001037; Wed, 19 Nov 2003 23:19:06 -0500 (EST) To: "cristi" Cc: pgsql-sql@postgresql.org Subject: Re: FATAL 2: PageIndexTupleDelete In-reply-to: <004801c3acfc$c6b395e0$7201a8c0@aaa> References: <004801c3acfc$c6b395e0$7201a8c0@aaa> Comments: In-reply-to "cristi" message dated "Mon, 17 Nov 2003 13:20:16 +0200" Date: Wed, 19 Nov 2003 23:19:05 -0500 Message-ID: <1036.1069301945@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/248 X-Sequence-Number: 16063 "cristi" writes: > 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