| From: | Steve Crawford <scrawford(at)pinpointresearch(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| 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:29:38 |
| Message-ID: | 200411111529.38843.scrawford@pinpointresearch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thursday 11 November 2004 3:14 pm, Tom Lane wrote:
> 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.
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-11-11 23:45:35 | Re: GUC custom variables broken |
| Previous Message | Kevin Barnard | 2004-11-11 23:25:00 | Re: Vacuum message |