Re: Minimising windows installer password confusion

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Dave Page <dpage(at)pgadmin(dot)org>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Sachin Srivastava <sachin(dot)srivastava(at)enterprisedb(dot)com>, Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com>, Dharmendra Goyal <dharmendra(dot)goyal(at)enterprisedb(dot)com>
Subject: Re: Minimising windows installer password confusion
Date: 2012-06-13 01:18:58
Message-ID: 4FD7EA82.70808@postnewspapers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 06/12/2012 08:08 PM, Dave Page wrote:
> Some background: By default the installer will use 'postgres' for both
> the service (OS) account, and the database superuser account. It will
> use the same password for both (though, users have complete control at
> the command line if they want it, which is why the account names are
> shown in the installer). Unlike *nix installations, the service
> account must have a password, which is required during both
> installation and upgrade to configure the PostgreSQL service. We
> therefore ask for the password during both installation and upgrade.
> If the user account exists (which can happen if there has previously
> been an installation of Postgres on the system), the user must specify
> the existing password for the account during installation (and of
> course, during all upgrades). This is where users normally get stuck,
> as they've forgotten the password they set in the past.
They may not even have set it, because the EnterpriseDB installer can be
run unattended and may've been used by some 3rd party package.

I'd be interested in seeing what Microsoft installers that create
isolated user accounts do. I think .NET creates one for ASP, so that'd
be one option to look into.

--
Craig Ringer

POST Newspapers
276 Onslow Rd, Shenton Park
Ph: 08 9381 3088 Fax: 08 9388 2258
ABN: 50 008 917 717
http://www.postnewspapers.com.au/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 2012-06-13 01:45:25 Re: pg_dump and thousands of schemas
Previous Message Craig Ringer 2012-06-13 01:12:32 Re: Minimising windows installer password confusion