hiding the postgres password - v8.1.0

From: "Mr(dot) Dan" <bitsandbytes88(at)hotmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: hiding the postgres password - v8.1.0
Date: 2006-03-20 21:19:30
Message-ID: BAY102-F12288959843580247B5F12D1DB0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Alvaro Herrera 2006-03-20 21:23:43 Re: hiding the postgres password - v8.1.0
Previous Message ogjunk-pgjedan 2006-03-20 20:21:35 Character encoding problems and dump import