Re: COPY failure - Mailing list pgsql-general

From Tom Lane
Subject Re: COPY failure
Date
Msg-id 9428.995727707@sss.pgh.pa.us
Whole thread Raw
In response to COPY failure  (x <xbdelacour@yahoo.com>)
List pgsql-general
x <xbdelacour@yahoo.com> writes:
> pqReadData() -- backend closed the channel unexpectedly.

That shouldn't happen :-(.  Look for a core file in $PGDATA/base/yourdb/core
(if you don't find one, you probably need to restart the postmaster with
"ulimit -c unlimited" to allow core dumps).  Then do
    gdb /path/to/postgres/executable /path/to/corefile
    gdb> bt
    gdb> quit
and send us the results.

BTW, what Postgres version is this, and what are the declarations of the
tables being loaded?

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Performance impact of NULLs and variable length fields
Next
From: Tom Lane
Date:
Subject: Re: How Postgresql Compares For Query And Load Operations