microsoft / microsoft/vscode-pgsql

Visualize schema when running pg-bouncer

Open
#150 3 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

bug
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:

  1. Start PGproxy with AWS credentials
  2. Connect to postgres instance via extension
  3. Expand Schema folder
  4. .... Wait for tables to try and expand

Expected behavior

Tables become available

Screenshots

Image

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

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.