Re: Resolving host to IP address - Mailing list pgsql-general

From Sebastien Flaesch
Subject Re: Resolving host to IP address
Date
Msg-id DBAP191MB12890A6FA5548EA02B35565CB0449@DBAP191MB1289.EURP191.PROD.OUTLOOK.COM
Whole thread Raw
In response to Re: Resolving host to IP address  (Francisco Olarte <folarte@peoplecall.com>)
Responses Re: Resolving host to IP address
List pgsql-general
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

pgsql-general by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Support for dates before 4713 BC
Next
From: Tom Lane
Date:
Subject: Re: Support for dates before 4713 BC