Re: im having trouble connecting to my postgresql server remotely
A bit late to answer this question but I see it's still open, so here you go:
Your postgresql.conf looks fine, it has:
listen_addresses = '*'
port = 5432
The problem is your host based authentication file pg_hba.conf. Until now you are only allowing connections from local host. Let's say your database is named: alfrescodb, and your user is alfresco. And imagine you are connecting from 10.9.0.42, then, you need to add the following line:
host alfrescodb alfresco 10.9.0.42/32 md5
And remove this line at the end:
host all all 127.0.0.1/32 password
Avoid using the 'password' method, as it sends the password on plain text.