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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
Cc: "PostgreSQL" <pgsql-general(at)postgresql(dot)org>
Subject: Re: invalid page header in block 52979 of relation "pg_attribute"
Date: 2004-11-11 23:14:16
Message-ID: 12745.1100214856@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Steve Crawford <scrawford(at)pinpointresearch(dot)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.

> 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?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Hallgren 2004-11-11 23:14:46 GUC custom variables broken
Previous Message Steve Crawford 2004-11-11 22:46:27 invalid page header in block 52979 of relation "pg_attribute"