Make PG accessible from outside in Debian/Ubuntu

gistfile1.txt

# /etc/postgresql/9.4/main/postgresql.conf

#---------------------------------------------------------
# CONNECTIONS AND AUTHENTICATION
#---------------------------------------------------------

# - Connection Settings -

listen_addresses = '*'  # Postgres, pretty please keep your ears open on everything. 


Allow remote connections to actually reach your PostgreSQL instance.

Next we're going to edit our pg_hba.conf file and configure it to allow remote connections. At the very end of the file, add the following line:

# /etc/postgresql/9.4/main/pg_hba.conf

host all all  0.0.0.0/0 md5

Restart:
sudo service postgresql restart
or
sudo /etc/init.d/postgres restart