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

From Laurenz Albe
Subject Re: Connection remains idle for more than 15 minutes, then the connection drops by IPVS setting in k8s kube-proxy
Date
Msg-id ffc11479cfb22e1053072e391fc8d16662d1634d.camel@cybertec.at
Whole thread Raw
In response to RE: Connection remains idle for more than 15 minutes, then the connection drops by IPVS setting in k8s kube-proxy  (M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com>)
List 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



pgsql-general by date:

Previous
From: M Tarkeshwar Rao
Date:
Subject: RE: Connection remains idle for more than 15 minutes, then the connection drops by IPVS setting in k8s kube-proxy
Next
From: Brecht De Rooms
Date:
Subject: Re: CTEs and concurrency