Re: Can't terminate hung COPY

David Rees <drees76(at)gmail(dot)com> writes:
> On Wed, Mar 20, 2013 at 12:37 PM, David Rees <drees76(at)gmail(dot)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.

That seems to point the finger at the network stack: what is probably
happening is it's failing to abort a recv() or send() when the process
receives a signal. You might see if you can confirm that diagnosis,
perhaps by watching the backend process with strace, or by attaching to
it after the fact with gdb and seeing where the stack trace leads.

regards, tom lane