Error importing data in Postgres 7.0.3

From: "Sebastien Coureau" <lifo(at)elma(dot)fr>
To: pgsql-general(at)postgresql(dot)org
Subject: Error importing data in Postgres 7.0.3
Date: 2001-01-03 14:51:46
Message-ID: 92vecf$ngq$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I've got a problem when doing an import of data after a backup.

bkp cmd: pg_dump mydatabase > db

Then I dropped the base and recreate one.

When doing a "psql -e mydatabase < db", an error occured when recreating
indexes.

The error is :
-------------------------
FATAL 1: btree: failed to add item to the page in _bt_sort (2)
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
connection to server was lost
-------------------------

It seems to be because if lower index is > than upper ...
The source code for this error is in :the file
"src/backend/access/nbtree/nbsort.c

I understood that this problem was existing in earlier version of Postgres,
like 6.5.*
Is there any solution to make my import of data working properly.

Thanks a lot for any help.

--
Lifo.

Browse pgsql-general by date

  From Date Subject
Next Message Gregory Wood 2001-01-03 15:05:06 > > > Then it goes right back to what someone else eluded to... If you
Previous Message Vince Vielhaber 2001-01-03 14:43:20 Re: Re: RE: Re: MySQL and PostgreSQL speed compare