[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Gnumed-devel] Re: New version Database

From: Karsten Hilbert
Subject: Re: [Gnumed-devel] Re: New version Database
Date: Tue, 26 Aug 2008 13:04:20 +0200
User-agent: Mutt/1.5.18 (2008-05-17)

On Tue, Aug 26, 2008 at 09:00:34AM +0200, RKI Andreas wrote:

>>> Can I have the edited so it will only ask the password
>>> one time?
>> No.
>> But you can pre-set the password for gm-dbo in the config
>> file(s).
>> Some leverage can perhaps also be had by setting up a .pgpass
>> file for users root and postgres.
> Comment: I agree with Rogerio that this handling of passwords is somehow
> awkward and I wished that there would be a simpler option to enable users
> to input a password only once.

This isn't being realistic, I believe:

1) the package maintainer can always sed the conf files to
   contain the password in which case it won't be asked at all

2) in a true production environment the
   will only be run once after which the upgrade scripts will
   be run whenever a database upgrade is in order -- for which
   the password will only be asked once anyways

3) if the database administrator so choses she can always pre-set
   the passwords in .pgpass and/or configure pg_hba.conf

OTOH I just thought of a way :-))   I'll be testing this for v10.

GPG key ID E4071346 @
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

reply via email to

[Prev in Thread] Current Thread [Next in Thread]