I cannot find a way to connect to my Azure Postgres database to run SQL

Question

I cannot find a way to connect to my Azure Postgres database to run SQL

Asher Gilmour 0

I used the quickstart to create a database (Postgres) and application server. However I cannot find a way to connect to the database to run SQL.
I can't even create a vm client

Mahesh Kurva 6,850 Reputation points Microsoft External Staff Moderator

2025-06-20T10:27:32.3866667+00:00

Hi Asher Gilmour,

Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

1 answer

Your answer

Mahesh Kurva 6,850 Reputation points Microsoft External Staff Moderator

2025-06-20T10:27:32.3866667+00:00

Hi Asher Gilmour,

Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 1

Mahesh Kurva 6,850 Microsoft External Staff Moderator

Hi Asher Gilmour,

Greetings!!

It looks like you're trying to connect to your Azure PostgreSQL database using Azure Data Studio.

Here's a step-by-step checklist to help you connect and run SQL on your Azure PostgreSQL database:

You need Azure Data Studio, the PostgreSQL extension for Azure Data Studio, and access to a PostgreSQL server.

Install Azure Data Studio.
Install the PostgreSQL extension for Azure Data Studio.
Install PostgreSQL. (Alternatively, you can create a Postgres database in the cloud using az postgres up).

Connect to PostgreSQL:

Start Azure Data Studio.
The first time you start Azure Data Studio the Connection dialog opens. If the Connection dialog doesn't open, select the New Connection icon in the SERVERS page.
In the form that pops up, go to Connection type and select PostgreSQL from the drop-down.
Fill in the remaining fields using the server name, username, and password for your PostgreSQL server.
Select Connect.

Once connected, you can open a new query window and start running SQL commands.

For more information, please refer the document: https://learn.microsoft.com/en-us/azure-data-studio/quickstart-postgres?source=recommendations

Hope this helps. Do let us know if you any further queries.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Asher Gilmour 0 Reputation points

2025-06-18T14:06:28.76+00:00

It seems that the database is on a private network on Azure.
Even using the cloud shell, I get "could not translate host name"
Mahesh Kurva 6,850 Reputation points Microsoft External Staff Moderator

2025-06-19T04:55:54.8766667+00:00
Hi Asher Gilmour,

It seems that the database is on a private network on Azure. Even using the cloud shell, I get "could not translate host name"

If it's in private access mode, you cannot connect from your local machine or Azure Cloud Shell directly unless you're inside the same virtual network.

1.Check Resource Group and VNet Permissions

Ensure your user account has Contributor or higher permissions on the Resource Group and Virtual Network where the database is deployed.

If you're restricted by RBAC (Role-Based Access Control), you may need help from your Azure admin to grant access.

2.Verify VNet Integration

Go to the PostgreSQL Flexible Server in the Azure Portal.

Under Networking, confirm it's deployed in a VNet.

Note the subnet name and VNet name,you’ll need these to create a VM in the same network.

3.Create VM in Same VNet,if you have access:

Go to Virtual Machines > Create.

In the Networking tab, choose the same VNet and subnet as your database.

Select a basic image (e.g., Ubuntu or Windows).

After creation, install psql or Azure Data Studio.

4.Use Azure Bastion (No Public IP Needed)

If VM creation is blocked or public IPs are restricted:

Set up Azure Bastion in the same VNet.

Bastion allows browser-based SSH/RDP access to VMs without public IPs.

You can then connect to the database from inside the private network.

5.Ask Admin for a Jumpbox or Bastion Setup

If you're blocked from creating resources:

Ask your Azure admin to create a jumpbox VM or enable Azure Bastion.

Once that’s available, you can connect securely to the database.

I hope this information helps. Please do let us know if you have any further queries.
Mahesh Kurva 6,850 Reputation points Microsoft External Staff Moderator

2025-06-23T04:09:16.4033333+00:00

Hi Asher Gilmour,

Following up to see if the above answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Share via

I cannot find a way to connect to my Azure Postgres database to run SQL

1 answer

Your answer