Re: pgAdmin and sudo mode

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(dot)bertels(at)khleuven(dot)be]
Sent: 01 September 2015 10:56 AM
To: Adam Pearson
Cc: pgadmin-support(at)postgresql(dot)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"