How do I open postgres access?
in the postgresql.conf file I put in to accept
* connections, but I still can not connect to the database without going through the tunnel of the PUTTY connection. I need this access to the database to be released, how can I do it?
You'll want to ensure that PostgreSQL is listening on your public interface by setting
listen_addresses = '*' in the postgresql.conf file. You can also use
sudo netstat -plntu to show you what services are listening on which interface.
Additionally, you'll need to have your local IP address (or a range of addresses) set to allow access to which databases and logins you wish to use in the pg_hba.conf file. I strongly reccommend that you read through the security documentation for PostgreSQL before changing anything, but an example line allowing logins to any user/database with a password from the IP address
22.214.171.124 would be
host all all 126.96.36.199 password.
Lastly, you'll also want to ensure that you do not have any iptables/ufw rules blocking the port that PostgreSQL is listening on (default is 5432). You may find the guides on iptables and ufw helpful here.