microsoft / microsoft/vscode-pgsql
Visualize schema when running pg-bouncer
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
When trying to visualize schema, or retrieve tables when using pg-bouncer (and IAM proxy for AWS), the listing fails. Other applications like dbeaver are successfully able to list tables.
Pg bouncer logs:
8:22AM INF 2025-09-09 08:22:41.707 UTC [16] ERROR C-0x4000103ab0: (nodb)/(nouser)@172.17.0.1:50148 auth_type=any requires forced user
2025-09-09 08:22:41.707 UTC [16] WARNING C-0x4000103ab0: (nodb)/(nouser)@172.17.0.1:50148 pooler error: bouncer config error
component=pgbouncer
To Reproduce
Steps to reproduce the behavior:
- Start PGproxy with AWS credentials
- Connect to postgres instance via extension
- Expand Schema folder
- .... Wait for tables to try and expand
Expected behavior
Tables become available
Screenshots
VS Code version
Version: 1.103.2 (Universal)
Commit: 6f17636121051a53c88d3e605c491d22af2ba755
Date: 2025-08-20T16:45:34.255Z (2 wks ago)
Electron: 37.2.3
ElectronBuildId: 12035395
Chromium: 138.0.7204.100
Node.js: 22.17.0
V8: 13.8.500258-electron.0
OS: Darwin arm64 24.6.0
Extension Logs
error connecting in '-392828453789808117': connection failed: connection to server at "127.0.0.1", port 3307 failed: FATAL: bouncer config error
error connecting in '-392828453789808117': connection failed: connection to server at "127.0.0.1", port 3307 failed: FATAL: bouncer config error
error connecting in '-392828453789808117': connection failed: connection to server at "127.0.0.1", port 3307 failed: FATAL: bouncer config error
error connecting in '-392828453789808117': connection failed: connection to server at "127.0.0.1", port 3307 failed: FATAL: bouncer config error
error connecting in '-392828453789808117': connection failed: connection to server at "127.0.0.1", port 3307 failed: FATAL: bouncer config error
error connecting in '-392828453789808117': connection failed: connection to server at "127.0.0.1", port 3307 failed: FATAL: bouncer config error
error connecting in '-392828453789808117': connection failed: connection to server at "127.0.0.1", port 3307 failed: FATAL: bouncer config error
error connecting in '-392828453789808117': connection failed: connection to server at "127.0.0.1", port 3307 failed: FATAL: bouncer config error
error connecting in '-392828453789808117': connection failed: connection to server at "127.0.0.1", port 3307 failed: FATAL: bouncer config error
error connecting in '-392828453789808117': connection failed: connection to server at "127.0.0.1", port 3307 failed: FATAL: bouncer config error
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 by reproducing the failure through the VS Code extension while connecting to PostgreSQL through PgBouncer or the AWS IAM proxy, then inspect the schema and table-listing connection flow alongside the reported PgBouncer logs. Done means expanding the Schema folder retrieves and displays tables without the bouncer config error.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- aws, postgresql, vscode
- Domain
- cloud, databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 35/100