public inbox for [email protected]help / color / mirror / Atom feed
pgAdmin4 v9.10 error -- connection failed: FATAL: database "24136" does not exist 5+ messages / 3 participants [nested] [flat]
* pgAdmin4 v9.10 error -- connection failed: FATAL: database "24136" does not exist @ 2025-11-29 16:44 Dee Dockery <[email protected]> 0 siblings, 1 reply; 5+ messages in thread From: Dee Dockery @ 2025-11-29 16:44 UTC (permalink / raw) To: [email protected] 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. ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pgAdmin4 v9.10 error -- connection failed: FATAL: database "24136" does not exist @ 2025-11-29 21:58 Gus Spier <[email protected]> parent: Dee Dockery <[email protected]> 0 siblings, 1 reply; 5+ messages in thread From: Gus Spier @ 2025-11-29 21:58 UTC (permalink / raw) To: Dee Dockery <[email protected]>; +Cc: [email protected] 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 <[email protected]> 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. > ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pgAdmin4 v9.10 error -- connection failed: FATAL: database "24136" does not exist @ 2025-12-01 04:49 Aditya Toshniwal <[email protected]> parent: Gus Spier <[email protected]> 0 siblings, 1 reply; 5+ messages in thread From: Aditya Toshniwal @ 2025-12-01 04:49 UTC (permalink / raw) To: Gus Spier <[email protected]>; +Cc: Dee Dockery <[email protected]>; [email protected] 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 <[email protected]> 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 <[email protected]> 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* <https://www.enterprisedb.com/; "Don't Complain about Heat, Plant a TREE" ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pgAdmin4 v9.10 error -- connection failed: FATAL: database "24136" does not exist @ 2025-12-01 20:57 Dee Dockery <[email protected]> parent: Aditya Toshniwal <[email protected]> 0 siblings, 1 reply; 5+ messages in thread From: Dee Dockery @ 2025-12-01 20:57 UTC (permalink / raw) To: Aditya Toshniwal <[email protected]>; +Cc: Gus Spier <[email protected]>; [email protected] 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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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" ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pgAdmin4 v9.10 error -- connection failed: FATAL: database "24136" does not exist @ 2025-12-02 04:37 Aditya Toshniwal <[email protected]> parent: Dee Dockery <[email protected]> 0 siblings, 0 replies; 5+ messages in thread From: Aditya Toshniwal @ 2025-12-02 04:37 UTC (permalink / raw) To: Dee Dockery <[email protected]>; +Cc: Gus Spier <[email protected]>; [email protected] 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 <[email protected]> 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 > <[email protected]> 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 <[email protected]> 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 <[email protected]> > 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 pgAdmin Hacker | Sr. Staff SDE II | *enterprisedb.com* <https://www.enterprisedb.com/; "Don't Complain about Heat, Plant a TREE" ^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2025-12-02 04:37 UTC | newest] Thread overview: 5+ messages (download: mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2025-11-29 16:44 pgAdmin4 v9.10 error -- connection failed: FATAL: database "24136" does not exist Dee Dockery <[email protected]> 2025-11-29 21:58 ` Gus Spier <[email protected]> 2025-12-01 04:49 ` Aditya Toshniwal <[email protected]> 2025-12-01 20:57 ` Dee Dockery <[email protected]> 2025-12-02 04:37 ` Aditya Toshniwal <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox