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