| From: | Jasen Betts <jasen(at)xnet(dot)co(dot)nz> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Can't terminate hung COPY |
| Date: | 2013-03-23 22:35:36 |
| Message-ID: | kilano$h68$1@gonzo.reversiblemaps.ath.cx |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 2013-03-20, David Rees <drees76(at)gmail(dot)com> wrote:
> 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.
might be some sort of data dependant error,
perhaps reboot your router.
--
⚂⚃ 100% natural
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kenroy Bennett | 2013-03-23 23:03:56 | Need advice on best system to choose |
| Previous Message | Tom Lane | 2013-03-23 15:16:26 | Re: timeofday() and clock_timestamp() produce different results when casting to timestamptz |