Re: invalid page header in pg_statistic

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: invalid page header in pg_statistic
Дата
Msg-id 13313.1170864091@sss.pgh.pa.us
обсуждение исходный текст
Ответ на invalid page header in pg_statistic  ("Ed L." <pgsql@bluepolka.net>)
Ответы Re: invalid page header in pg_statistic  ("Ed L." <pgsql@bluepolka.net>)
Re: invalid page header in pg_statistic  ("Ed L." <pgsql@bluepolka.net>)
Список pgsql-general
"Ed L." <pgsql@bluepolka.net> writes:
> How do I fix this 7.4.6 issue short of initdb?
>     invalid page header in block 110 of relation "pg_statistic"
> I looked at the block via pg_filedump (included below), and it
> does not appear to me to be corrupted, so not sure what I would
> zero out, if anything.

Seems odd to me too ... but pg_statistic doesn't contain any
irreplaceable data.  See if you can TRUNCATE it.  If so, do
an ANALYZE to repopulate it.  I don't recall if 7.4 has any
special hoops you'd have to jump through to truncate a system
catalog ...

            regards, tom lane

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

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: invalid page header in pg_statistic
Следующее
От: MargaretGillon@chromalloy.com
Дата:
Сообщение: Re: Limit for number of Joins in a View? Version 8.1.4 on Redhat 9