Andrew Dunstan wrote:
> 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.
Does it work for all backends to grab a lock, so that if they continue
to live after postmaster has died, then the new postmaster cannot start?
I guess the postmaster could try-acquire an exclusive lock and all other
processes would acquire a shared lock.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.