From: | Wim Bertels <wim(dot)bertels(at)khleuven(dot)be> |
---|---|
To: | Adam Pearson <Adam(dot)Pearson(at)4finance(dot)com> |
Cc: | "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: pgAdmin and sudo mode |
Date: | 2015-09-01 09:56:12 |
Message-ID: | 1441101372.3083.2.camel@khleuven.be |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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"
From | Date | Subject | |
---|---|---|---|
Next Message | Adam Pearson | 2015-09-01 11:01:07 | Re: pgAdmin and sudo mode |
Previous Message | Adam Pearson | 2015-09-01 08:49:52 | pgAdmin and sudo mode |