Skip site navigation (1) Skip section navigation (2)

Re: BUG #5475: Problem during Instalation

From: Sachin Srivastava <sachin(dot)srivastava(at)enterprisedb(dot)com>
To: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
Cc: Dave Page <dpage(at)pgadmin(dot)org>, Robert Haas <robertmhaas(at)gmail(dot)com>, Joel Henrique <joel(at)cefet-al(dot)br>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5475: Problem during Instalation
Date: 2010-06-09 09:26:41
Message-ID: 4C0F5E51.3030105@enterprisedb.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On 6/9/10 2:33 PM, Craig Ringer wrote:
> On 09/06/10 16:29, Dave Page wrote:
>    
>> On Wed, Jun 9, 2010 at 8:56 AM, Craig Ringer
>> <craig(at)postnewspapers(dot)com(dot)au>  wrote:
>>
>>      
>>> Only because the PostgreSQL system user account password is coupled to
>>> the account of the "postgres" user in the PostgreSQL database cluster
>>> (right?). I'm not at a Windows box right now so I can't test to see if
>>> altering the Pg role's password changes the system password or vice
>>> versa, but I'd be surprised if they did.
>>>        
>> It won't, but the point is that we have to ask for a password anyway
>> so we don't gain anything by not asking the user for one of them.
>>      
> The issue is that the user has to know if they've installed Pg before
> (and thus already have a "postgres" service account) or not. Some
> clearly don't, or have forgotten the service account password long ago.
>
>
> In general, users expect that an uninstall of an app will remove the
> app's configuration. Pg ... sort of ... does. It leaves the user account
> in place, though it created it in the first place. So the user has to
> know if Pg has been installed previously and if so what the service
> account password was. This demonstrably confuses people who try to
> uninstall and reinstall Pg to resolve issues (service account
> configuration related or other).
>    
If a user has admin rights, he can anytime change the password for an 
existing 'postgres' user account in case he doesn't remember the 
password anymore.

That said, i believe the text/prompt that asks for password in the 
installer is clear enough to avoid any confusion. Cant say people 
actually read all that though.



-- 
Regards,
Sachin Srivastava
EnterpriseDB <http://www.enterprisedb.com>, the Enterprise Postgres 
<http://www.enterprisedb.com> company.

In response to

Responses

pgsql-bugs by date

Next:From: Craig RingerDate: 2010-06-09 09:37:54
Subject: Re: BUG #5475: Problem during Instalation
Previous:From: Craig RingerDate: 2010-06-09 09:03:26
Subject: Re: BUG #5475: Problem during Instalation

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group