| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Subbiah, Stalin" <SSubbiah(at)netopia(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: pg_toast_xxxxxx_index is not a btree error |
| Date: | 2005-05-10 18:42:54 |
| Message-ID: | 22461.1115750574@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
"Subbiah, Stalin" <SSubbiah(at)netopia(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joel Fradkin | 2005-05-10 18:47:06 | Many idle processes? |
| Previous Message | Subbiah, Stalin | 2005-05-10 18:05:10 | pg_toast_xxxxxx_index is not a btree error |