Enabling PostgreSQL Remote Access - PostgreSQL connection only works from local machine
If the PostgreSQL connection is only working locally, make sure
the PostgreSQL instance is configured to allow remote connections.
This involves modifying the pg_hba.conf file by adding information about the remote ip addresses / hosts that you want to allow to connect remotely.
Here is an example of how to add specific ip addresses to the pg_hba.conf file.
host all all 127.0.0.1/32 md5
host all all 192.168.2.2/32 md5
Also make sure that TCP/IP networking is enabled for your PostgreSQL instance by modifying the postgresql.conf file.
For this, you would want to make sure the listen_addresses line is pointing to a specific ip address or * instead of localhost. For example,