[GH-ISSUE #5] Can't Open/Connect to Newly Created Postgres 10 database #4

Closed
opened 2026-05-05 03:29:01 -06:00 by gitea-mirror · 3 comments
Owner

Originally created by @bradleyf on GitHub (May 1, 2020).
Original GitHub issue: https://github.com/levinsv/pgadmin3/issues/5

I can use the latest pgadmin3 build to create a new database on postgres 10, but when I try to open/connect to it, I am getting an error dialog box which says "ERROR: No such Database: <database_name>". The database does appear in the object browser tree, each time I connect to the server. It a;los does show the properties of the database in the properties tab, and the SQL for the database created in the SQL pane, after I click ok on the error dialog. It just won't open/connect to that database. It will connect to prior existing databases on the same server.

I hope you can fix this issue as I think your enhanced version of pgadmin 3 is my favorite postgresql tool (over the latest pgadmin 4).

Originally created by @bradleyf on GitHub (May 1, 2020). Original GitHub issue: https://github.com/levinsv/pgadmin3/issues/5 I can use the latest pgadmin3 build to create a new database on postgres 10, but when I try to open/connect to it, I am getting an error dialog box which says "ERROR: No such Database: <database_name>". The database does appear in the object browser tree, each time I connect to the server. It a;los does show the properties of the database in the properties tab, and the SQL for the database created in the SQL pane, after I click ok on the error dialog. It just won't open/connect to that database. It will connect to prior existing databases on the same server. I hope you can fix this issue as I think your enhanced version of pgadmin 3 is my favorite postgresql tool (over the latest pgadmin 4).
Author
Owner

@levinsv commented on GitHub (May 5, 2020):

This message says that a non-existing database is specified (server properties..).
In the "Maintenance DB" specify the correct name or postgres or template1.
Look at the psql -l command which databases exist on the server.

<!-- gh-comment-id:624048607 --> @levinsv commented on GitHub (May 5, 2020): This message says that a non-existing database is specified (server properties..). In the "Maintenance DB" specify the correct name or postgres or template1. Look at the psql -l command which databases exist on the server.
Author
Owner

@bradleyf commented on GitHub (May 5, 2020):

No, not the case. The database opens/connects fine in pgadmin 4

From: levinsv notifications@github.com
Sent: Tuesday, May 5, 2020 9:17 AM
To: levinsv/pgadmin3 pgadmin3@noreply.github.com
Cc: Bradley Feldman bradley@bradleyloritheo.com; Author author@noreply.github.com
Subject: {Disarmed} Re: [levinsv/pgadmin3] Can't Open/Connect to Newly Created Postgres 10 database (#5)

This message says that a non-existing database is specified (server properties..).
In the "Maintenance DB" specify the correct name or postgres or template1.
Look at the psql -l command which databases exist on the server.


You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub https://github.com/levinsv/pgadmin3/issues/5#issuecomment-624048607 , or unsubscribe https://github.com/notifications/unsubscribe-auth/AAE5YAVOKNMEAA4K75CSQZ3RQAGTPANCNFSM4MXEF5HQ . https://s3.amazonaws.com/msv5/images/spacer.gif

[ { "@context": "http://schema.org", "@type": "EmailMessage", "potentialAction": { "@type": "ViewAction", "target": "https://github.com/levinsv/pgadmin3/issues/5#issuecomment-624048607", "url": "https://github.com/levinsv/pgadmin3/issues/5#issuecomment-624048607", "name": "View Issue" }, "description": "View this Issue on GitHub", "publisher": { "@type": "Organization", "name": "GitHub", "url": "https://github.com" } } ]

This message has been scanned for viruses and
dangerous content by http://www.mailscanner.info/ MailScanner, and is
believed to be clean.

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

<!-- gh-comment-id:624054496 --> @bradleyf commented on GitHub (May 5, 2020): No, not the case. The database opens/connects fine in pgadmin 4 From: levinsv <notifications@github.com> Sent: Tuesday, May 5, 2020 9:17 AM To: levinsv/pgadmin3 <pgadmin3@noreply.github.com> Cc: Bradley Feldman <bradley@bradleyloritheo.com>; Author <author@noreply.github.com> Subject: {Disarmed} Re: [levinsv/pgadmin3] Can't Open/Connect to Newly Created Postgres 10 database (#5) This message says that a non-existing database is specified (server properties..). In the "Maintenance DB" specify the correct name or postgres or template1. Look at the psql -l command which databases exist on the server. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <https://github.com/levinsv/pgadmin3/issues/5#issuecomment-624048607> , or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAE5YAVOKNMEAA4K75CSQZ3RQAGTPANCNFSM4MXEF5HQ> . <https://s3.amazonaws.com/msv5/images/spacer.gif> [ { "@context": "http://schema.org", "@type": "EmailMessage", "potentialAction": { "@type": "ViewAction", "target": "https://github.com/levinsv/pgadmin3/issues/5#issuecomment-624048607", "url": "https://github.com/levinsv/pgadmin3/issues/5#issuecomment-624048607", "name": "View Issue" }, "description": "View this Issue on GitHub", "publisher": { "@type": "Organization", "name": "GitHub", "url": "https://github.com" } } ] -- This message has been scanned for viruses and dangerous content by <http://www.mailscanner.info/> MailScanner, and is believed to be clean. -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.
Author
Owner

@bradleyf commented on GitHub (May 5, 2020):

I took a look again. It's my mistake. It was trying to connect via pgbouncer and the new db was not set up in pgbouncer yet. Sorry for the false alarm. I'm closing this issue.

<!-- gh-comment-id:624059660 --> @bradleyf commented on GitHub (May 5, 2020): I took a look again. It's my mistake. It was trying to connect via pgbouncer and the new db was not set up in pgbouncer yet. Sorry for the false alarm. I'm closing this issue.
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference: github-starred/pgadmin3#4
No description provided.