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

From Jasen Betts
Subject Re: Can't terminate hung COPY
Date
Msg-id kilano$h68$1@gonzo.reversiblemaps.ath.cx
Whole thread Raw
In response to Can't terminate hung COPY  (David Rees <drees76@gmail.com>)
List pgsql-general
On 2013-03-20, David Rees <drees76@gmail.com> wrote:
> 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.

might be some sort of data dependant error,
perhaps reboot your router.


--
⚂⚃ 100% natural

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: timeofday() and clock_timestamp() produce different results when casting to timestamptz
Next
From: Kenroy Bennett
Date:
Subject: Need advice on best system to choose