Re: keepalive in libpq using - Mailing list pgsql-hackers

From Robert Haas
Subject Re: keepalive in libpq using
Date
Msg-id AANLkTik2y4IYCtzWPqFb4wd5Ml7l_UoJKq9AEuLkSdAO@mail.gmail.com
Whole thread Raw
In response to keepalive in libpq using  (Pavel Golub <pavel@microolap.com>)
Responses Re: keepalive in libpq using
List pgsql-hackers
On Tue, Jul 6, 2010 at 1:08 PM, Pavel Golub <pavel@microolap.com> wrote:
> While I'm very excited about enabling keepalives in libpq, I want to
> know how can I use this functionality in my application?
>
> Let's imagine that I connect to a server with keepalives option, other
> options (keepalives_idle, keepalives_interval, keepalives_count) are
> used either. Then network goes down. So, how will I know that
> connection is dead? Any callback function? Or should I check PQstatus
> periodically?

I'm not sure, exactly.  I think what'll happen is that if you're
trying to read data from the remote server, the connection will
eventually break instead of hanging forever, but I'm not exactly sure
what that'll look like at the libpq level.  I'm not sure what effect
it'll have on an idle connection.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Partitioning syntax
Next
From: Magnus Hagander
Date:
Subject: Re: Keepalives win32