Cannot connect to the server via Query Tool Workspace

[bvaughan981]

Please note that security bugs or issues should be reported to security@pgadmin.org.

Describe the bug

I have a local database (localhost:5432). It has a database "postgres"
I can register a service in the Object Explorer and I can view the database and the tables.
When I click on the Query Tool Workspace, and select the existing server and database and enter the user and password and click Connect & Open Query Tool i get this error:
connection failed: connection to server at "127.0.0.1", port 5432 failed: FATAL: database "5" does not exist

To Reproduce

Steps to reproduce the behavior:

1. Install a local database
2. Click on Query Tool Workspace
3. Select the existing server and database and enter the user and password
4. Click Connect & Open Query Tool
5. See the errorExpected behavior

Error message

connection failed: connection to server at "127.0.0.1", port 5432 failed: FATAL: database "5" does not exist

Screenshots

Desktop (please complete the following information):

• OS: OSX Sequoia 15.6.1
• pgAdmin version: 9.10
• Mode: Desktop

[sun-777]

pgAdmin4 version: 9.10
PostgreSQL version: 17.7 (docker image)

Same problem.
Database connection OK, but Query Tool & PSQL Tool workspace connection failed.

[bwakkie]

Would using Unix sockeds help as temporary solution?