V
V
Vitaly2018-12-06 20:27:54
PostgreSQL
Vitaly, 2018-12-06 20:27:54

Why does the config rule for remote access to the postgres database not work?

All the best!
Faced with the problem of setting up remote access to the database. I got the problem after reinstalling the database (I played with versions, now the version is for working with 1c)
In the file /etc/postgresql/9.6/main/postgresql.conf I commented out the line:
listen_addresses = '*'
In the file /etc/postgresql/9.6/main/pg_hba.conf at the end :

host all all RANGE_OFF_IPS.0/24 md5
host all all ONE_ALLOWED_IP/32 md5

With these settings, the connection goes through from any IP addresses. What's wrong ?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Ainur Valiev, 2018-12-08
@vaajnur

That's how it works. You have granted access to all of them.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question