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: Andreas Joseph Krogh <andreak(at)officenet(dot)no>
  • To: pgsql-hackers(at)postgresql(dot)org
  • Subject: Re: file-locking and postmaster.pid
  • Date: Thu, 25 May 2006 14:52:18 +0200
  • Message-id: <200605251452(dot)18327(dot)andreak(at)officenet(dot)no>

On Thursday 25 May 2006 14:35, korry wrote:
> > That's not workable, unless you want to assume that nothing on the
> > system except Postgres uses SysV semaphores.  Otherwise something else
> > could randomly gobble up the semid you want to use.  I don't care very
> > much for requiring a distinct semid to be hand-specified for each
> > postmaster on a machine, either.
>
> Yeah, that does suck.  Ok, naming problems seem to make semaphores
> useless.
>
> I'm back to byte-range locking, but if NFS is important and is truly
> unreliable, then that's out too.
>
> I've never had locking problems on NFS (probably because we tell our
> users not to use NFS), but now that I think about it, SMB locking is
> very unreliable so Win32 would be an issue too.

What I don't get is why everybody think that because one solution doesn't fit 
all needs on all platforms(or NFS), it shouldn't be implemented on those 
platforms it *does* work on. Why can't those platforms(like Linux) benefit 
from a better solution, if one exists? There are plenty of examples of 
software providing better solutions on platforms supporting more features.

-- 
Andreas Joseph Krogh <andreak(at)officenet(dot)no>
Senior Software Developer / Manager
gpg public_key: http://dev.officenet.no/~andreak/public_key.asc
------------------------+---------------------------------------------+
OfficeNet AS            | The most difficult thing in the world is to |
Hoffsveien 17           | know how to do a thing and to watch         |
PO. Box 425 Skøyen      | somebody else doing it wrong, without       |
0213 Oslo               | comment.                                    |
NORWAY                  |                                             |
Phone : +47 22 13 01 00 |                                             |
Direct: +47 22 13 10 03 |                                             |
Mobile: +47 909  56 963 |                                             |
------------------------+---------------------------------------------+



Home | Main Index | Thread Index

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