Search Postgresql Archives

Re: Can't terminate hung COPY

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, Mar 20, 2013 at 12:37 PM, David Rees <drees76@xxxxxxxxx> 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


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux