Re: pgAdmin and sudo mode

Поиск
Список
Период
Сортировка
От Adam Pearson
Тема Re: pgAdmin and sudo mode
Дата
Msg-id A09FF13F31F4184D8DDD607B8197B98C6CC723@dcm1-exm-002.ofg.local
обсуждение исходный текст
Ответ на Re: pgAdmin and sudo mode  (Wim Bertels <wim.bertels@khleuven.be>)
Ответы Re: pgAdmin and sudo mode  (Wim Bertels <wim.bertels@khleuven.be>)
Список pgadmin-support
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.bertels@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"


В списке pgadmin-support по дате отправления:

Предыдущее
От: Wim Bertels
Дата:
Сообщение: Re: pgAdmin and sudo mode
Следующее
От: Wim Bertels
Дата:
Сообщение: Re: pgAdmin and sudo mode