Hi! Some users of our database have a NAT firewall and keep a postgres client (e.g. pgAdmin ) open for hours. To prevent the connection from being killed by the firewall due to inactivity, we configured tcp_keepalives_idle = 120 so that the server sends keepalives and keeps the connection active. (this is on debian)
We've recently upgraded from postgres 9.3 to 13 and from debian 6 to 11. I'm getting the complaint that since the upgrade, the connection breaks. But only when they run a long query. Has anything changed in postgres that might cause this? e.g. that keepalives are only sent when the session is idle? Thanks -- Willy-Bas Loos
