Can we make a connection to the azure postgres DB from outside of Azure network

Question

Can we make a connection to the azure postgres DB from outside of Azure network

Sandeep Kumar Sharma 20

We are using postgreSQL DB and would like to connect to it from our PC directly instead of jumping onto the Azure bastion and then Azure VM to make connection to the DB inorder to run any query.

Is it possible to do connect using DB visualizer ? is there a tutorial to do the same anywhere ?

Answer accepted by question author

0 additional answers

Your answer

Answer 1

GeethaThatipatri-MSFT 29,587 Microsoft Employee Moderator

Hi @Sandeep Kumar Sharma Welcome to Microsoft Q&A thanks for posting your question

Yes, it is possible to connect to an Azure PostgreSQL server from outside of the Azure network. You can use the PostgreSQL Instance endpoint to connect to the PostgreSQL server from your favorite tool such as DB visualizer, Azure Data Studio, pgcli, psql, pgAdmin, etc.

Steps you can follow from PGAdmin

User's image

Regards

Geetha

Sandeep Kumar Sharma 20 Reputation points

2023-12-04T22:13:29.3366667+00:00

Hi Geetha,

Thanks for answering my question.

We are using PostgreSQL Single Server. Does pgAdmin 4 work for single server as well ?
I just tried and it failed with connection timeout expired.

Thanks

Sandeep
Sandeep Kumar Sharma 20 Reputation points

2023-12-04T22:44:24.53+00:00

I think i figured out, the problem is we need to add our IP range to be allowed to connect to the DB to make it. Thanks again for answering. Have a great day.

Share via

Can we make a connection to the azure postgres DB from outside of Azure network

0 additional answers

Your answer