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

Re: Error starting service on Win2k

From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
To: "Conal Tuohy" <Conal(dot)Tuohy(at)vuw(dot)ac(dot)nz>,<pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Error starting service on Win2k
Date: 2004-09-20 18:40:37
Message-ID: 6BCB9D8A16AC4241919521715F4D8BCE4569F4@algol.sollentuna.se (view raw or flat)
Thread:
Lists: pgsql-bugs
>> You need two accounts. One administrator account that starts the
>> installer (this could be "Administrator" or cours e- 
>definitly no need
>> to create a special user for this). Another account which is 
>> used to run
>> the eventual installed postgres. This is the account that you 
>> specify on
>> the service account screen in the installer. This account 
>> MUST NOT be an
>> administrator.
>
>OK. It turns out that the problem there was that the installer 
>(postgresql-8.0-beta2-dev3.msi) actually created a user 
>account which WAS a member of "Power Users", because my "Power 
>Users" group included the group "NT AUTHORITY\Authenticated 
>Users" (according to the MS website [1], this is the default 
>configuration for Windows XP and Windows 2k Professional, 
>though NOT for Win2k Server or Win2003 Server). This setting 
>means that ANY new local account is AUTOMATICALLY a power 
>user. When I realised this I removed the "NT 
>AUTHORITY\Authenticated Users" from the "Power Users" local 
>group, and the installer ran perfectly.

That is an interesting note. I've never seen "Power Users" contain
Authenticated Users on any system I've installed, but the page certainly
claims it. 
However, it makes no claim about Windows XP that I can see. Only about
Windows 2000, and it shows the difference for the server platform.


>It would be better if the installer would detect this 
>situation, though, because users installing PostgreSQL on 
>WinXP or Win2k Professional with the default security setup 
>will otherwise find that the installer will create a user 
>account which then doesn't work, which is not a good start :-) 

Yes, if this ia  default in a bunch of installations, we certainly
should. I've added a tracker to the installer to check for htis, and
we'll try toget it in there before release. I will also add it to the
installer/windows FAQ.


//Magnus

pgsql-bugs by date

Next:From: Emerson Tobar SilvaDate: 2004-09-20 20:22:23
Subject: Function Round() on 7.3 and 7.4
Previous:From: Magnus HaganderDate: 2004-09-20 18:31:57
Subject: Re: psql can not connect to the server on Win2000 NT

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