pgAdmin4 - Multi-database Servers

From: Jack Royal-Gordon <jackrg(at)pobox(dot)com>
To: "pgadmin-support lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: pgAdmin4 - Multi-database Servers
Date: 2020-12-02 02:02:57
Message-ID: 78814151-BB7A-47B0-956C-B5730654E7B3@pobox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Richard Brockie 2020-12-02 02:45:15 Re: pgAdmin4 - Multi-database Servers
Previous Message Marcelo (Hotmail) 2020-12-01 17:54:02 Re: PGAdmin4 v4.28 Windows Chrome