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 D38069DC869 for ; Wed, 22 Mar 2006 10:42:58 -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 66100-10 for ; Wed, 22 Mar 2006 10:43:02 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from hotmail.com (bay102-f18.bay102.hotmail.com [64.4.61.28]) by postgresql.org (Postfix) with ESMTP id 46C1F9DD598 for ; Wed, 22 Mar 2006 10:42:55 -0400 (AST) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Wed, 22 Mar 2006 06:42:59 -0800 Message-ID: Received: from 64.4.61.200 by by102fd.bay102.hotmail.msn.com with HTTP; Wed, 22 Mar 2006 14:42:54 GMT X-Originating-IP: [66.160.12.211] X-Originating-Email: [bitsandbytes88@hotmail.com] X-Sender: bitsandbytes88@hotmail.com From: "Mr. Dan" To: pgsql-admin@postgresql.org Subject: pgadmin 1.4 + pgsql 8.1.0 Date: Wed, 22 Mar 2006 09:42:54 -0500 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 22 Mar 2006 14:42:59.0931 (UTC) FILETIME=[EA752AB0:01C64DBE] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.588 required=5 tests=[AWL=-0.331, DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_POST=1.44, MSGID_FROM_MTA_HEADER=0] X-Spam-Score: 1.588 X-Spam-Level: * X-Archive-Number: 200603/208 X-Sequence-Number: 20965 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