Postgres Pro
Downloads
Home   >   mailing lists

Re: vacuum failed - pgtoast not btree - Mailing list pgsql-admin

From Tom Lane
Subject Re: vacuum failed - pgtoast not btree
Date
Msg-id 3629.1064412579@sss.pgh.pa.us
Whole thread Raw
In response to vacuum failed - pgtoast not btree  ("pierre bach" <tuple@skynet.be>)
List pgsql-admin
Tree view 
"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 by date:

Previous
From: Robert Treat
Date:
Subject: Re: STATEMENT level TRIGGER functions
Next
From: Robert Treat
Date:
Subject: Re: steps to ensure referential integrity