Re: Can't terminate hung COPY

Поиск
Список
Период
Сортировка
От Jasen Betts
Тема Re: Can't terminate hung COPY
Дата
Msg-id kilano$h68$1@gonzo.reversiblemaps.ath.cx
обсуждение исходный текст
Ответ на Can't terminate hung COPY  (David Rees <drees76@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: timeofday() and clock_timestamp() produce different results when casting to timestamptz
Следующее
От: Kenroy Bennett
Дата:
Сообщение: Need advice on best system to choose