postgresql: connection refused

Edit:

/etc/postgresql/10/main/postgresql.conf

Change:

listen_addresses = '*'

Additionally add the IP pg_hba.conf

host    all         all         192.168.1.0/24        md5

ricardo malla's blog