El día martes, marzo 05, 2024 a las 11:08:27 +0000, M Tarkeshwar Rao escribió:
> Hi all,
>
> "
> 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?
An option could be to run the connection through an SSH tunnel and use
there the sshd(8) config parameter ClientAliveInterval.
HIH
matthias
--
Matthias Apitz, ✉ g...@unixarea.de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub
I am not at war with Russia. Я не воюю с Россией.
Ich bin nicht im Krieg mit Russland.
