I'm trying to remotely connect to my postgresql database. I have two virtual machines set up both running ubuntu 14.04. I am trying to connect to the second vm using the first vm using

psql -h -U postgres -d postgres

But I receive the error:

Could not connect to server: Connection refused
    Is the server running on host "" and accepting
    TCP/IP connections on port 5432?

I have changed the pg_hba.conf and added

host all all md5
host all all * md5
host all all md5

And changed the postgresql.conf listen_address=" * "

In an attempt to allow all incoming connections. I have also tried to change the firewall settings, but I am unsure of whether or not the ports are properly listening for the connection.

Edit: Output of

netstat -an | grep -E '^tcp[^6].*LISTEN'
tcp   0   0*    LISTEN
tcp   0   0*    LISTEN
tcp   0   0*    LISTEN
tcp   0   0*    LISTEN
tcp   0   0*    LISTEN
  • Please edit your question to include the output of running netstat -an | grep -E '^tcp[^6].*LISTEN' while PostgreSQL is up and running.
    – user
    Aug 19, 2014 at 20:43
  • Server is not listening on, only on loopback device ( But it's late and my brain just stopped.
    – rsm
    Aug 19, 2014 at 21:10
  • So how would I be able to change what the server is listening to?
    – Jonathan
    Aug 19, 2014 at 21:26

3 Answers 3


Apparently I had forgotten to remove the # from listen_address="*". It was a comment the entire time. I am dumb.

  • 1
    It's alright. Honest mistake. We've all done it. :) Aug 19, 2014 at 21:50
  • I change configuration for 100 times, restart PG for 100 times and find this :) Jul 24, 2016 at 16:41
  • I have worked as a programmer for over 10 years, and today I spent several hours debugging before this answer helped me. Aug 12, 2019 at 20:35

Ensure that the postgresql.conf file has an entry forlisten_addresses='*'. It looks like you are using the wrong configuration parameter name, and might have a space surrounding the asterisk.

Lastly, ensure you restart postgres after making these changes.


Do following

Update : /var/lib/pgsql/<version>/data/postgresql.conf

change : #listen_addresses = 'localhost' to listen_addresses = '*'

restart service

You must log in to answer this question.

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