PostgreSQL Tools Service component could not start

[r-this]

• PGSQL Extension Version: PostgreSQL Tools Service component could not start
• VSCode Version: 1.71.2
• OS Version: Windows 11 Pro v 10.0.22621 Build 22621
  • WSL2 : Ubuntu

Steps to Reproduce:

1. Install PostgreSQL extension by Microsoft
2. Try to use it

Error happens right away first time trying to execute a command from command palette. After reload, it will happen once more. No output in OUTPUT: PGSQL

Output for SqlToolService Initialization

Initializing PostgreSQL tools service for the PostgreSQL extension.
Note: PostgreSQL commands will be available after installing the service.

Platform-------------: linux, x86_64, name=ubuntu, version=20.04 (Ubuntu16)

I found a closed issue that seems related. It was unsolved. Is it the case that the dependencies for this package are incompatible with the WSL version of Ubuntu?

I'd be interested if anyone knows a workaround, otherwise I'll try a different extension or continue to use browser tools.

Thanks!

[cj-wilson]

Same here. Ubuntu 20.04, VSCode 1.74.2

Not much in the way of error output.

[luxterful]

Same on MacOS 12.5.1, VSCode 1.74.2

[derhagen]

Same on latest fedora , VSCode 1.74.2

[derhagen]

Duplicate of https://github.com/microsoft/vscode-postgresql/issues/112

[gergo888]

Same here. Fedora 37.

[hakanjonsson]

Same here, github codespaces with VS 1.76.2, postgresql extension v 0.3.0

[shasherazi]

Same here on Arch linux (btw)

[PCampi]

Same here on MacOS 13.3.1

[AAndresen875]

same here on wsl2 Ubuntu 20.04

[Roang-zero1]

I fixed it by installing libffi-so-6 as per https://stackoverflow.com/a/63329830 and also installing psycopg2-binary in a scope where VSCode had access to it.

[dss010101]

im on bullseye..

[kristophertab]

Same issue, Windows 11, Docker Ubuntu:22.04 (WSL2) VS Code 1.78.0 PostgreSQL v0.3.0

[FelixNgFender]

Facing the same issue on Windows 11, WSL2, and Ubuntu 22.04

[DronHazra]

same issue, macos 13.4.1, vscode 1.79.2, extension v0.3.0

[BCYCAData]

Same here on Windows 10, WSL2, and Ubuntu 22.04

[Vorobeyko]

same issue, macos 12.6.1, vscode 1.81.1, extension 0.3.0

[nandansharma054]

same issue, Ubuntu 22.04.3 LTS, vscode 1.81.1

[Vorobeyko]

@akamath46297

[shaltai]

The same. macOS 12.6.8, VS Code 1.81.1, extension 0.3.0.

[angelul]

The same, macOS 13.5.1, VS Code 1.82.1, extension 0.3.0

[febrigilang]

the same ubuntu 22.04 lts, vscode 1.83.0

[sdavids]

also on: macOS 14.0 arm64; VSCode 1.83.1; PostgreSQL Extension 0.3.0

2023-10-12 19:00:06.945 [error] Activating extension ms-ossdata.vscode-postgresql failed due to an error:
2023-10-12 19:00:06.945 [error] TypeError: Cannot read properties of undefined (reading 'toString')
    at ServiceDownloadProvider.getDownloadFileName (/Users/dev/.vscode/extensions/ms-ossdata.vscode-postgresql-0.3.0/out/src/languageservice/serviceDownloadProvider.js:31:47)
    at /Users/dev/.vscode/extensions/ms-ossdata.vscode-postgresql-0.3.0/out/src/languageservice/serviceDownloadProvider.js:86:35
    at new Promise (<anonymous>)
    at ServiceDownloadProvider.installSQLToolsService (/Users/dev/.vscode/extensions/ms-ossdata.vscode-postgresql-0.3.0/out/src/languageservice/serviceDownloadProvider.js:85:16)
    at /Users/dev/.vscode/extensions/ms-ossdata.vscode-postgresql-0.3.0/out/src/languageservice/server.js:78:43
    at new Promise (<anonymous>)
    at ServerProvider.downloadServerFiles (/Users/dev/.vscode/extensions/ms-ossdata.vscode-postgresql-0.3.0/out/src/languageservice/server.js:76:16)

[rayrapetyan]

The most straightforward solution to address this problem is to utilize a VSCode devcontainer with the following configuration:

FROM mcr.microsoft.com/devcontainers/base:bionic

Once set up this way, there's no requirement to separately install libffi or psycopg2-binary.

I also experimented with bullseye and focal images, but unfortunately, they didn't work.

[valeriy-zainullin]

Same issue for me. Maybe the official way to use the extension should be to use the container :)

[raphaelcicupo]

Same here: VS Code version 1.88, Ubuntu 22.04.4 LTS 64-bit Intel

[ArpanSriv]

Facing the same issue. VSCode 1.88.1 Ubuntu 22.04.3 on WSL2 / Windows 11

[manavunderscoremehta]

Seriously, how come they cannot fix this

[alsoLut]

Seriously, how come they cannot fix this

This extension is abandonware, last update is from 4/16/2020

[kai-wen-zhang]

sounds like i should uninstall this and move on. what is another extension that works?