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 1AF949DCC91 for ; Mon, 20 Mar 2006 17:19:36 -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 78746-03 for ; Mon, 20 Mar 2006 17:19:36 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from hotmail.com (bay102-f12.bay102.hotmail.com [64.4.61.22]) by postgresql.org (Postfix) with ESMTP id 3D7D09DCC84 for ; Mon, 20 Mar 2006 17:19:31 -0400 (AST) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Mon, 20 Mar 2006 13:19:32 -0800 Message-ID: Received: from 64.4.61.200 by by102fd.bay102.hotmail.msn.com with HTTP; Mon, 20 Mar 2006 21:19:30 GMT X-Originating-IP: [66.160.12.215] X-Originating-Email: [bitsandbytes88@hotmail.com] X-Sender: bitsandbytes88@hotmail.com From: "Mr. Dan" To: pgsql-admin@postgresql.org Subject: hiding the postgres password - v8.1.0 Date: Mon, 20 Mar 2006 16:19:30 -0500 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 20 Mar 2006 21:19:32.0848 (UTC) FILETIME=[FB50AF00:01C64C63] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.593 required=5 tests=[AWL=-0.326, DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_POST=1.44, MSGID_FROM_MTA_HEADER=0] X-Spam-Score: 1.593 X-Spam-Level: * X-Archive-Number: 200603/181 X-Sequence-Number: 20938 Hi, Is there a way to hide or encrypt the postgres password when the postgres user is required to be the user in a shell script? This way we could have a function called in a program, and the users could do something with out actually seeing the postgres user password. We have tried putting the postgres user password in a perl script, however when we run the script we get password coming up interactively as the perl script is running doing a pg_dump or createdb for example. We want regular users to be able to pg_dump, drop, create, vacuum etc. Postgres is the owner of our data directory. The group permission are in a sys - admin group. Thanks for any feedback, ~DjK