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(dot)klaver(at)aklaver(dot)com