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

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: invalid page header in block 52979 of relation "pg_attribute"
Дата
Msg-id 20041112155401.GB15213@svana.org
обсуждение исходный текст
Ответ на Re: invalid page header in block 52979 of relation "pg_attribute"  (Steve Crawford <scrawford@pinpointresearch.com>)
Ответы Re: invalid page header in block 52979 of relation "pg_attribute"  (Steve Crawford <scrawford@pinpointresearch.com>)
Список 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.

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Michelle Konzack
Дата:
Сообщение: How many secondary databases can I create?
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: How many secondary databases can I create?