Re: 8.3 .4 + Vista + MingW + initdb = ACCESS_DENIED - Mailing list pgsql-hackers

From Magnus Hagander
Subject Re: 8.3 .4 + Vista + MingW + initdb = ACCESS_DENIED
Date
Msg-id 48F4B874.6000003@hagander.net
Whole thread Raw
In response to Re: 8.3 .4 + Vista + MingW + initdb = ACCESS_DENIED  ("Dave Page" <dpage@pgadmin.org>)
Responses Re: 8.3 .4 + Vista + MingW + initdb = ACCESS_DENIED
List pgsql-hackers
Dave Page wrote:
> On Tue, Oct 14, 2008 at 2:33 PM, Andrew Dunstan <andrew@dunslane.net> wrote:
>>
>> Dave Page wrote:
>>>> Well - building your own Postgres 8.3 on Windows using MingW appears
>>>> broken.
>>>>  Not sure how many people fall into that category, but its seems like a
>>>> fairly major issue.
>>>>
>>> Very few people build their own Postgres on Windows, because it's not
>>> exactly straightforward to do because of all the dependencies.
>>>
>>>
>> IMNSHO, it is not acceptable to leave CVS for any significant period in a
>> state where someone can't run "make check" by hand, and you certainly can't
>> assume that no-one will want to do so.
> 
> It's not the case that no one can run 'make check' - it's very much
> dependent on the configuration of the user account. Much as it pains
> me to say it, running as Administrator or a member of the
> Administrators group should normally work as you will inherit the
> required privileges.
> 
>> I can confirm that commenting out '+ 18' from the last loop of the offending
>> patch allows me to run and test on XP-Pro.
>>
>> What do we actually need to create this object in the global namespace?
> 
> The user running initdb (or the postmaster) needs
> SeCreateGlobalPrivilege - which is something we cannot really start
> telling people they must have. My view is that we revert the change
> (well, replace it with something that looks less like a broken attempt
> to use the global namespace) and leave it at that. iirc, the use of
> the global namespace is there to ensure things work as they should
> under a non-console terminal services session - which is pretty rare
> and can usually be avoided.

Not quite. The reason it's in the global namespace is to provide an
interlock preventing the starting of a postmaster in two different
sessions at the same time against the same data directory. We need to
figure out exactly how much this interlock is reduced, and if there is
something else we can do to make it work on Vista+...

//Magnus


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: WITH RECURSIVE ... CYCLE in vanilla SQL: issues with arrays of rows
Next
From: Magnus Hagander
Date:
Subject: Re: 8.3 .4 + Vista + MingW + initdb = ACCESS_DENIED