Re: 8.3 .4 + Vista + MingW + initdb = ACCESS_DENIED

Andrew Dunstan wrote:
>
>
> Dave Page wrote:
>>> The reason it should be in the Global namespace is that shmem is one 
>>> part of
>>> detecting an existing postmaster. Especially in situations where the 
>>> db is started
>>> by hand, the protection against duplicate startup is important.
>>>     
>>
>> Yeah, as Magnus reminded me.
>>   
>
> IMNSHO we need to find a different exclusion mechanism that isn't as 
> cumbersome and surrounded by caveats as this one.
>
> The buildfarm also uses an exclusion mechanism, based on Perl's 
> flock(), and it's a simple one line call. AFAIK that works just fine 
> on Windows (I will double check). If so, we should possibly look at 
> how Perl does that on Windows.

I have verified that it does indeed work. Underneath the hood it uses 
the native call LockFileEx() see win32io.c in Perl source. I suggest we 
should switch from this flaky use of Global namespace to having the 
postmaster acquire an explicit lock on a file in the datadir.

cheers

andrew