pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
pgadmin 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>
  2006-03-22 16:48 ` Re: pgadmin 1.4 + pgsql  8.1.0 Bruno Wolff III <bruno@wolff.to>
  2006-03-22 22:48 ` Re: pgadmin 1.4 + pgsql  8.1.0 Peter Eisentraut <peter_e@gmx.net>
  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 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>
  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 14:42 pgadmin 1.4 + pgsql  8.1.0 Mr. Dan <bitsandbytes88@hotmail.com>
@ 2006-03-22 22:48 ` Peter Eisentraut <peter_e@gmx.net>
  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