Re: Can't terminate hung COPY - Mailing list pgsql-general

From David Rees
Subject Re: Can't terminate hung COPY
Date
Msg-id CAHtT9RvNM8KFB1eeh0bbGkXiRdRPOQWd-6WF+n6HLENKgkp4TA@mail.gmail.com
Whole thread Raw
In response to Can't terminate hung COPY  (David Rees <drees76@gmail.com>)
Responses Re: Can't terminate hung COPY
List pgsql-general
On Wed, Mar 20, 2013 at 12:37 PM, David Rees <drees76@gmail.com> wrote:
> PostgreSQL 8.4.16 on CentOS 5.9.
>
> I've run into a situation where executing a \COPY from psql will hang
> and at that point it's impossible to terminate the COPY command.

Some additional notes:

Running psql on the same LAN for some reason works fine with the same
COPY file. On a remote network it hangs.

Tried against a PostgreSQL 9.2.3 server, same results.

The file that is being copied from is a single row - one of the
columns has decent number of \r\n in it, deleting all of either the \r
or the \n in the file allows the \COPY to succeed.

I'm trying to narrow it down to a simple test case...

-Dave


pgsql-general by date:

Previous
From: Rob Sargent
Date:
Subject: Re: State of the art re: group default privileges
Next
From: Tom Lane
Date:
Subject: Re: Can't terminate hung COPY