MIME-Version: 1.0
References: 
 <CAKAfO9TS4zQwq8KpyYvxgo6S6Ci_-5axdPEzhMZoSDOOUik-hg@mail.gmail.com>
In-Reply-To: 
 <CAKAfO9TS4zQwq8KpyYvxgo6S6Ci_-5axdPEzhMZoSDOOUik-hg@mail.gmail.com>
From: Gus Spier <gus.spier@gmail.com>
Date: Sat, 29 Nov 2025 16:58:47 -0500
Message-ID: 
 <CAG8xnicAOxUUogOvRc=mK5dBy6QfrrdRwRzOWYRML5P1W27C6Q@mail.gmail.com>
Subject: Re: pgAdmin4 v9.10 error -- connection failed: FATAL: database
 "24136" does not exist
To: Dee Dockery <wddockery@gmail.com>
Cc: pgadmin-support@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000005d2e920644c2da86"
Archived-At: 
 <https://www.postgresql.org/message-id/CAG8xnicAOxUUogOvRc%3DmK5dBy6QfrrdRwRzOWYRML5P1W27C6Q%40mail.gmail.com>
Precedence: bulk

--0000000000005d2e920644c2da86
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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.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 functionalit=
y
> 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 psq=
l.
>
> Any help appreciated.
>

--0000000000005d2e920644c2da86
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">That looks suspiciously like the OID (Object Identifier) f=
or a database. According to documentation, you can find the database OID wi=
th<div><font face=3D"monospace">SELECT=C2=A0oid, datname FROM pg_database;<=
/font></div><div><font face=3D"monospace"><br></font></div><div><font face=
=3D"arial, sans-serif">If that works, it will display the OID and the datab=
ase name.=C2=A0</font></div><div><font face=3D"arial, sans-serif"><br></fon=
t></div><div><font face=3D"arial, sans-serif">That might help you.</font></=
div><div><font face=3D"arial, sans-serif"><br></font></div><div><font face=
=3D"arial, sans-serif">Regards,</font></div><div><font face=3D"arial, sans-=
serif">Gus</font></div></div><br><div class=3D"gmail_quote gmail_quote_cont=
ainer"><div dir=3D"ltr" class=3D"gmail_attr">On Sat, Nov 29, 2025 at 11:45=
=E2=80=AFAM Dee Dockery &lt;<a href=3D"mailto:wddockery@gmail.com">wddocker=
y@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=
=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding=
-left:1ex"><div dir=3D"ltr">This is my first pgAdmin4 post.<div><br></div><=
div>On my cloud server (x.x.x.x), I have been running postgres v14 for mont=
hs with no problem. =C2=A0</div><div><br></div><div>And I have been connect=
ing 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 Obj=
ect Explorer, Query tool, and PSQL tool. =C2=A0</div><div><br></div><div>An=
d I have been connecting to cloud postgres via Homebrew-installed psql on m=
y local Mac with no problem.<br><br>I recently changed my postgres environm=
ent:<br><ul><li>updated to pgAdmin4 v9.10</li><li>added a postgres v17 serv=
er instance on the same IP address as my cloud server, using a different po=
rt</li><li>installed postgres v17 on my laptop so that I would have updated=
 psql client</li></ul><br>Following these changes, at least briefly, I main=
tained full functionality of both postgres v14 and v17 instances, full conn=
ectivity via pgAdmin4 v9.10, and full connectivity via psql on my laptop.<b=
r><br>Then, inexplicably, for the past few days, I have lost connectivity t=
o postgres v14 and v17 , ONLY via pgAdmin4 v9.10 Query Tool and PSQL Tool.=
=C2=A0 Connection attempt in Query Tool, for example, throws this error:<br=
><br>connection failed: connection to server at &quot;xx.xx.xx.xx&quot;, po=
rt 5xxx failed: FATAL: database &quot;24136&quot; does not exist<br><br>(No=
te: =C2=A0&quot;x&quot; in the text above is redacted data)<br><br>&quot;24=
136&quot; is a mystery number. I do not have a database named &quot;24136&q=
uot;.=C2=A0 And &quot;24136&quot; does not appear in any field in my connec=
tion parameters in Query Tool.=C2=A0=C2=A0<br><br>I still have connectivity=
 to postgres v14 and v17 via Object Explorer in pgAdmin4 v9.10.<br><br>And =
I still have full connectivity to postgres v14 and v17 via laptop psql.<br>=
<br>Any help appreciated.</div></div>
</blockquote></div>

--0000000000005d2e920644c2da86--