Re: pgAdmin4 v9.10 error -- connection failed: FATAL: database "24136" does not exist - Mailing list pgadmin-support
| From | Aditya Toshniwal |
|---|---|
| Subject | Re: pgAdmin4 v9.10 error -- connection failed: FATAL: database "24136" does not exist |
| Date | |
| Msg-id | CAM9w-_n1C5BEWJNnMTz7JtUfGR9s61B_mWqpco+xTVL-YvUUcg@mail.gmail.com Whole thread Raw |
| In response to | Re: pgAdmin4 v9.10 error -- connection failed: FATAL: database "24136" does not exist (Dee Dockery <wddockery@gmail.com>) |
| List | pgadmin-support |
Hi Dee,
It is scheduled to be released on 11th Dec if everything goes well.
On Tue, Dec 2, 2025 at 2:28 AM Dee Dockery <wddockery@gmail.com> wrote:
Hi, Aditya. Thanks for clarifying that this is a known issue.
I don't normally download nightly builds. Can you predict when 9.11
will become available?
William
On Sun, Nov 30, 2025 at 10:49 PM Aditya Toshniwal
<aditya.toshniwal@enterprisedb.com> wrote:
>
> Hi Gus,
>
> This is fixed with https://github.com/pgadmin-org/pgadmin4/issues/9354 and will be available in 9.11.
> You can try the nightly builds - https://www.postgresql.org/ftp/pgadmin/pgadmin4/snapshots/
>
> On Sun, Nov 30, 2025 at 3:29 AM Gus Spier <gus.spier@gmail.com> wrote:
>>
>> That looks suspiciously like the OID (Object Identifier) for a database. According to documentation, you can find the database OID with
>> SELECT oid, datname FROM pg_database;
>>
>> If that works, it will display the OID and the database name.
>>
>> That might help you.
>>
>> Regards,
>> Gus
>>
>> On Sat, Nov 29, 2025 at 11:45 AM Dee Dockery <wddockery@gmail.com> wrote:
>>>
>>> This is my first pgAdmin4 post.
>>>
>>> On my cloud server (x.x.x.x), I have been running postgres v14 for months with no problem.
>>>
>>> And I have been connecting to cloud postgres via pgAdmin4 (through v9.9) on my MacBook Air (Mac OS v15.6.1, chip Apple M2) for months with no problem, successfully using Object Explorer, Query tool, and PSQL tool.
>>>
>>> And I have been connecting to cloud postgres via Homebrew-installed psql on my local Mac with no problem.
>>>
>>> I recently changed my postgres environment:
>>>
>>> updated to pgAdmin4 v9.10
>>> added a postgres v17 server instance on the same IP address as my cloud server, using a different port
>>> installed postgres v17 on my laptop so that I would have updated psql client
>>>
>>>
>>> Following these changes, at least briefly, I maintained full functionality of both postgres v14 and v17 instances, full connectivity via pgAdmin4 v9.10, and full connectivity via psql on my laptop.
>>>
>>> Then, inexplicably, for the past few days, I have lost connectivity to postgres v14 and v17 , ONLY via pgAdmin4 v9.10 Query Tool and PSQL Tool. Connection attempt in Query Tool, for example, throws this error:
>>>
>>> connection failed: connection to server at "xx.xx.xx.xx", port 5xxx failed: FATAL: database "24136" does not exist
>>>
>>> (Note: "x" in the text above is redacted data)
>>>
>>> "24136" is a mystery number. I do not have a database named "24136". And "24136" does not appear in any field in my connection parameters in Query Tool.
>>>
>>> I still have connectivity to postgres v14 and v17 via Object Explorer in pgAdmin4 v9.10.
>>>
>>> And I still have full connectivity to postgres v14 and v17 via laptop psql.
>>>
>>> Any help appreciated.
>
>
>
> --
> Thanks,
> Aditya Toshniwal
> pgAdmin Hacker | Sr. Staff SDE II | enterprisedb.com
> "Don't Complain about Heat, Plant a TREE"
Thanks,
Aditya Toshniwal
"Don't Complain about Heat, Plant a TREE"
pgadmin-support by date:
Previous
From: Dee DockeryDate:
Subject: Re: pgAdmin4 v9.10 error -- connection failed: FATAL: database "24136" does not exist