Home > mailing lists

Thread: vacuum failed - pgtoast not btree

vacuum failed - pgtoast not btree

From

"pierre bach"

Date:

24 September 2003, 13:26:41

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

From

Tom Lane

Date:

24 September 2003, 14:09:54

"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