How to connect with pgAdmin to Azure Database for PostgreSQL flexbile server

Eelco 85

I've got my Django app up and running with a PostgreSQL flexible server. The Network connectivity is set to Private access (VNet Integration), which I cannot change.

Now I would like to connect with pgAdmin to my database, but it seems to me that the only way is to install a Virtual Private Network and a Gateway. Isn't there another way? Or do I have to create a new database with Public access allowed and switch to that database?

Eelco 85 Reputation points

2023-10-06T11:20:50.62+00:00

Thanks for pointing me to that page. I had seen it before, but overlooked the option to use the SSH tunnel. It's working :-)
ShaktiSingh-MSFT 13,826 Reputation points Microsoft Employee

2023-10-09T04:14:01.6633333+00:00

Hi
Eelco •,

Following up to see if the below suggestion was helpful. If this answers your query, do click Accept Answer and Mark Helpful for the same. And, if you have any further query do let us know. Thanks
Moussavou Boussougou Milandu Keith 15 Reputation points

2023-11-22T13:06:29.43+00:00

Hello Eelco. Thank you for this question, as I am currently facing the same issue. In my case, I have created an App Service+database, and the database is a PostgreSQL flexible server under a private network. I am wondering if the solution provided by ShaktiSingh-MSFT will also work considering my setting. I will try out and add a comment afterward.

Thank you for the proposed solution ShaktiSingh-MSFT.
Moussavou Boussougou Milandu Keith 15 Reputation points

2023-11-22T18:12:58.47+00:00
I did some additional research and found out how to connect pgAdmin to my PostgreSQL flexible server and access my database. If you're facing the same issue, follow these steps once you've set up your App Service+Database:

Install Azure CLI

Login to Azure CLI from cmd

Type in the cmd prompt az login. This will lead you to the Microsoft login page for authentication

Once authenticated and logged into Azure CLI, create a remote-connection

Type az webapp create-remote-connection --subscription <subscription-id> --resource-group <resource-group-name> -n <app-name>

Keep the Opening tunnel on addr and Opening tunnel on port detail to connect in pgAdmin

Create a new server in pgAdmin

In the Connection tab, enter your PostgreSQL flexible server details (hostname, port, db name, username, password)

In the parameters tab, set the value of the parameter SSL mode to required

In the SSH Tunnel tab, enter the details from set 3.a

Click the button Save

Hoping that this would be helpful.

I hope this helps you connect to your PostgreSQL flexible server and access your database easily.
Eelco 85 Reputation points

2024-02-16T16:25:10.27+00:00

@Moussavou Boussougou Milandu Keith Thanks for this. Works like a charm. Easier than through the Virtual Machine.
Moussavou Boussougou Milandu Keith 15 Reputation points

2024-02-27T03:40:46.9166667+00:00

You are welcome, Eelco.

Accepted answer

ShaktiSingh-MSFT 13,826 Reputation points Microsoft Employee

2023-10-06T06:16:21.1166667+00:00

Hi
Eelco •,

Welcome to Microsoft Q&A forum and thanks for using Azure Services.

As I understand, you want to connect with pgAdmin to Azure Database for PostgreSQL Flexible Server.

Since the server is in a virtual network, you can only connect to the server from other Azure services in the same virtual network as the server. To connect and manage the server, let's create a Linux virtual machine. The virtual machine must be created in the same region and same subscription. The Linux virtual machine can be used as an SSH tunnel to manage your database server.

Refer the documentation here for complete details: Create an Azure Linux Virtual Machine.

Hope this helps. Let us know if you have a different ask.

Thanks
Please sign in to rate this answer.

2 people found this answer helpful.
Eelco 85 Reputation points

2023-10-09T14:40:06.0666667+00:00

Thanks, this helped. The page is a bit outdated, there are much more options now, but nothing to complicated. What helped me most was your comment: "The Linux virtual machine can be used as an SSH tunnel to manage your database server." In pgAdmin you can register the ssh tunneling, so this was the perfect solution for me.
Sign in to comment

How to connect with pgAdmin to Azure Database for PostgreSQL flexbile server

0 additional answers