MIME-Version: 1.0
References: 
 <CAKAfO9TS4zQwq8KpyYvxgo6S6Ci_-5axdPEzhMZoSDOOUik-hg@mail.gmail.com>
 <CAG8xnicAOxUUogOvRc=mK5dBy6QfrrdRwRzOWYRML5P1W27C6Q@mail.gmail.com>
 <CAM9w-_k34TH9WyG_yrygKscQUMW91QUNtUOwg08feGiT9LTJBg@mail.gmail.com>
In-Reply-To: 
 <CAM9w-_k34TH9WyG_yrygKscQUMW91QUNtUOwg08feGiT9LTJBg@mail.gmail.com>
From: Dee Dockery <wddockery@gmail.com>
Date: Mon, 1 Dec 2025 14:57:47 -0600
Message-ID: 
 <CAKAfO9TX582pP1riy+B=w06P_=WjRMOB5Z_ZwTesjkYY7FZ3sA@mail.gmail.com>
Subject: Re: pgAdmin4 v9.10 error -- connection failed: FATAL: database
 "24136" does not exist
To: Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>
Cc: Gus Spier <gus.spier@gmail.com>, pgadmin-support@lists.postgresql.org
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: 
 <https://www.postgresql.org/message-id/CAKAfO9TX582pP1riy%2BB%3Dw06P_%3DWjRMOB5Z_ZwTesjkYY7FZ3sA%40mail.gmail.com>
Precedence: bulk

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=E2=80=AFPM Aditya Toshniwal
<aditya.toshniwal@enterprisedb.com> wrote:
>
> Hi Gus,
>
> This is fixed with https://github.com/pgadmin-org/pgadmin4/issues/9354 an=
d will be available in 9.11.
> You can try the nightly builds - https://www.postgresql.org/ftp/pgadmin/p=
gadmin4/snapshots/
>
> On Sun, Nov 30, 2025 at 3:29=E2=80=AFAM Gus Spier <gus.spier@gmail.com> w=
rote:
>>
>> 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=E2=80=AFAM Dee Dockery <wddockery@gmail.co=
m> wrote:
>>>
>>> This is my first pgAdmin4 post.
>>>
>>> On my cloud server (x.x.x.x), I have been running postgres v14 for mont=
hs 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 prob=
lem, successfully using Object Explorer, Query tool, and PSQL tool.
>>>
>>> And I have been connecting to cloud postgres via Homebrew-installed psq=
l 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 c=
lient
>>>
>>>
>>> Following these changes, at least briefly, I maintained full functional=
ity 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.  C=
onnection attempt in Query Tool, for example, throws this error:
>>>
>>> connection failed: connection to server at "xx.xx.xx.xx", port 5xxx fai=
led: 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".  A=
nd "24136" does not appear in any field in my connection parameters in Quer=
y Tool.
>>>
>>> I still have connectivity to postgres v14 and v17 via Object Explorer i=
n pgAdmin4 v9.10.
>>>
>>> And I still have full connectivity to postgres v14 and v17 via laptop p=
sql.
>>>
>>> Any help appreciated.
>
>
>
> --
> Thanks,
> Aditya Toshniwal
> pgAdmin Hacker | Sr. Staff SDE II | enterprisedb.com
> "Don't Complain about Heat, Plant a TREE"