X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 93DE79DD58C for ; Wed, 22 Mar 2006 12:47:06 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 89500-07 for ; Wed, 22 Mar 2006 12:47:05 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from wolff.to (wolff.to [66.93.197.194]) by postgresql.org (Postfix) with SMTP id 7B3719DD586 for ; Wed, 22 Mar 2006 12:47:03 -0400 (AST) Received: (qmail 15544 invoked by uid 500); 22 Mar 2006 16:48:40 -0000 Date: Wed, 22 Mar 2006 10:48:40 -0600 From: Bruno Wolff III To: "Mr. Dan" Cc: pgsql-admin@postgresql.org Subject: Re: pgadmin 1.4 + pgsql 8.1.0 Message-ID: <20060322164840.GA13750@wolff.to> Mail-Followup-To: Bruno Wolff III , "Mr. Dan" , pgsql-admin@postgresql.org References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.4.2.1i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.242 required=5 tests=[AWL=-0.034, MAILTO_TO_SPAM_ADDR=0.276] X-Spam-Score: 0.242 X-Spam-Level: X-Archive-Number: 200603/210 X-Sequence-Number: 20967 On Wed, Mar 22, 2006 at 09:42:54 -0500, "Mr. Dan" 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.