up vote 0 down vote favorite
share [g+] share [fb]

I have installed a new server with Postgresql 9. It works fine locally. When I try to access it remotely using pgAdmin III I get the following error:

Server doesn’t listen

The server doesn’t accept connections: the connection library reports Could not connect to server: connection refused (0x0000274D/10061) Is server running on host 192.168.x.x and accepting TCP/IP connections on Port 5432?

Before I get the pat answers, yes “listen_address” is equal to ’*’ This Postgresql database in on Fedora 14 Linux and I’ve disabled SELinux, and open port 5432 on the Firewall. I’ve also edited pg_hba.conf and add the proper hosts.

I’ve been using Postgresql 8 for a while and never had this kind of problem before. There seem to be a lot of people having the same problem. All help is greatly appreciated.

link|improve this question
Is it behind a router? If so, you need to set up port forwarding on it for port 5432. – WTP Sep 12 '11 at 5:20
Maybe something in the local firewall of the the client preventing outgoing connections? – a_horse_with_no_name Sep 12 '11 at 6:35
Have you got terminal access on the pgadmin computer? If so then what happens if you run: telnet 192.168.x.x 5432 – ed. Sep 14 '11 at 13:54
feedback

migrated from stackoverflow.com Sep 12 '11 at 8:09

This question came from our site for professional and enthusiast programmers.

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown
discard