Re: pg_toast_xxxxxx_index is not a btree error - Mailing list pgsql-admin

"Subbiah, Stalin" <SSubbiah@netopia.com> writes:
> We are in process of upgrading one of our postgres database from 7.2.1
> to 8.0.1. The dump was taken in copy format from 721 and imported the
> same into 801, but for some reason it fails in the middle of import with
> below error.=20

> ERROR: index "tkt_cust_pkey" is not a btree
> CONTEXT: COPY tkt_cust, line 1: "264363 Monika ..."
> ERROR: index "pg_toast_1308103_index" is not a btree
> CONTEXT: COPY tkt_acty, line 14318: "265337 6 conversation_chat_host
> Any ideas why this happens ?

Either you have a hardware problem (flaky disk drive, perhaps) or a very
seriously broken build of Postgres.

            regards, tom lane