Search code examples
postgresqlazurepgadminpgadmin-4

Timeout expired: Connecting Azure Postgres using local pdAmin

I am using psql on Azure. While I am successfully able to connect it on CLI and using Python psycopg2 or other modules and library, I am facing issue connecting it to the pgadmin Web UI.

The process to connect to the Azure POSTGRES in pgadmin is as follows:

  1. Click on Add New Server.
  2. Provide Name under General tab.
  3. Provide Host, Port, DB Name, Username, Password.

After clicking on Save, it always pops connection timeout error.

While with the above config I can connect to it in the python, create cursor and commit a query. Do we require additional settings to be done for connecting it to the pgadmin. I am new to cloud and not sure if there is some additional security checks like token access to be provided or something.

Solution

  • Please have a check that have you enabled your local public IP address in Postgres DB Firewall rules? enter image description here After I created the new DB and added my local public IP to Firewall rules, I can connect to DB by local pgAdmin successfully:

    enter image description here Configs: enter image description here enter image description here