Re: BUG #6140: PostgreSQL Server Service Not Starting

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Steve Boyd <sboyd67(at)yahoo(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6140: PostgreSQL Server Service Not Starting
Date: 2011-08-04 01:16:41
Message-ID: 4E39F2F9.6040300@postnewspapers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 3/08/2011 7:20 AM, Craig Ringer wrote:
> On 2/08/2011 8:01 PM, Steve Boyd wrote:
>
>> "could not open process token: error code 5"
>>
>> The service account is in the local administrators group and has full
>> control over the data directory.
>
> AFAIK PostgreSQL service account should *NOT* be part of the local
> administrators group.
>
> That said, the fact that it fails so ungracefully is definitely a bug
> that bears investigation.

An on-list follow-up:

Removing the Pg service account from local admins resolved Steve's problem.

Pg should really fail more gracefully and informatively - or not fail to
launch at all - in this case. It involves Win32 API programming, though....

--
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

Browse pgsql-bugs by date

  From Date Subject
Next Message Craig Ringer 2011-08-04 01:21:17 Re: BUG #6143: connection problem
Previous Message Craig Ringer 2011-08-04 00:06:40 Re: BUG #6140: PostgreSQL Server Service Not Starting