Ok, just to be clear then... I have one server (an AWS RDS instance, I think "cluster" would be the right postgresql term), running one database, with multiple roles and users inside it.
I am curious about your setup with no password, isn't this insecure? I am used to have several saved connections on MySQL Workbench, one for each role and database (cluster) type. For example: - Development Database with administrator privileges. - Development Database with user privileges. - Production Database with administrator privileges. - Production Database with user privileges. Whereas Production and Development are completely separate instances (cluster, database, RDS, whatever people call them these days). So inside pgAdmin, should I create a new "server" for each one of these, under the same database type "server group"? On Sun, May 19, 2019, 00:00 Doug Easterbrook <d...@artsman.com> wrote: > 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.* > mailto:d...@artsman.com <d...@artsman.com> > http://www.artsman.com > Phone (403) 650-1978 > > On May 18, 2019, at 3:19 PM, Michael Shapiro <mshapir...@gmail.com> wrote: > > I'd like to know how people do this as well. I have been creating new > Servers for each account. > > On Sat, May 18, 2019 at 5:16 PM Michel Feinstein < > michelfeinst...@gmail.com> wrote: > >> 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. >> > >
