if by ’server’, you mean a new instance of pgadmin talking to a database .. no,. you can get away with one copy of pgadmin talking to multiple databases.
if by server, you mean you open pgadmin, create a new server group, you don’t need to do that either. Since server groups can be called whatever you want, you could use server groups, I suppose, to define people so that there is a list of people. … mostly we use them for location — to group the various physical servers or locations that we go to.
if by server, you mean database — it makes it easier on users it you make a new database with their user id in it and no password. You can also name the server with the person’s name or function so thats its easier to identify which they should pick
but there is no getting around just double licking on a single server and entering a username/password — its just the way pgadmin seems to have been designed for eons.
personally, I like that it saves my user id — and I supply the password..
thats how we use it.
Doug Easterbrook
Arts Management Systems Ltd.
Phone (403) 650-1978
I'd like to know how people do this as well. I have been creating new Servers for each account.
Hi guys, I am looking for opinions on how you use pgAdmin for dealing with several accounts.
For example, I have an "admin" account with all the privileges for the database and a "restricted" account for my application to use. I also have some other accounts for other purposes and I was looking for a convenient way to log into those accounts and use pgAdmin with their privileges.
In MySQL Workbench this was fairly simple, since you configure Connections, but in pgAdmin you configure Servers instead, and all those accounts are new connections to the same Server.
So do you guys just create a new Server for each account/login on pgAdmin, or do you have some other trick on how to deal this this?
Best wishes,
Michel.