I've got 2 heroku databases up and running, one free "Hobby Dev", and one production "Standard 0".
To only address the "Hobby Dev" rather than pick from the long list, I've added the database name to the "DB restriction" field on the Advanced tab of the connection menu. I didn't have to do this for the "Standard 0" database for some reason.
R.
On Tue, Dec 1, 2020 at 6:03 PM Jack Royal-Gordon <jackrg@pobox.com> wrote:
I am using Heroku to host a number of apps. Some of them have PG databases that are on shared servers. When that happens, there could be hundreds of databases on a single server (each with a randomly-generated name), but only one of them is the one I’m interested in (and that’s the only one that I have access to).
When I add the database to pgAdmin4, I provide the host address, username, password, and database name. But there seems to be no way to directly open a connection to that database. I must first open the server, then click on “Databases”, then find my database from among the hundreds listed, and only then can I establish a connection to the database.
Is there a shortcut to just use the connection info that I have provided to go straight to the database? If not, then I would suggest that such a feature ought to be fast-tracked. For example, you might add a “Open database xxx” command to the context menu on the server, where the “xxx” is the database name.
Another option would be to use the server credentials to determine which databases I have access to, and only list the ones that are available to me. If you don’t want this behavior to apply to all databases, then add a flag on the “Advanced” tab of the server properties that would toggle between this behavior and the current behavior.