Sample Header Ad - 728x90

Why listen_addresses not changing in PostgreSQL?

1 vote
1 answer
132 views
I'm trying to ENABLE remote client access on my PostgreSQL 12 database (Ubuntu 20.04 LTS). I've changed **
.conf
** on both paths ***/var/lib/postgresql/12/main*** and ***/etc/postgresql/12/main*** this way: listen_addresses = '*' Of course also add my ip in **
.conf
** I've also tried: root@localhost:/# sudo -u postgres psql psql (12.20 (Ubuntu 12.20-0ubuntu0.20.04.1)) Type "help" for help. postgres=# ALTER SYSTEM SET LISTEN_ADDRESSES='*'; ALTER SYSTEM And after many restarts (of postgreSQL and even whole vnc) anyway I'm getting this: root@localhost:/# sudo -u postgres psql -c 'SHOW listen_addresses;' listen_addresses ------------------ localhost (1 row) And **pgAdmin 4** on my PC also tell me: > Unable to connect to server: connection timeout expired I even tried to reinstall postgreSQL - no effect 😭 Why so? What is wrong? Colleagues, please give me an advice how to solve this problem? **UPD:** Also tried with inactive firewall - no effect...
Asked by Aeverandi (11 rep)
Oct 3, 2024, 02:13 PM
Last activity: Dec 2, 2024, 01:48 PM