Solution to PostgreSQL Connection refused Is the server running on host Error

If you are having trouble connecting to the database while using the PostgreSQL service, you need to change the listened addresses in the settings file below.

nano /etc/postgresql/10/main/postgresql.conf
listen_addresses = '*'

Then we restart with the following command.

service postgresql restart