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.