listening on an address other than 'localhost'?
| От | Johnson, Bruce E - (bjohnson) |
|---|---|
| Тема | listening on an address other than 'localhost'? |
| Дата | |
| Msg-id | FEB5A474-B2D2-42B7-8D5D-FEF3B4564306@email.arizona.edu обсуждение исходный текст |
| Ответы |
Re: listening on an address other than 'localhost'?
Re: listening on an address other than 'localhost'? Re: listening on an address other than 'localhost'? |
| Список | pgsql-general |
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
That line is commented out in the default conf file, when I uncomment it, and add the address, then do sudo systemctl restart postgresql the postgres processes are not running afterwards.
root@dhbpostgres:/home/johnson# ps -aux | grep postgres
root 1452 0.0 0.0 6608 2364 pts/1 S+ 19:07 0:00 grep --color=auto postgres
root@dhbpostgres:/home/johnson# vi /etc/postgresql/15/main/postgresql.conf <<commented out listen_addresses
root@dhbpostgres:/home/johnson# systemctl restart postgresql
root@dhbpostgres:/home/johnson# ps -aux | grep postgres
postgres 1461 0.2 0.1 219220 30568 ? Ss 19:08 0:00 /usr/lib/postgresql/15/bin/postgres -D /opt/data/pgdata -c config_file=/etc/postgresql/15/main/postgresql.conf
postgres 1462 0.0 0.0 219352 7028 ? Ss 19:08 0:00 postgres: 15/main: checkpointer
postgres 1463 0.0 0.0 219220 7024 ? Ss 19:08 0:00 postgres: 15/main: background writer
postgres 1465 0.0 0.0 219220 7032 ? Ss 19:08 0:00 postgres: 15/main: walwriter
postgres 1466 0.0 0.0 220816 9508 ? Ss 19:08 0:00 postgres: 15/main: autovacuum launcher
postgres 1467 0.0 0.0 220792 9444 ? Ss 19:08 0:00 postgres: 15/main: logical replication launcher
root 1480 0.0 0.0 6608 2276 pts/1 S+ 19:08 0:00 grep --color=auto postgres
If I comment that line out as it was in the beginning, and restart, it runs.
the syslog gives me the error
Sep 6 19:06:01 dhbpostgres postgresql@15-main[1538]: 2023-09-06 19:06:01.181 GMT [1543] LOG: syntax error in file "/etc/postgresql/15/main/postgresql.conf" line 63, near token ".206"
which corresponds to the listen_addresses line in the config file and is part of the address…
#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 apt repo.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
В списке pgsql-general по дате отправления: