| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Steve Crawford <scrawford(at)pinpointresearch(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: invalid page header in block 52979 of relation "pg_attribute" |
| Date: | 2004-11-12 15:54:02 |
| Message-ID: | 20041112155401.GB15213@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)svana(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2004-11-12 16:01:20 | Re: How many secondary databases can I create? |
| Previous Message | Michelle Konzack | 2004-11-12 15:18:13 | How many secondary databases can I create? |