Azure Data Studio with PostgreSQL connection type cannot connect to server

Ludovic Arnould 0 Reputation points
2024-06-28T14:33:01.2333333+00:00

Hello,

I'm currently trying to connect to a server via a PostgreSQL connection on Azure Data Studio. I installed the app from the official webpage and then added the PostgreSQL extension via the app extensions interface.

I have copied a configuration that allows my fellow workers to connect properly but it does not work for me: the loading spinner keeps spinning. However, according to the logs (shown below) the connection is successfully added. Rebooting the app and my laptop did not help.

I'm using Ubuntu 22.04 and all my packages are up to date.

The output of the renderer.log file, all log files being almost empty:


2024-06-28 16:13:03.521 [info] Creating new connection connection:providerName:PGSQL|applicationName:azdata|authenticationType:SqlLogin|dbname:postgres|host:----.postgres.database.azure.com|hostaddr:|port:|user:----|databaseDisplayName:postgres|group:----

2024-06-28 16:13:03.521 [info] Adding connection connection:providerName:PGSQL|applicationName:azdata|authenticationType:SqlLogin|dbname:postgres|host:----.postgres.database.azure.com|hostaddr:|port:|user:----|databaseDisplayName:postgres|group:----

2024-06-28 16:13:03.523 [info] Successfully added connection connection:providerName:PGSQL|applicationName:azdata|authenticationType:SqlLogin|dbname:postgres|host:----.postgres.database.azure.com|hostaddr:|port:|user:----|databaseDisplayName:postgres|group:----

My Azure Data Studio specs:

Version: 1.48.1

Commit: 8825ec21e67a34ede00e4f02a4afc692eb6cab61

Date: 2024-06-13T21:05:13.651Z

VS Code: 1.82.0

Electron: 25.9.8

Chromium: 114.0.5735.289

Node.js: 18.15.0

V8: 11.4.183.29-electron.0

OS: Linux x64 6.5.0-41-generic

Thank you in advance for your help. Please ask me for any information that could help solve this issue.

Azure Database for PostgreSQL
Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
106 questions
{count} votes