Thanks for the response Wim, unfortunately creation of SuperUser accounts isn't something we're allowed to do (company policy) with the idea that there should only be this 1 superuser account that we sudo into for elevated permissions
-----Original Message----- From: Wim Bertels [mailto:wim.bert...@khleuven.be] Sent: 01 September 2015 10:56 AM To: Adam Pearson Cc: pgadmin-support@postgresql.org Subject: Re: [pgadmin-support] pgAdmin and sudo mode Hallo Adam, if you are a dba, probably what u are looking for is a superuser account. start pgadmin, in the sql window, type create user, select create user and hit the help/questionmark button sudo does not exist in sql mvg, Wim Adam Pearson schreef op di 01-09-2015 om 08:49 [+0000]: > Hello all, > > Does anyone know if you can use ‘sudo’ in pgAdmin? > > > > Currently my login doesn’t have full access to the system, when I sudo > into the admin account I can alter / drop / create objects / > permissions etc. > > > > I don’t know the sudo account password and the DevOps team don’t hand > this out (I’m a DBA) so when using pgAdmin options are fairly limited. > > > > I can run the commands in a psql console, but it kind of seems a shame > to lose the auto complete and ease of use of the gui when writing > scripts. > > > > Googling doesn’t appear to display any results and when looking at the > help file none of the start options appear to list this as an option. > > > > I’m running pgAdmin 1.20 on Windows 7. > > Servers are Linux. > > > > Any suggestions to this would be appreciated. > > > > Thanks, > > Adam > > > > > > -- mvg, Wim Bertels -- Wim Bertels Lector UC Leuven-Limburg -- Things past redress and now with me past care. -- William Shakespeare, "Richard II" -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
