Re: listening on an address other than 'localhost'?

On 9/6/23 12:23, Johnson, Bruce E - (bjohnson) wrote:
> per the documentation to listen for client connections on a given IP 
> address you set listen_addresses to a commaspearated list of IP 
> addresses in postgresql.conf
> 

> #listen_addresses = 10.128.206.109# what IP address(es) to listen on;
> # comma-separated list of addresses;
> # defaults to 'localhost'; use '*' for all
> # (change requires restart)
> 
> 
> What am I missing? (postgresql 15.4 running on Ubuntu 22.04), installed 
> via postgresql.org <http://postgresql.org> apt repo.


The other replies have indicated how you should format the value. For 
future reference the postgresql.conf configuration docs:

https://www.postgresql.org/docs/current/runtime-config.html

tell you what is expected. In this case:

https://www.postgresql.org/docs/current/runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS

listen_addresses (string)

vs

port (integer)


> 
> 
> -- 
> Bruce Johnson
> University of Arizona
> College of Pharmacy
> Information Technology Group
> 
> Institutions do not have opinions, merely customs
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com