Failed to start Pgsql tools service on MacOS

[maverick915]

• Azure Data Studio Version: 1.4.5 (MacOS 10.13.6)

Steps to Reproduce:

1. Install PostgreSQL extension (v0.1.0) through the Extension Manager (following instructions from https://docs.microsoft.com/en-us/sql/azure-data-studio/postgres-extension?view=sql-server-2017)
2. Restart Azure Data Studio
3. Popup displays in bottom right corner with the message "Failed to start Pgsql tools service". Expanding the dialog (arrow icon) gives "Source: PostgreSQL (Extension)".

There is no additional information in the Output or Problems windows.

After enabling debug logging, I see the following message in the main.log:

[2019-03-25 12:31:01.329] [main] [error] UpdateService error: Cannot update while running on a read-only volume. The application is on a read-only volume. Please move the application and try again. If you're on macOS Sierra or later, you'll need to move the application out of the Downloads directory. See Squirrel/Squirrel.Mac#182 for more information.

[DigitalDuquette]

This issue has started for me as well on the latest release of macOS (10.14.5). The message doesn't error out it hangs at 'Starting pgsql service' 

I've tried uninstalling and reinstalling the extension.

ERR The "path" argument must be of type string. Received type object: TypeError [ERR_INVALID_ARG_TYPE]: The "path" argument must be of type string. Received type object at assertPath (path.js:39:11) at Object.join (path.js:1157:7) at toAbsolutePath (file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:207868:52) at resolveIconPath (file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:207894:13) at ExtensionPoint.extensionsRegistry_1.ExtensionsRegistry.registerExtensionPoint.setHandler.extensions [as _handler] (file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:207846:13) at ExtensionPoint._handle (file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:207237:22) at ExtensionPoint.acceptUsers (file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:207230:18) at Function._handleExtensionPoint (file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:257961:28) at ExtensionService._rehandleExtensionPoints (file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:257432:38) at ExtensionService.<anonymous> (file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:257405:22) at Generator.next (<anonymous>) at fulfilled (file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/workbench.main.js:5933:58) at ZoneDelegate.invoke (/Applications/Azure Data Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.js:388:26) at Zone.run (/Applications/Azure Data Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.js:138:43) at /Applications/Azure Data Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.js:872:34 at ZoneDelegate.invokeTask (/Applications/Azure Data Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.js:421:31) at Zone.runTask (/Applications/Azure Data Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.js:188:47) at drainMicroTaskQueue (/Applications/Azure Data Studio.app/Contents/Resources/app/node_modules/zone.js/dist/zone-node.js:595:35)

[marko-p]

I'm getting the same error on Windows 10. I do get a PostgreSQL option in the connection sidebar, but I am not able to connect to my PG DB (no error, just endless connection loading).

EDIT: I reinstalled the extension by downloading the latest vsix release and now I can connect to PG! At least for now. I guess our corporate firewall is to blame ...

[swjain23]

@maverick915 - Hi, are you still hitting this issue? Can you try the latest version of extension with latest ADS release?

[gvdncgcg]

@maverick915 - Hi, are you still hitting this issue? Can you try the latest version of extension with latest ADS release?

Hi I am still getting "Failed to start Pgsql tools service" when using the Postgresql Extension (0.2.6) with ADS (1.20.1) on a MacOS Catalina 10.15.2. I've tried disabling/restarting/uninstalling/re-installing/etc. Nothing seems to have worked

I am able to connect to postgres dbs otherwise with either PGAdmin or DataGrip (IntelliJ), but for some reason just can't get this to work

I also tried downloading the VSIX file directly from the releases site here based on the instructions here. It looks like the install worked, however on reload gave me an error in console.

@swjain23 I'm not sure if this is the same issue as OP, so am happy to open a new issue if you want to close this one?

[Error - 11:00:30 AM] Starting client failed
Launching server using command /Users/***/.azuredatastudio/extensions/microsoft.azuredatastudio-postgresql-0.2.6/out/pgsqltoolsservice/OSX/v1.4.0/pgsqltoolsservice/pgtoolsservice_main failed.

[maverick915]

@maverick915 - Hi, are you still hitting this issue? Can you try the latest version of extension with latest ADS release?

Working now. Thanks for tagging me on the fix.

[MaxKoval1ov]

Still not fixed?

[cvannoy]

@MaxKoval1ov Try installing the mac universal installer. Then right click on the app in finder and select Get Info. Then put a check mark in 'Open Using Rosetta'. I have an Apple M1 Pro chip running Ventura and I've been fighting this all day. This combo worked for me. Link to Universal Installer: https://go.microsoft.com/fwlink/?linkid=2222873

[MaxKoval1ov]

Cool, work for me, but it is a little bit confusing that Silicon version doesn't support psql extension. Moreover rosetta slows down applications cause of emulation(

[MaxKoval1ov]

@MaxKoval1ov Try installing the mac universal installer. Then right click on the app in finder and select Get Info. Then put a check mark in 'Open Using Rosetta'. I have an Apple M1 Pro chip running Ventura and I've been fighting this all day. This combo worked for me. Link to Universal Installer: https://go.microsoft.com/fwlink/?linkid=2222873

Maybe you also have solution for the following error:

[cvannoy]

@MaxKoval1ov I dont. sorry. good luck.

[denxwan]

@cvannoy Thanks man this worked for me!