Postgres Pro
Downloads
Home   >   mailing lists

Re: hiding the postgres password - v8.1.0 - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: hiding the postgres password - v8.1.0
Date
Msg-id 20060320212343.GD15091@surnet.cl
Whole thread Raw
In response to hiding the postgres password - v8.1.0  ("Mr. Dan" <bitsandbytes88@hotmail.com>)
Responses Re: hiding the postgres password - v8.1.0
List pgsql-admin
Tree view 
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).

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-admin by date:

Previous
From: "Mr. Dan"
Date:
Subject: hiding the postgres password - v8.1.0
Next
From: Bruno Wolff III
Date:
Subject: Re: hiding the postgres password - v8.1.0