BUG #19112: Error comes up on login to the QueryTool after update to PgAdmin 9.10

Started by PG Bug reporting form6 months ago3 messagesbugs
Jump to latest
#1PG Bug reporting form
noreply@postgresql.org

The following bug has been logged on the website:

Bug reference: 19112
Logged by: Thomas Konrad
Email address: t.konrad.002@gmail.com
PostgreSQL version: 18.1
Operating system: Ubuntu 22.04
Description:

The login on the shell still works perfectly

kot@EW01:~$ psql -p 5433 -U kot MyErp
psql (18.1 (Ubuntu 18.1-1.pgdg22.04+2), Server 16.11 (Ubuntu
16.11-1.pgdg22.04+1))
Geben Sie »help« für Hilfe ein.

MyErp=#

the login on the PgAdmin Welcome / QueryTool returns the message

SSL mode
sslmode
prefer
Connection timeout (seconds)
connect_timeout
10

Please enter the password for the user 'kot' to connect the server - "MyDb"

connection failed: connection to server at "127.0.0.1", port 5433 failed:
FATAL: Datenbank »16390« existiert nicht

----
DO I something wrong here? Please advice.

#2Thomas Konrad
t.konrad.002@gmail.com
In reply to: PG Bug reporting form (#1)
Re: BUG #19112: Error comes up on login to the QueryTool after update to PgAdmin 9.10

Hello,

attached a screen dump

Best regards

Thomas Konrad

Am 14.11.25 um 10:02 schrieb PG Bug reporting form:

Show quoted text

The following bug has been logged on the website:

Bug reference: 19112
Logged by: Thomas Konrad
Email address: t.konrad.002@gmail.com
PostgreSQL version: 18.1
Operating system: Ubuntu 22.04
Description:

The login on the shell still works perfectly

kot@EW01:~$ psql -p 5433 -U kot MyErp
psql (18.1 (Ubuntu 18.1-1.pgdg22.04+2), Server 16.11 (Ubuntu
16.11-1.pgdg22.04+1))
Geben Sie »help« für Hilfe ein.

MyErp=#

the login on the PgAdmin Welcome / QueryTool returns the message

SSL mode
sslmode
prefer
Connection timeout (seconds)
connect_timeout
10

Please enter the password for the user 'kot' to connect the server - "MyDb"

connection failed: connection to server at "127.0.0.1", port 5433 failed:
FATAL: Datenbank »16390« existiert nicht

----
DO I something wrong here? Please advice.

Attachments:

Bildschirmfoto vom 2025-11-14 09-47-44.pngimage/png; name="Bildschirmfoto vom 2025-11-14 09-47-44.png"Download+4-2
#3Greg Sabino Mullane
greg@turnstep.com
In reply to: PG Bug reporting form (#1)
Re: BUG #19112: Error comes up on login to the QueryTool after update to PgAdmin 9.10

No, you did not do something wrong. At least, not via that login attempt.
Interestingly, it's giving the oid in the error, not the dbname, which
(IIUC) suggests InitPostgres() is being called by a not-usual path, (e.g.
bgworker). Can you login to other databases on that cluster? Do you have
any extensions enabled? (if so, try commenting them out and restarting).

Cheers,
Greg

--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support