I'm running docker swarm with several container\services, on of them is Postgres version 14.
I want to validate which DB connection is related to which service (by service's hostname).
There is the the table pg_stat_activity with the column client_hostname but it null, although I set log_hostname in the postgres conf to on or 1 (of course I restart the container).
Any idea why and how can I saw this value?
Thanks!