Re: BUG #5983: creating accounts - Mailing list pgsql-bugs

From John R Pierce
Subject Re: BUG #5983: creating accounts
Date
Msg-id 4DAA37C7.2030202@hogranch.com
Whole thread Raw
In response to BUG #5983: creating accounts  ("Yanish" <yanish_3008@hotmail.com>)
List pgsql-bugs
On 04/15/11 12:33 PM, Yanish wrote:
> The following bug has been logged online:
>
> Bug reference:      5983
> Logged by:          Yanish
> Email address:      yanish_3008@hotmail.com
> PostgreSQL version: 9.0
> Operating system:   Windows Seven 64-bit
> Description:        creating accounts
> Details:
>
> hello i have been using postgreSQL for my university studies and now i have
> a problem on windows seven as it is creating a new account called Postgres
> in my user account and it is shown on my welcome screen.why is it such??i
> dont want a new account to be able to use postgres..

the 'bug' here is that the 'postgres' service account its creating
became a member of 'Users', which it wasn't on XP.

the postgresql server does in fact need its own account to run the
database service, much like many other services do, its just the LSP
(local security policy) is configured to hide these accounts from the
'welcome' login screen.

go to control panel -> Administration Tools -> Computer Management.

In Computer Manaagement, find Local Users and Groups -> Users, and find
the 'postgres' user, right click, Properties, and select hte 'member of'
tab.   select Users and click Remove to remove Users from this list (it
should be empty, this account is to be used for NOTHING other than the
postgres database service).   click Ok, and close the dialogs.   Now,
Postgres should no longer show up on the Welcome screen when you log off.

pgsql-bugs by date:

Previous
From: Mark Kirkwood
Date:
Subject: Re: Massive memory use for star query
Next
From: "BORSCHNECK Pascal"
Date:
Subject: BUG #5984: Got FailedAssertion("!(opaque->btpo_prev == target)", File: "nbtpage.c", Line: 1166)