corruption bug in 7.2.3-RH

Поиск
Список
Период
Сортировка
От Jonathan Ellis
Тема corruption bug in 7.2.3-RH
Дата
Msg-id 3E4412BE.7030604@carnageblender.com
обсуждение исходный текст
Ответы Re: corruption bug in 7.2.3-RH
Re: corruption bug in 7.2.3-RH
Список pgsql-general
when trying to vacuum I got this:

FATAL 2:  PageIndexTupleDelete: corrupted page pointers: lower = 21845,
upper = 21845, special = 21845

I experimentally determined the problem was with my "users" table.  I
did a pg_dump -t on it, manually deleted all triggers, dropped the
table, and loaded from the dump.  This fixed it.  (Merely deleting all
rows from the table & re-copying did not.)  For future reference, is
there an easier fix?  Is this fixed in 7.3.2?

-Jonathan


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

Предыдущее
От: "Berend Tober"
Дата:
Сообщение: Re: converting Oracle to postgres
Следующее
От: John Smith
Дата:
Сообщение: Re: selects with large offset really slow