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

From Martijn van Oosterhout
Subject Re: invalid page header in block 52979 of relation "pg_attribute"
Date
Msg-id 20041112155401.GB15213@svana.org
Whole thread Raw
In response to Re: invalid page header in block 52979 of relation "pg_attribute"  (Steve Crawford <scrawford@pinpointresearch.com>)
Responses Re: invalid page header in block 52979 of relation "pg_attribute"
List pgsql-general
On Thu, Nov 11, 2004 at 04:29:38PM -0700, Steve Crawford wrote:
> 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.

IIRC, the initdb is recommended, but not required. It can be done
without an initdb too. Check the release notes for more details. You
may as well jump to the most recent...

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

Errr, pg_attribute is what holds the information about column names,
types and other such details. Most of your schema really.

It would need a full restore if you dropped it...

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

Attachment

pgsql-general by date:

Previous
From: Michelle Konzack
Date:
Subject: How many secondary databases can I create?
Next
From: Martijn van Oosterhout
Date:
Subject: Re: How many secondary databases can I create?