From: Tom Lane <tgl@sss.pgh.pa.us>
To: The One <i51359@yahoo.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Panic: Page Add Item: Corrupted page pointers
Date: Sun, 11 Sep 2005 20:01:49 -0400
Message-ID: <10806.1126483309@sss.pgh.pa.us> (raw)
In-Reply-To: <20050911170927.21040.qmail@web33912.mail.mud.yahoo.com>
References: <20050911170927.21040.qmail@web33912.mail.mud.yahoo.com>
The One <i51359@yahoo.com> writes:
> I'm getting this error when try to create a table in Postgresql 7.3, windows2000:
> Panic: Page Add Item: Corrupted page pointers: lower=24258, upper=39318, special=65421
Apparently you've got at least one corrupt page in at least one system
table. I'd recommend pg_dump'ing as much as you can and then recreate
the database.
If pg_dump doesn't work you could try turning on zero_damaged_pages,
and praying that most of what you need is on undamaged pages. It's
quite possible though that that will hose the DB completely, so don't do
it till you've exhausted the possibilities for pg_dump without it.
Consider updating to a more recent PG release while you are
recovering...
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: tgl@sss.pgh.pa.us, i51359@yahoo.com
Subject: Re: Panic: Page Add Item: Corrupted page pointers
In-Reply-To: <10806.1126483309@sss.pgh.pa.us>
* 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