Re: listening on an address other than 'localhost'? - Mailing list pgsql-general

From Adrian Klaver
Subject Re: listening on an address other than 'localhost'?
Date
Msg-id f0313896-4789-b6a1-5e59-b18eeee2984b@aklaver.com
Whole thread Raw
In response to listening on an address other than 'localhost'?  ("Johnson, Bruce E - (bjohnson)" <Johnson@pharmacy.arizona.edu>)
List pgsql-general
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




pgsql-general by date:

Previous
From: "Arulraj, Joy"
Date:
Subject: Feedback on supporting AI queries in Postgres with EvaDB
Next
From: Stephen Frost
Date:
Subject: Re: Will PostgreSQL 16 supports native transparent data encryption ?