Re: How to automate password requests?

From: "Andrej Ricnik-Bay" <andrej(dot)groups(at)gmail(dot)com>
To: "Marten Lehmann" <lehmann(at)cnm(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to automate password requests?
Date: 2008-01-11 00:16:46
Message-ID: b35603930801101616q7ac05efbn19d262dabb4c0557@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 11/01/2008, Marten Lehmann <lehmann(at)cnm(dot)de> wrote:

> is there no way to specify the password directly? I don't like to create
> a separate file because all config is done in a shell script. I could
> set a certain environment variable with the password, but does pgadmin
> read a password from such a variable? If yes, what is its name?
This is generally a bad idea, because on many systems one can
see the environment variables with which a process was started
in ps' output.
It shouldn't be too hard for your config-script to echo the proper
parameters into ~/.pgpass . You best forget about the thought
of having a shell variable with the password ;}

> Regards
> Marten
Cheers,
Andrej

--
Please don't top post, and don't use HTML e-Mail :} Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martin Gainty 2008-01-11 00:17:16 Re: How to automate password requests?
Previous Message Tom Lane 2008-01-11 00:00:29 Re: 8.2.4 serious slowdown