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 637C69DCB65 for ; Wed, 22 Mar 2006 18:48:07 -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 76722-04 for ; Wed, 22 Mar 2006 18:48:09 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id D2C299DCB5D for ; Wed, 22 Mar 2006 18:48:04 -0400 (AST) Received: (qmail invoked by alias); 22 Mar 2006 22:48:06 -0000 Received: from dslb-084-063-033-192.pools.arcor-ip.net (EHLO colt.pezone.net) [84.63.33.192] by mail.gmx.net (mp024) with SMTP; 22 Mar 2006 23:48:06 +0100 X-Authenticated: #495269 From: Peter Eisentraut To: pgsql-admin@postgresql.org Subject: Re: pgadmin 1.4 + pgsql 8.1.0 Date: Wed, 22 Mar 2006 23:48:03 +0100 User-Agent: KMail/1.8.3 Cc: "Mr. Dan" References: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200603222348.05132.peter_e@gmx.net> X-Y-GMX-Trusted: 0 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.13 required=5 tests=[AWL=0.130] X-Spam-Score: 0.13 X-Spam-Level: X-Archive-Number: 200603/214 X-Sequence-Number: 20971 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/