From: PG Doc comments form <noreply@postgresql.org>
To: pgsql-docs@lists.postgresql.org
Cc: hirnstrom@arcor.de
Subject: documentation issue: listen_addresses does NOT take a comma-separated list of host names
Date: Sun, 03 Mar 2024 19:24:20 +0000
Message-ID: <170949386083.644.3898742260684710908@wrigleys.postgresql.org> (raw)
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/14/runtime-config-connection.html
Description:
In the documentation, I read:
<quote>
20.3.1. Connection Settings
listen_addresses (string)
Specifies the TCP/IP address(es) on which the server is to listen for
connections from client applications. The value takes the form of a
comma-separated list of host names and/or numeric IP addresses. (...)
</quote>
I tried different versions of names and IPs, quoted in single, double and no
quotes at all, comma separated between quotes and inside, like
<quote>
listen_addresses = '192.168.32.3','127.0.0.1'
# or
listen_addresses = '192.168.32.3,127.0.0.1'
</quote>
but `sudo journalctl -eb -u postgresql@14-main.service -o cat`
gives me:
<quote>
Reloading PostgreSQL Cluster 14-main...
Error: invalid line 61 in /etc/postgresql/14/main/postgresql.conf:
listen_addresses = "192.168.32.3","127.0.0.1"
postgresql@14-main.service: Control process exited, code=exited,
status=1/FAILURE
Reload failed for PostgreSQL Cluster 14-main.
Reloading PostgreSQL Cluster 14-main...
Error: invalid line 61 in /etc/postgresql/14/main/postgresql.conf:
listen_addresses = "192.168.32.3,127.0.0.1"
postgresql@14-main.service: Control process exited, code=exited,
status=1/FAILURE
Reload failed for PostgreSQL Cluster 14-main.
Reloading PostgreSQL Cluster 14-main...
Error: invalid line 61 in /etc/postgresql/14/main/postgresql.conf:
listen_addresses = '192.168.32.3','127.0.0.1'
postgresql@14-main.service: Control process exited, code=exited,
status=1/FAILURE
Reload failed for PostgreSQL Cluster 14-main.
</quote>
So I tried to follow the otherwise seen pattern and wrote into
postgresql.conf:
<quote>
listen_addresses = '192.168.32.3'
listen_addresses = '127.0.0.1'
</quote>
which worked.
Note, that in the file itself, the comment repeats the (imho)
misinformation.
<quote>
#listen_addresses = 'localhost' # what IP address(es) to listen on;
# comma-separated list of addresses;
</quote>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: noreply@postgresql.org, pgsql-docs@lists.postgresql.org, hirnstrom@arcor.de
Subject: Re: documentation issue: listen_addresses does NOT take a comma-separated list of host names
In-Reply-To: <170949386083.644.3898742260684710908@wrigleys.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox