Re: 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"