Postgres Pro
Downloads
Home   >   mailing lists

Thread: pg_toast_xxxxxx_index is not a btree error

pg_toast_xxxxxx_index is not a btree error

From
"Subbiah, Stalin"
Date:

Hi,

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.

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 ?
Thanks,
Stalin

Re: pg_toast_xxxxxx_index is not a btree error

From
Tom Lane
Date:
"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