Skip site navigation (1) Skip section navigation (2)

Re: Cursor copy_from with server crash

From: Marko Kreen <markokr(at)gmail(dot)com>
To: Grant McKenzie <mckenzig(at)optonline(dot)net>
Cc: "psycopg(at)postgresql(dot)org" <psycopg(at)postgresql(dot)org>
Subject: Re: Cursor copy_from with server crash
Date: 2011-09-30 05:54:14
Message-ID: CACMqXCJpJFw1TzCcUf8GjgaEoHAGoCj+Rxno9fVeN+EK8Yv_Mg@mail.gmail.com (view raw or flat)
Thread:
Lists: psycopg
On Thu, Sep 29, 2011 at 5:36 PM, Grant McKenzie <mckenzig(at)optonline(dot)net> wrote:
> Using copy_from to insert a bunch of data. While this is running, the server host crashes and restarts. Getting a stacktrace from 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

In response to

psycopg by date

Next:From: Marko KreenDate: 2011-09-30 05:56:50
Subject: Re: A successful SELECT 1; on failed connection
Previous:From: CroephaDate: 2011-09-29 19:34:31
Subject: A successful SELECT 1; on failed connection

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group