Re: 7.4.1 & invalid page header in block

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 7.4.1 & invalid page header in block
Дата
Msg-id 6187.1081318541@sss.pgh.pa.us
обсуждение исходный текст
Ответ на 7.4.1 & invalid page header in block  (Pailloncy Jean-Gérard <pailloncy@ifrance.com>)
Список pgsql-general
=?ISO-8859-1?Q?Pailloncy_Jean-G=E9rard?= <pailloncy@ifrance.com> writes:
> ERROR:  invalid page header in block 4602 of relation "url"
> url is a index for web. I do not care if I loose few data.
> How can I correct table url ?

If it's an index then you can just REINDEX.  However, you would be
extremely foolish to just reindex and forget the problem.  This suggests
strongly that you have hardware problems --- if so, your next problem is
likely to be with an irreplaceable table rather than an easily
rebuildable index :-(.  I'd suggest running the usual barrage of
hardware tests: memtest86, badblocks, etc...

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: PERFORM statement inside procedure
Следующее
От: "Rajat Katyal"
Дата:
Сообщение: Re: PERFORM statement inside procedure