Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: file-locking and postmaster.pid


  • From: korry <korry(at)appx(dot)com>
  • To: Andreas Joseph Krogh <andreak(at)officenet(dot)no>
  • Cc: pgsql-hackers(at)postgresql(dot)org
  • Subject: Re: file-locking and postmaster.pid
  • Date: Wed, 24 May 2006 16:01:43 -0400
  • Message-id: <1148500903(dot)21335(dot)51(dot)camel(at)sakai(dot)localdomain>

On Wednesday 24 May 2006 21:03, korry wrote:
> > I'm sure there's a good reason for having it the way it is, having so
> > many smart knowledgeable people working on this project. Could someone
> > please explain the rationale of the current solution to me?
>
> We've ignored Andreas' original question.  Why not use a lock to
> indicate that the postmaster is still running?  At first blush, that
> seems more reliable than checking for a (possibly recycled) process ID.

As Tom replied: Portability.

Thanks - I missed that part of Tom's message.


The only platform (although certainly not a minor issue) that I can think of that would have a portability issue would be Win32. You can't even read a locked byte in Win32.  I usually solve that problem by locking a byte past the end of the file (which is portable).

Is there some other portability issue that I'm missing?


            -- Korry




Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group