Thread

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

   PG Bug reporting form <noreply@postgresql.org> — 2025-11-14T09:02:27Z

   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.
   
   

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

   Thomas Konrad <t.konrad.002@gmail.com> — 2025-11-14T09:05:24Z

   Hello,
   
   attached a screen dump
   
   
   Best regards
   
   Thomas Konrad
   
   
   Am 14.11.25 um 10:02 schrieb PG Bug reporting form:
   > 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.
   >

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

   Greg Sabino Mullane <htamfids@gmail.com> — 2025-11-14T16:21:32Z

   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