Re: invalid page header in block 52979 of relation "pg_attribute"

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