Thread: How to have 2 connections, same server, different user?
While the main pgadmin console lets me define multiple connections to the same server in different roles, the SQL query window will not let me select them. Once I've selected a connection as a specific role (say, postgres:5488), then I cannot ever select a differently-roled connection as a different user (say, db_admin:5488) to the same database. I think this is probably simply a deficiency in the connection selector in the SQL window, which only displays IP:Port instead of the list of named connections available in the main console. Can anyone suggest a workaround? --Josh Berkus
On 26/02/2010 19:58, Josh Berkus wrote: > While the main pgadmin console lets me define multiple connections to > the same server in different roles, the SQL query window will not let me > select them. Once I've selected a connection as a specific role (say, > postgres:5488), then I cannot ever select a differently-roled connection > as a different user (say, db_admin:5488) to the same database. > > I think this is probably simply a deficiency in the connection selector > in the SQL window, which only displays IP:Port instead of the list of > named connections available in the main console. > > Can anyone suggest a workaround? You can run two copies of pgAdmin - on Windows, anyway. Would that solve it? Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@iol.ie
Le 26/02/2010 20:58, Josh Berkus a écrit : > While the main pgadmin console lets me define multiple connections to > the same server in different roles, the SQL query window will not let me > select them. Once I've selected a connection as a specific role (say, > postgres:5488), then I cannot ever select a differently-roled connection > as a different user (say, db_admin:5488) to the same database. > > I think this is probably simply a deficiency in the connection selector > in the SQL window, which only displays IP:Port instead of the list of > named connections available in the main console. > > Can anyone suggest a workaround? > Not sure how much work is needed to add this, but this is interesting enough to record it on our trac system. Check http://code.pgadmin.org/trac/ticket/144 to see if we make any progress on this. -- Guillaume.http://www.postgresqlfr.orghttp://dalibo.com