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
Last activity: Dec 2, 2024, 01:48 PM