I want to add a server in postgrey. This server is a Windows machine. But it is not allowing me to add that server. I think it is not able to access that machine. When I tries to access the webpage hosted on that machine, then too it does not allow me to do so. What can be done to connect to Windows server from a Mac machine??
migrated from stackoverflow.com Dec 20 '11 at 21:01
This question came from our site for professional and enthusiast programmers.
Check whether Firewall is blocking the external access to the Windows server for the specific port which runs the Postgre server.
You can telnet to the relevant port(most probably 5432) to check whether that port is opened to access from your machine.
If there is a firewall running on the Windows server, you should contact the server administrator to modified the rules for allowing the access to the postgre app.
Or may be database user you are using doesn't have permission to access the server from your local machine.