Re: Can't terminate hung COPY

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