Re: vacuum failed - pgtoast not btree

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: vacuum failed - pgtoast not btree
Дата
Msg-id 3629.1064412579@sss.pgh.pa.us
обсуждение исходный текст
Ответ на vacuum failed - pgtoast not btree  ("pierre bach" <tuple@skynet.be>)
Список pgsql-admin
"pierre bach" <tuple@skynet.be> writes:
> Since a few days, my vacuum always fails with a message:
>     vacuum error   pg_toast_123456  not a btree  (or something like that)

Try REINDEX INDEX pg_toast.pg_toast_123456

> I am still using 7.3.2

I'd suggest an update to 7.3.4 on general principles; I don't know of
any specific bug fixes that would relate to this, though.

            regards, tom lane

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

Предыдущее
От: Robert Treat
Дата:
Сообщение: Re: STATEMENT level TRIGGER functions
Следующее
От: Robert Treat
Дата:
Сообщение: Re: steps to ensure referential integrity