How to connect to Postgre server from local network?

Question

PostgreSQL

This error occurs when connecting to the server.

The server is running on my local machine, the connection comes from another user on the local network. There is a ping. Everything was working yesterday. There were no changes.
What could be the problem?

Answer 1

netstat -tnlp
if
127.0.0.1:5432
then you need to change the setting listen_addresses = 'localhost' to listen_addresses = '*' in
/var/lib/postgres/
postgresql.conf and restart postgres also look pg_hba.conf set host all all 0.0. 0.0/0 password password can be set like this psql -U postgres -c "ALTER USER postgres PASSWORD 'PASSWORD'"

Answer 2

Check pg_hba.conf for available connections