Re: libpq heartbeat - Mailing list pgsql-general

From Tom Lane
Subject Re: libpq heartbeat
Date
Msg-id 3654.1477585974@sss.pgh.pa.us
Whole thread Raw
In response to Re: libpq heartbeat  (Francisco Olarte <folarte@peoplecall.com>)
Responses Re: libpq heartbeat  (Francisco Olarte <folarte@peoplecall.com>)
Re: libpq heartbeat  (Marcin Giedz <marcin.giedz@arise.pl>)
List pgsql-general
Francisco Olarte <folarte@peoplecall.com> writes:
> On Thu, Oct 27, 2016 at 5:01 PM, hubert depesz lubaczewski
> <depesz@depesz.com> wrote:
>> On Thu, Oct 27, 2016 at 04:43:55PM +0200, Marcin Giedz wrote:
>>> I'm wondering if there is any natural implementation of heartbeats in
>>> libpq library?

>> check tcp_keepalives_* in postgresql.conf

> Isn't this a server setting, and so going to affect every connection,

Yes, but there are equivalent libpq parameters for firing heartbeat
pings from the client side.  Those are per-connection.

https://www.postgresql.org/docs/current/static/libpq-connect.html#LIBPQ-PARAMKEYWORDS

            regards, tom lane


pgsql-general by date:

Previous
From: Francisco Olarte
Date:
Subject: Re: libpq heartbeat
Next
From: Kim Rose Carlsen
Date:
Subject: How to hint two columns IS NOT DISTINCT FROM each other in a join