pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pg_toast_xxxxxx_index is not a btree error 2+ messages / 2 participants [nested] [flat]
* pg_toast_xxxxxx_index is not a btree error @ 2005-05-10 18:05 Subbiah, Stalin <SSubbiah@netopia.com> 0 siblings, 1 reply; 2+ messages in thread From: Subbiah, Stalin @ 2005-05-10 18:05 UTC (permalink / raw) To: pgsql-admin 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: pg_toast_xxxxxx_index is not a btree error @ 2005-05-10 18:42 Tom Lane <tgl@sss.pgh.pa.us> parent: Subbiah, Stalin <SSubbiah@netopia.com> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2005-05-10 18:42 UTC (permalink / raw) To: Subbiah, Stalin <SSubbiah@netopia.com>; +Cc: 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-05-10 18:42 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2005-05-10 18:05 pg_toast_xxxxxx_index is not a btree error Subbiah, Stalin <SSubbiah@netopia.com> 2005-05-10 18:42 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox