| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | "Mr(dot) Dan" <bitsandbytes88(at)hotmail(dot)com>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: hiding the postgres password - v8.1.0 |
| Date: | 2006-03-20 22:47:13 |
| Message-ID: | 20060320224713.GB7291@wolff.to |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Mon, Mar 20, 2006 at 17:23:43 -0400,
Alvaro Herrera <alvherre(at)commandprompt(dot)com> wrote:
> Mr. Dan wrote:
>
> > 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.
>
> See the docs for the .pgpass file, in the libpq section (Interfaces).
You also might consider using ident authentication if the scripts run on the
database server and the OS supports getting the id of who is connected to
a domain socket.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ben K. | 2006-03-20 22:56:57 | encoding question |
| Previous Message | Ivo Rossacher | 2006-03-20 22:31:43 | Re: Character encoding problems and dump import |