pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpgadmin 1.4 + pgsql 8.1.0
3+ messages / 3 participants
[nested] [flat]
* pgadmin 1.4 + pgsql 8.1.0
@ 2006-03-22 14:42 Mr. Dan <bitsandbytes88@hotmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: Mr. Dan @ 2006-03-22 14:42 UTC (permalink / raw)
To: pgsql-admin
Hi,
Pgadmin is amazing. You can log on with a user account that's been
authenticated through Linux PAM and then run a command like pg_dump or
createdb that you wouldn't have access to run on the linux command line as
long as postgres approves that access. Is there a way to bring that power
to the command line? If I log into a server as a certain user who doesn't
have the access that the postgres user has, can I use or access postres
someway to check that a superuser has given that access in postrres and if
it has wrap around the postgres user account (like what happens with
pgadmin) and execute the command like createdb?
Is there a web based version of pgadmin? Is the source available for
pgadmin?
Thanks,
~DjK
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: pgadmin 1.4 + pgsql 8.1.0
@ 2006-03-22 16:48 Bruno Wolff III <bruno@wolff.to>
parent: Mr. Dan <bitsandbytes88@hotmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Bruno Wolff III @ 2006-03-22 16:48 UTC (permalink / raw)
To: Mr. Dan <bitsandbytes88@hotmail.com>; +Cc: pgsql-admin
On Wed, Mar 22, 2006 at 09:42:54 -0500,
"Mr. Dan" <bitsandbytes88@hotmail.com> wrote:
> Hi,
>
> Pgadmin is amazing. You can log on with a user account that's been
> authenticated through Linux PAM and then run a command like pg_dump or
> createdb that you wouldn't have access to run on the linux command line as
> long as postgres approves that access. Is there a way to bring that power
> to the command line? If I log into a server as a certain user who doesn't
> have the access that the postgres user has, can I use or access postres
> someway to check that a superuser has given that access in postrres and if
> it has wrap around the postgres user account (like what happens with
> pgadmin) and execute the command like createdb?
>
> Is there a web based version of pgadmin? Is the source available for
> pgadmin?
It is possible to do things like this. Probably some mix of ident
authentication and sudo would work.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: pgadmin 1.4 + pgsql 8.1.0
@ 2006-03-22 22:48 Peter Eisentraut <peter_e@gmx.net>
parent: Mr. Dan <bitsandbytes88@hotmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Peter Eisentraut @ 2006-03-22 22:48 UTC (permalink / raw)
To: pgsql-admin; +Cc: Mr. Dan <bitsandbytes88@hotmail.com>
Mr. Dan wrote:
> Pgadmin is amazing. You can log on with a user account that's been
> authenticated through Linux PAM and then run a command like pg_dump
> or createdb that you wouldn't have access to run on the linux command
> line as long as postgres approves that access.
PgAdmin doesn't have any special powers. If you can log in via pgAdmin,
you can also run pg_dump. If you can't get superuser privileges for
pg_dump, you also can't get them in pgAdmin.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2006-03-22 22:48 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-03-22 14:42 pgadmin 1.4 + pgsql 8.1.0 Mr. Dan <bitsandbytes88@hotmail.com>
2006-03-22 16:48 ` Bruno Wolff III <bruno@wolff.to>
2006-03-22 22:48 ` Peter Eisentraut <peter_e@gmx.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox