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.
118 questions
{count} votes

1 answer

Sort by: Most helpful
  1. GeethaThatipatri-MSFT 29,477 Reputation points Microsoft Employee
    2024-06-28T19:27:51.9633333+00:00

    @Ludovic Arnould Welcome to Microsoft Q&A thanks for posting your question.

    Can you share the screenshot from ADS configuration. also, I would suggest restarting ADS and try again.

    To troubleshoot further can you try with PGAdmin tool and see if you are able to connect.

    Regards

    Geetha

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.