From: Tom Lane <tgl@sss.pgh.pa.us>
To: Hornyak Laszlo <kocka@tigrasoft.hu>
Cc: pgsql-admin@postgresql.org
Subject: Re: invalid page header
Date: Thu, 25 Sep 2003 20:27:55 -0400
Message-ID: <5816.1064536075@sss.pgh.pa.us> (raw)
In-Reply-To: <Pine.LNX.4.21.0309252056430.5789-100000@tiger.tigrasoft.hu>
References: <Pine.LNX.4.21.0309252056430.5789-100000@tiger.tigrasoft.hu>
Hornyak Laszlo <kocka@tigrasoft.hu> writes:
> I have a problem again, now with PostgreSQL 7.3.4. One of my 1.8 million
> rows tables have damaged, it operated all the day and now it is off, we
> don`t know the reason. When we try to dump or select from it, it says
> 'Invalid page header in block 12345 in prep'.
> Does anybody know how to make our table healthy again?
You could zero out that page (while the postmaster is stopped,
preferably) but you ought to first try to figure out what data you are
going to lose. Dumping the page with pg_filedump might provide some
clues. See this thread for a recent exercise in file-dumping:
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&threadm=20030922162322.E12708%40quart...
Or you could just use dd; since the page header is corrupt, it's
unlikely that pg_filedump will be able to give you anything smarter
than a bare hex/ascii dump (-d mode), which dd and od could do as well.
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-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, kocka@tigrasoft.hu
Subject: Re: invalid page header
In-Reply-To: <5816.1064536075@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