Re: pgAdmin4 v9.10 error -- connection failed: FATAL: database "24136" does not exist

From: Gus Spier <gus(dot)spier(at)gmail(dot)com>
To: Dee Dockery <wddockery(at)gmail(dot)com>
Cc: pgadmin-support(at)lists(dot)postgresql(dot)org
Subject: Re: pgAdmin4 v9.10 error -- connection failed: FATAL: database "24136" does not exist
Date: 2025-11-29 21:58:47
Message-ID: CAG8xnicAOxUUogOvRc=mK5dBy6QfrrdRwRzOWYRML5P1W27C6Q@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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(at)gmail(dot)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.
>

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Aditya Toshniwal 2025-12-01 04:49:23 Re: pgAdmin4 v9.10 error -- connection failed: FATAL: database "24136" does not exist
Previous Message Dee Dockery 2025-11-29 16:44:45 pgAdmin4 v9.10 error -- connection failed: FATAL: database "24136" does not exist