search

pgpool / pgpool2

This is the official mirror of git://git.postgresql.org/git/pgpool2.git. Note that this is just a *mirror* - we don't work with pull requests on github. Please subscribe to pgpool-hackers mailing list from our website and submit your patch to this mailing list.
https://www.pgpool.net
Other
322 stars 87 forks source link

pg's tcp_keepalives_idle is not transport to client #57

Closed NiuBlibing closed 1 week ago

NiuBlibing commented 2 months ago

tcp_keepalives_idle seems not work between pgpool and pg client which is very useful for k8s environments.

pengbo0328 commented 1 month ago

@NiuBlibing

tcp_keepalives_idle seems not work between pgpool and pg client which is very useful for k8s environments.

If you are using pgpool, pgpool is the client of PostgreSQL. The connection between pgpool and PostgreSQL will be maintained even if the client is disconnected. It is the feature of connection pooling.

We have a similar feature in pgpool to close the idle connection using client_idle_limit.

https://www.pgpool.net/docs/latest/en/html/runtime-config-connection-pooling.html#GUC-CLIENT-IDLE-LIMIT

Specifies the time in seconds to disconnect a client if it remains idle since the last query. This is useful for preventing the Pgpool-II children from being occupied by a lazy clients or broken TCP/IP connection between client and Pgpool-II.

But I'm not sure if this is the feature you want. May I ask your usecase which require this feature?

pengbo0328 commented 1 week ago

@NiuBlibing May I close this issue?

NiuBlibing commented 1 week ago

Thank you.