From: Bruno Wolff III <bruno@wolff.to>
To: Mr. Dan <bitsandbytes88@hotmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: hiding the postgres password - v8.1.0
Date: Mon, 20 Mar 2006 16:47:13 -0600
Message-ID: <20060320224713.GB7291@wolff.to> (raw)
In-Reply-To: <20060320212343.GD15091@surnet.cl>
References: <BAY102-F12288959843580247B5F12D1DB0@phx.gbl>
<20060320212343.GD15091@surnet.cl>
On Mon, Mar 20, 2006 at 17:23:43 -0400,
Alvaro Herrera <alvherre@commandprompt.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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: bruno@wolff.to, bitsandbytes88@hotmail.com
Subject: Re: hiding the postgres password - v8.1.0
In-Reply-To: <20060320224713.GB7291@wolff.to>
References: <BAY102-F12288959843580247B5F12D1DB0@phx.gbl> <20060320212343.GD15091@surnet.cl> <20060320224713.GB7291@wolff.to>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox