Re: pgAdmin4 - Multi-database Servers

Hi Richard,

That worked like a charm. Thanks!

> On Dec 1, 2020, at 6:45 PM, Richard Brockie <richard(dot)brockie(at)gmail(dot)com> wrote:
>
> Hi Jack,
>
> 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(at)pobox(dot)com <mailto:jackrg(at)pobox(dot)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.
>
> Regards,
>
> Jack
>
>
>
> --
> R.
>
> Richard Brockie
>
> Real-time bicycle race management - www.ontheday.net <http://www.ontheday.net/>