Re: How to deal with multiple accounts

2019-05-20 Thread Michel Feinstein
Thanks guys, this was very helpful :) On Sun, May 19, 2019 at 10:34 AM Jan Birk wrote: > Hi, > > For inspiration... > > We have/use a lot of clusters and databases in PGadmin. In PGadmin (the > users > view) it is organised by product (servergroups: > > server-group-product01 > - server-test-dat

Re: How to deal with multiple accounts

2019-05-19 Thread Jan Birk
Hi, For inspiration... We have/use a lot of clusters and databases in PGadmin. In PGadmin (the users view) it is organised by product (servergroups: server-group-product01 - server-test-database (cluster01) - server-pre-production (cluster02) - server-production (cluster03) server-group-product

Re: How to deal with multiple accounts

2019-05-19 Thread Doug Easterbrook
the setup with no password? what I mean by that is when adding in the server you are required to put in a user and a password and there is a little checkbox about ’saving password’. we don’t save password, so the user is prompted to enter it for each pgadmin connection. if all the databa

Re: How to deal with multiple accounts

2019-05-18 Thread Michel Feinstein
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 connectio

Re: How to deal with multiple accounts

2019-05-18 Thread Doug Easterbrook
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 call

Re: How to deal with multiple accounts

2019-05-18 Thread Michael Shapiro
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 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

How to deal with multiple accounts

2019-05-18 Thread Michel Feinstein
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 fo