microsoft / microsoft/vscode-pgsql
Extension fails to load due to missing GLIBC 2.35
Nobody has claimed this yet.
- Dominant language
- No language data
- Stars
- 395
- Forks
- 33
- Avg merge
- 1h 46m
- Merged PRs (30d)
- 3
Description
Describe the bug
The pgsql extension does not load. A notification appears: "pgsql: PostgreSQL Tools Service component could not start."
To Reproduce
- Connect to a remote CentOS 7.9.2009 host using Remote SSH from a MacBook Pro (Apple M4 Pro, macOS 15.5)
- Install or enable the
ms-ossdata.vscode-pgsqlextension - Attempt to use the extension
- Observe error notification and extension fails to start
Expected behavior
The extension should load and initialize the PostgreSQL Tools Service successfully, making its features available in VS Code.
Screenshots
N/A (see logs below)
VS Code version
Client Machine:
Model Name: MacBook Pro
Model Identifier: Mac16,7
Model Number: MX2X3LL/A
Chip: Apple M4 Pro
Total Number of Cores: 14 (10 performance and 4 efficiency)
Memory: 24 GB
System Version: macOS 15.5 (24F74)
Remote SSH Host:
LSB Version: :core-4.1-amd64:core-4.1-noarch
Distributor ID: CentOS
Description: CentOS Linux release 7.9.2009 (Core)
Release: 7.9.2009
Codename: Core
Extension Logs
[2:41:46 PM] [PgToolsService Initialization] ServiceDownloadProvider initialized
[2:41:46 PM] [PgToolsService Initialization] Initializing PostgreSQL Tools Service for the pgsql extension.
[2:41:46 PM] [PgToolsService Initialization] Note: pgsql commands will be available after installing the service.
[2:41:46 PM] [PgToolsService Initialization]
[2:41:46 PM] [PgToolsService Initialization] Platform: linux, x86_64, name=centos, version=7 (CentOS)
[2:41:46 PM] [PgToolsService Initialization]
[2:41:46 PM] [PgToolsService Initialization] Checking server path for runtime ID: CentOS_7
[2:41:46 PM] [PgToolsService Initialization] Server path not found for runtime ID: CentOS_7
[2:41:46 PM] [PgToolsService Initialization] Downloading server files
[2:41:46 PM] [PgToolsService Initialization] Using tools server filename: linux-x64.tar.gz
[2:41:46 PM] [PgToolsService Initialization] Installing PostgreSQL Tools Service to /root/.vscode-server/extensions/ms-ossdata.vscode-pgsql-1.4.1/pgsqltoolsservice/v2.0.3/CentOS.
[2:41:46 PM] [PgToolsService Initialization] Downloading https://github.com/microsoft/pgsql-tools/releases/download/v2.0.3/pgsqltoolsservice-linux-x64.tar.gz
[2:41:47 PM] [PgToolsService Initialization] (81795 KB) ....................[Verbose]: Downloaded to /tmp/package-6102akMl5M2OT4kw.tmp...
[2:41:56 PM] [PgToolsService Initialization] Done!
[2:41:56 PM] [PgToolsService Initialization] Installing ...
[2:42:21 PM] [PgToolsService Initialization] Done! 1824 files unpacked.
[2:42:21 PM] [PgToolsService Initialization] Server files downloaded to: /root/.vscode-server/extensions/ms-ossdata.vscode-pgsql-1.4.1/pgsqltoolsservice/v2.0.3/CentOS/pgsqltoolsservice/ossdbtoolsservice_main
[2:42:21 PM] [PgToolsService Initialization] Attempting to initialize language client
[2:42:21 PM] [PgToolsService Initialization] Checking overrides for language client initialization
[2:42:21 PM] [PgToolsService Initialization] Creating the language client with options: {"command":"/root/.vscode-server/extensions/ms-ossdata.vscode-pgsql-1.4.1/pgsqltoolsservice/v2.0.3/CentOS/pgsqltoolsservice/ossdbtoolsservice_main","args":["--log-file","/root/.vscode-server/data/logs/20250520T144045/exthost1/ms-ossdata.vscode-pgsql/sqltools.log","--tracing-level","All","--application-name","Code","--data-path","/root/.config","--enable-sql-authentication-provider"],"transport":0}
[2:42:21 PM] [PgToolsService Initialization] Language client created
[2:42:21 PM] [PgToolsService Initialization] Starting language client
[2:42:21 PM] [PgToolsService Initialization] Language client started
[2:42:21 PM] [PgToolsService Initialization] Waiting for client to be ready
[Error - 2:42:21 PM] Connection to server is erroring. Shutting down server.
[PYI-9544:ERROR] Failed to load Python shared library '/root/.vscode-server/extensions/ms-ossdata.vscode-pgsql-1.4.1/pgsqltoolsservice/v2.0.3/CentOS/pgsqltoolsservice/_internal/libpython3.10.so': dlopen: /lib64/libm.so.6: version `GLIBC_2.35' not found (required by /root/.vscode-server/extensions/ms-ossdata.vscode-pgsql-1.4.1/pgsqltoolsservice/v2.0.3/CentOS/pgsqltoolsservice/_internal/libpython3.10.so)
Additional context
It appears the extension's service is built against GLIBC 2.35, but CentOS 7 only provides GLIBC 2.17. This makes the extension unusable on CentOS 7 remote hosts.
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start with the CentOS_7 runtime selection and the downloaded pgsqltoolsservice-linux-x64.tar.gz artifact described in the issue, then inspect the packaged ossdbtoolsservice_main and its _internal/libpython3.10.so dependency. Reproduce on CentOS 7 and identify a compatible service build or packaging path. Done means the extension service initializes without requiring GLIBC_2.35 and the connection error no longer appears.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- linux, postgresql, python, vscode
- Domain
- databases, devtools
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Quiet
- Clarity
- Mostly clear
- Newbie friendliness
- 43/100