Re: invalid page header in block 52979 of relation "pg_attribute" - Mailing list pgsql-general

From Steve Crawford
Subject Re: invalid page header in block 52979 of relation "pg_attribute"
Date
Msg-id 200411111529.38843.scrawford@pinpointresearch.com
Whole thread Raw
In response to Re: invalid page header in block 52979 of relation "pg_attribute"  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: invalid page header in block 52979 of relation "pg_attribute"
Re: invalid page header in block 52979 of relation "pg_attribute"
List pgsql-general
On Thursday 11 November 2004 3:14 pm, Tom Lane wrote:
> Steve Crawford <scrawford@pinpointresearch.com> writes:
> > This morning I got bitten by the "SELECT INTO" / "CREATE TABLE
> > AS" from tables without OIDs bug in 7.4.1.
>
> On a production server, you really ought to track bug-fix releases
> a bit more enthusiastically than that :-(.  However, I don't see
> anything in the CVS history that looks related to your problem.

True. I hadn't come up with a good time to get past that 7.4.1 ->
7.4.2 initdb requirement. I guess I'll have to go with the manual
method.

> > Now I am getting 'invalid page header in block 52979 of relation
> > "pg_attribute"' errors in the postgresql log file.
>
> Could you get a hex dump of that page?

What is the best method to do this? Also, can I safely drop that table
and recreate it from a dump file?

Cheers,
Steve

pgsql-general by date:

Previous
From: Terry Lee Tucker
Date:
Subject: Re: OID Question
Next
From: Tom Lane
Date:
Subject: Re: invalid page header in block 52979 of relation "pg_attribute"