[GENERAL] HELP needed : COPY datas from file

Started by Ming-Hung Engalmost 27 years ago2 messagesgeneral
Jump to latest
#1Ming-Hung Eng
mheng@hachette-multimedia.fr

Hi

I have a problem to copy datas from unix file, I get the following message
when I try to import
a file with more 200000 lines :

pgReadData() -- backend closed the channel unexpectedly
This probably means the backend terminated abnormally before or while
processing the request.
We have lost the connection to the backend, so further processing is
impossible. Terminating.

I use postgres 6.4.2 on solaris.

Thanks for your help!

--
ENG Ming Hung

#2Oleg Broytmann
phd@emerald.netskate.ru
In reply to: Ming-Hung Eng (#1)
Re: [GENERAL] HELP needed : COPY datas from file

Hi!

On Wed, 16 Jun 1999, Ming-Hung Eng wrote:

I have a problem to copy datas from unix file, I get the following message
when I try to import
a file with more 200000 lines :

pgReadData() -- backend closed the channel unexpectedly
This probably means the backend terminated abnormally before or while
processing the request.
We have lost the connection to the backend, so further processing is
impossible. Terminating.

I use postgres 6.4.2 on solaris.

There is a memory leak in 6.4.2. Split your data into smaller chunks...

Thanks for your help!

--
ENG Ming Hung

Oleg.
----
Oleg Broytmann http://members.xoom.com/phd2/ phd2@earthling.net
Programmers don't die, they just GOSUB without RETURN.