1

I have followed everything I can find online about how to do this, and as far as I can tell everything is correct- but it's not working.

I have a Linux 12.04 server running Postgres 9.1. I can SSH into the server and work with Postgres perfectly from there, connected via local connection.

When I tried to set up Postgres for remote access however I cannot get it to work. I have made the following changes: (All listed files are in /etc/postgresql/9.1/main)

  1. In /environment, I've added PGOPTIONS='-i'
  2. In /pg_hba.conf, I've added host all all 0.0.0.0/0 md5
  3. In /postgresql.conf, I've changed listen_addresses='*'
  4. I've checked the firewall, it was default config but opened postgres port just in case
  5. Netstat -a shows tcp 0 0 localhost:5432 *:* LISTEN
  6. I've made sure my postgres user password and name is correct, and can connect locally with that user
  7. I've tried restarting (services postgresql restart) and start/stop.

And yet, still, I can't connect remotely at all. I get the following error: 

$ psql -h [server address] -U [username] -d [database name] psql: could
not connect to server: Connection refused   Is the server running on
host "[server address]" ([ip address]) and accepting    TCP/IP
connections on port 5432?

Any ideas?

Improve this question
1
  • Ah, I thought that meant it was listening /on/ localhost, not /to/ localhost- my bad. Anyway, I stopped the service, checked all my files, restarted my server, and then started the service again, and now it works perfectly. If you add your comment as an answer I'll accept.
    – jssblck
    Jan 27, 2014 at 4:51

1 Answer 1

Reset to default
0

Are you SURE you restarted postgresql after this? The configuration is correct, but it's still bound only to localhost.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .