Horton

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

Laurenz Albe <laurenz.albe@cybertec.at>

View thread View on postgr.es
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com>, Matthias Apitz <guru@unixarea.de>
Cc: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>, Piyush Anand <piyush.anand@ericsson.com>, Neeraj Gupta G <neeraj.g.gupta@ericsson.com>
Date: 2024-03-05T11:54:59Z
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