I have a firewall between Gitlab frontends and Postgres.
The firewall has a rule, that I can not modify, to drop packages if a connection is not used during 1 hour. For example, connections to Postgres do not submmit queries during 1 hour.
Monitoring the database log, I saw a heart beat command “select 1” every 30 min.
But, as Sidekiq uses the database pool of connections, this heart beat command only uses one of the connections. Other pool connections does not have a heart beat and is droped by the firewall.
I would like to have a heart beat command on every pool connection. Is it possible to setup it?