| 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: | Whole Thread | Raw Message | 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
| 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 |