vacuum failed - pgtoast not btree

Поиск
Список
Период
Сортировка
Искать

vacuum failed - pgtoast not btree

От:
"pierre bach" <tuple@skynet.be>
Дата:
Hello,
 
Since a few days, my vacuum always fails with a message:
    vacuum error   pg_toast_123456  not a btree  (or something like that)
I am still using 7.3.2
How can I solve this ??
 
Thanks
Pierre

Re: vacuum failed - pgtoast not btree

От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
"pierre bach"  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
FAQ