Re: Cursor copy_from with server crash

Поиск
Список
Период
Сортировка
От Marko Kreen
Тема Re: Cursor copy_from with server crash
Дата
Msg-id CACMqXCJpJFw1TzCcUf8GjgaEoHAGoCj+Rxno9fVeN+EK8Yv_Mg@mail.gmail.com
обсуждение исходный текст
Ответ на Cursor copy_from with server crash  (Grant McKenzie <mckenzig@optonline.net>)
Список psycopg
On Thu, Sep 29, 2011 at 5:36 PM, Grant McKenzie <mckenzig@optonline.net> wrote:
> Using copy_from to insert a bunch of data. While this is running, the server host crashes and restarts. Getting a
stacktracefrom our client process, the copy_from never returned ( presumably no tcp close was received ) 
>
> Are there any common designs for protecting from host crashes, particularly when using copy_from?

TCP keepalive, see libpq params in 9.0+

--
marko

В списке psycopg по дате отправления:

Предыдущее
От: Croepha
Дата:
Сообщение: A successful SELECT 1; on failed connection
Следующее
От: Marko Kreen
Дата:
Сообщение: Re: A successful SELECT 1; on failed connection