pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / 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>
  2005-05-10 18:42 ` Re: pg_toast_xxxxxx_index is not a btree error Tom Lane <tgl@sss.pgh.pa.us>
  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: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>
  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