Re: vacuum failed - pgtoast not btree

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "pierre bach" <tuple(at)skynet(dot)be>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: vacuum failed - pgtoast not btree
Date: 2003-09-24 14:09:39
Message-ID: 3629.1064412579@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"pierre bach" <tuple(at)skynet(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Robert Treat 2003-09-24 14:11:44 Re: steps to ensure referential integrity
Previous Message Robert Treat 2003-09-24 13:58:53 Re: STATEMENT level TRIGGER functions