Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

share|improve this question
    
Is it behind a router? If so, you need to set up port forwarding on it for port 5432. –  rightfold 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
add comment

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

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.