Re: [GENERAL] HELP needed : COPY datas from file

From: Oleg Broytmann <phd(at)emerald(dot)netskate(dot)ru>
To: Ming-Hung Eng <mheng(at)hachette-multimedia(dot)fr>
Cc: pgsql-general(at)hub(dot)org
Subject: Re: [GENERAL] HELP needed : COPY datas from file
Date: 1999-06-16 12:54:37
Message-ID: Pine.LNX.4.04.9906161654001.1746-100000@emerald.netskate.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)earthling(dot)net
Programmers don't die, they just GOSUB without RETURN.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dan Wilson 1999-06-16 13:53:05 Re: [GENERAL] Fw: Can't even specify template
Previous Message Ming-Hung Eng 1999-06-16 12:44:05 [GENERAL] HELP needed : COPY datas from file