I want to query a database stored in an external location. Up to now, I was using Microsoft Access for querying, but due to limitation of 2 GB output file, I am trying to switch to another DBMS, PostgreSQL.

How do I connect to the external database using pgAdmin, installed on my machine?


The short answer is choose Add server from the file menu and enter the details of the server. However there are many reason's why it may not work. I'll itemize the most common problems:

  • postgresl isn't listening
  • postgresl's pg_hba.conf doesn't allow access from outside
  • the server's firewall is blocking access
  • a router is blocking access

If you run into problems, update your question and please include any error messages you get.

BTW When opening up access to postgres from the outside you may want to enforce the use of SSL.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.