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. Commented 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.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.