Failed to start Pgsql tools service

[alty-ir]

Azure Data Studio Version: 1.43.0 OS: Windows 11 X64

[meldj]

Hi everyone,

Failed to start Pgsql tools service

I have the same error.

Azure Data Studio Version: 1.43.0 OS: Darwin arm64 22.4.0

Best regards

[realandrew]

I also have the same issue:

Azure Data Studio: 1.43.0 OS: Darwin arm64 22.4.0 PostreSQL Extension: 0.2.7

[jhalmu]

Same issue here:

Azure Data Studio: 1.43.0 OS: Darwin arm64 22.4.0 PostreSQL Extension: 0.2.7

[matrs]

The previous release, 0.2.7 worked, but this update (0.3.1) fails. Also, there isn't any information logged. Previously I can see some relevant information in ~/.config/azuredatastudio/logs/ , but now, there isn't anything related to this problem. I'm in Linux 5.15.112

[dwfallin]

also failing to 'start PGSQL tools service'! ADS: 1.44.0 OS: Ubuntu 22.04 PostgreSQL: 0.3.1

[dwfallin]

tried to install 0.2.7 from vsix file and now i get: "Couldn't start client ossdbToolsService"? ugh - anyone find a workaround?

[dwfallin]

so - was able to get 0.2.7 working - the ossdbtoolsservice_main was not executable, so chmod'd that and restarted ads and at least i'm talking to db's again! it does not appear the 'service_main' file is even there in the 0.3.1 build? the out/ossdbtoolsservice/Linux/1.7.1/ folder is empty - not sure if it SHOULD be - but thats where i found the executable in the earlier release so maybe thats related?

[nasc17]

Issue 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.

[meldj]

Hi,

I just tried it and now it works.

Version: 1.44.1 Commit: 8f53a316fa00a98264f1ab119641cd540b5af25c Date: 2023-06-01T02:13:52.990Z (3 wks ago) VS Code: 1.70.0 Electron: 19.1.8 Chromium: 102.0.5005.167 Node.js: 16.14.2 V8: 10.2.154.15-electron.0 OS: Darwin arm64 22.5.0

Name: PostgreSQL Id: Microsoft.azuredatastudio-postgresql Description: PostgreSQL extension for Azure Data Studio Version: 0.3.1

Thank you so much!!

[hjrb]

Issue 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.

Still occurs with Azure Data Studio Version: 1.44.1 (system setup) Commit: 8f53a316fa00a98264f1ab119641cd540b5af25c Date: 2023-06-01T02:12:48.765Z VS Code: 1.70.0 Electron: 19.1.8 Chromium: 102.0.5005.167 Node.js: 16.14.2 V8: 10.2.154.15-electron.0 OS: Windows_NT x64 10.0.19045

and extension v0.5.0

[nasc17]

@hjrb

Could you please navigate to C:\Users.azuredatastudio\extensions and clear out any existing PostgreSQL extensions. (Don't worry about losing your connection info, they will appear once you re-install the extension)

Open your file explorer, go to the %temp% location, and remove any folders named _MEI<6digit number> if they exist.

Once you've completed these steps, please try downloading and installing the new version of the PostgreSQL extension again.

We do have an insiders version out now if you wish to check against this unstable release: https://github.com/microsoft/azuredatastudio-postgresql/releases/tag/v0.5.1-insiders

Please let us know if this resolves the issue or if you need further assistance. If issue persists open up new issue with all relevant information and logging if possible.

[hjrb]

Hi, thank you for the continued effort. 1.) using the procedure to delete temp files and extension files and using the regular extension version does not work. A _MEI<6digit number> did not exist 2.) when I install the insider version I get a MS AppLocker warning preventing to use python310.dll So that is a progress I guess.

[nasc17]

@hjrb thank you for the update. Please revert back to using the extension version that allows you to start the tools service. We are working on having a new release out in the next coming weeks.