Thank you all for your comments.

I think I got it: PostgreSQL should listen to the real, non-loopback network 
interface.

Just for info (local dev config, not prod):

sf@toro:/opt3/dbs/pgs/14.1-openssl/data$ grep listen_addresses postgresql.conf

listen_addresses = 'localhost,toro.strasbourg.4js.com'


sf@toro:/opt3/dbs/pgs/14.1-openssl/data$ netstat -tl -W | grep 5437
tcp        0      0 localhost:5437          0.0.0.0:*               LISTEN
tcp        0      0 toro.strasbourg.4js.com:5437 0.0.0.0:*               LISTEN
tcp6       0      0 localhost:5437          [::]:*                  LISTEN


sf@toro:/opt3/dbs/pgs/14.1-openssl/data$ netstat -tl -W --numeric-hosts | grep 
5437
tcp        0      0 127.0.0.1:5437          0.0.0.0:*               LISTEN
tcp        0      0 127.0.1.1:5437          0.0.0.0:*               LISTEN
tcp6       0      0 ::1:5437                :::*                    LISTEN


sf@toro:/opt3/dbs/pgs/14.1-openssl/data$ ip route get 127.0.1.1
local 127.0.1.1 dev lo src 127.0.0.1 uid 1000
    cache <local>


Seb

Reply via email to