Postgres Pro
Downloads
Home   >   mailing lists

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

From M Tarkeshwar Rao
Subject Connection remains idle for more than 15 minutes, then the connection drops by IPVS setting in k8s kube-proxy
Date
Msg-id PAWPR07MB10095D5E7FF7D783427860B09AE222@PAWPR07MB10095.eurprd07.prod.outlook.com
Whole thread Raw
Responses Connection remains idle for more than 15 minutes, then the connection drops by IPVS setting in k8s kube-proxy
List pgsql-general
Tree view

Hi Tarkesh,

 

“

We are using libpq c client (Version : 14.10) of postgresql in our application to connect with postgresql database server (Version 14.10).

For making connection we are using libpq's API "PQsetdbLogin()".

 

Problem Statement : If our connection remains idle for more than 15 minutes, then the connection drops by IPVS setting in k8s kube-proxy.

 

Query : Is there any way we can provide values of "keepalives_idle, keepalives_interval, keepalives_count" client parameters in the API "PQsetdbLogin()" while creating the connection.

        If yes, then can someone please provide the sample code for the same.

                             We need these parameters support at client side only.

“

 

Is there any other alternative approach using some configuration files from client side?

 

Thanks,

Tarkeshwar

pgsql-general by date:

Previous
From: Frank Lanitz
Date:
Subject: pgBadger: Cannot find any log entries from systemd-journald
Next
From: M Tarkeshwar Rao
Date:
Subject: Recall: Connection remains idle for more than 15 minutes, then the connection drops by IPVS setting in k8s kube-proxy