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-_k34TH9WyG_yrygKscQUMW91QUNtUOwg08feGiT9LTJBg@mail.gmail.com
Whole thread Raw
In response to Re: pgAdmin4 v9.10 error -- connection failed: FATAL: database "24136" does not exist  (Gus Spier <gus.spier@gmail.com>)
Responses Re: pgAdmin4 v9.10 error -- connection failed: FATAL: database "24136" does not exist
List pgadmin-support
Hi Gus,

This is fixed with https://github.com/pgadmin-org/pgadmin4/issues/9354 and will be available in 9.11.

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"

pgadmin-support by date:

Previous
From: Gus Spier
Date:
Subject: Re: pgAdmin4 v9.10 error -- connection failed: FATAL: database "24136" does not exist
Next
From: Aditya Toshniwal
Date:
Subject: Re: Support