Re: [ADMIN] vacuum fails with 'invalid page header' message

Поиск
Список
Период
Сортировка
От Geoffrey
Тема Re: [ADMIN] vacuum fails with 'invalid page header' message
Дата
Msg-id 459ECEE8.5030806@3times25.net
обсуждение исходный текст
Ответ на vacuum fails with 'invalid page header' message  (Geoffrey <esoteric@3times25.net>)
Ответы Re: [ADMIN] vacuum fails with 'invalid page header' message  (Scott Marlowe <smarlowe@g2switchworks.com>)
Список pgsql-general
Geoffrey wrote:
> We had a vacuum fail recently with the following error:
>
> invalid page header in block 846 of relation "move_pkey"
>
> Anyone have an idea what could cause this problem and what we need to do
>  to resolve it?
>
> Running on Red Hat Enterprise 3, postgres 7.4.13

Regarding the issue above, is it possible that re-indexing the database
could resolve the problem, since the error is related to an index.
move_pkey is an index on field recid.

--
Until later, Geoffrey

Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
  - Benjamin Franklin

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

Предыдущее
От: "Raymond O'Donnell"
Дата:
Сообщение: Re: Slony across platforms
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Slony across platforms