Other computers are having trouble even finding the running Postgresql 9.1 on my Windows 7 machine. Local connections work just fine of course.
In my pg_hba.conf I have:
#office subnets host all all 192.168.##.0/24 md5 host all all 192.168.##.0/24 md5
In postgresql.conf I have (Yes, port 5433 is intentional):
listen_addresses = '*' # what IP address(es) to listen on; # comma-separated list of addresses; # defaults to 'localhost', '*' = all # (change requires restart) port = 5433 # (change requires restart)
netstat -a -b in the cmd I find:
Can not obtain ownership information TCP 0.0.0.0:5433 XXXXX-PC:0 LISTENING
Heck, I even made a firewall exception:
Protocols and Ports: Local port: Specific Ports, 5433 Remote port: All Ports Scope: Any IP Address Advanced: Profiles: Private, Public Programs and Services: Apply to this service: postgresql-x64-9.1
The typical response from pgAdmin is always the dreaded:
Server doesn't listen could not connect to server: Connection timed out (0x0000274C/10060) Is the server running on host "...." and accepting TCP/IP connections on port 5433?