Extension issue - Failed to start PGSQL tools service on Ubuntu

[bmuriithi1]

• Issue Type: Bug
• Extension Name: azuredatastudio-postgresql
• Extension Version: 0.3.1
• OS Version: Linux x64 5.19.0-35-generic
• VS Code version: 1.44.1

Problem: I try to connect to postgres DBs in my Azure subscriptions using Azure Data Studio. My OS is Ubuntu 22.04. It looks like it's stuck trying to connect for a long period of time and I have to manually cancel the connection attempt. I think this might be linked to the PostgreSQL extension not working for me, see below.

Debugging efforts:
When launching the ADS app on my ubuntu OS, I'm getting the error 'Failed to start PGSQL tools service'. I suspect this is a contributing factor, if not the main cause of the problem.

When I change the log level to 'Debug' and reload ADS, I get the following output in the terminal. Looks like a TypeError is occuring because it's trying to read something that's undefined.

When I toggle developer settings in ADS after activating debug mode, I get the following output:

Things I've tried:

• Uninstalling and reinstalling the PostgreSQL extension
• Uninstalling and reinstalling Azure Data Studio on my Ubuntu OS
• Double-checking that libpq5 and openssl are installed in my OS (PostgreSQL extension dependencies)
• Installing the extension using the 0.3.1 vsix file from https://github.com/Microsoft/azuredatastudio-postgresql/releases/ but this didn't work.

I found similar issues (#108, #122) but none of the solutions in there worked for me.

Any thoughts/suggestions?

[karabaja4]

Check #392, #395.

[nasc17]

Bug has been addressed in our unstable release of PostgreSQL extension v0.4.0-insiders. We would appreciate your verification that it has been handled appropriately.

[bmuriithi1]

Can confirm v0.4.0 works fine for me now, thanks for the update!