Re: Connection remains idle for more than 15 minutes, then the connection drops by IPVS setting in k8s kube-proxy

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: M Tarkeshwar Rao <m(dot)tarkeshwar(dot)rao(at)ericsson(dot)com>, Matthias Apitz <guru(at)unixarea(dot)de>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, Piyush Anand <piyush(dot)anand(at)ericsson(dot)com>, Neeraj Gupta G <neeraj(dot)g(dot)gupta(at)ericsson(dot)com>
Subject: Re: Connection remains idle for more than 15 minutes, then the connection drops by IPVS setting in k8s kube-proxy
Date: 2024-03-05 11:54:59
Message-ID: ffc11479cfb22e1053072e391fc8d16662d1634d.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 2024-03-05 at 11:37 +0000, M Tarkeshwar Rao wrote:
> We want to use libpq library APIs only. Is there any support of keepalive at client side?

Yes, there is.

Just add "keepalives_idle=60" to the connection string. See
https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-KEEPALIVES-IDLE

Yours,
Laurenz Albe

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Brecht De Rooms 2024-03-05 12:21:01 Re: CTEs and concurrency
Previous Message M Tarkeshwar Rao 2024-03-05 11:37:25 RE: Connection remains idle for more than 15 minutes, then the connection drops by IPVS setting in k8s kube-proxy