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