Обсуждение: pgadmin 1.4 + pgsql 8.1.0
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
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.
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/