Re: pg_ctl less than useful error message on windows when privileges wrong for postgres - Mailing list pgsql-hackers

From Dave Cramer
Subject Re: pg_ctl less than useful error message on windows when privileges wrong for postgres
Date
Msg-id 2C9A234A-9388-415C-9F46-49962D337D98@fastcrypt.com
Whole thread Raw
In response to Re: pg_ctl less than useful error message on windows when privileges wrong for postgres  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pg_ctl less than useful error message on windows when privileges wrong for postgres
List pgsql-hackers
On 21-Oct-08, at 5:24 PM, Tom Lane wrote:

> Dave Cramer <pg@fastcrypt.com> writes:
>> I have a client who mistakenly gave the postgres user on a windows
>> machine admin privileges.
>
>> This mistake results in the service being unable to start up due to
>> postgres refusing to start with admin privileges.
>
>> The error message from pg_ctl start -D bindir is PG_CTL.."could not
>> locate matching postgres executable"
>
> It's fairly hard to see how that mistake leads to that symptom.
> Can you poke a bit more into exactly what is happening?
>
find_my_exec returns -1 for a number of errors resulting in an error  
message much like above (wording is slightly different).

when I executed postgres.exe directly it complained of the user having  
admin privs

I removed admin privs from the pg user and pg_ctl worked fine.

I know it's not very specific, but fairly damning.

Dave



pgsql-hackers by date:

Previous
From: "Robert Haas"
Date:
Subject: Re: So what's an "empty" array anyway?
Next
From: Hannu Krosing
Date:
Subject: Re: Withdraw PL/Proxy from commitfest