Re: keepalive in libpq using

On Tue, Jul 6, 2010 at 1:08 PM, Pavel Golub <pavel(at)microolap(dot)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