Обсуждение: BUG #19112: Error comes up on login to the QueryTool after update to PgAdmin 9.10

Поиск
Список
Период
Сортировка

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

От
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.


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

От
Greg Sabino Mullane
Дата:
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

--
Enterprise Postgres Software Products & Tech Support