Tom Lane writes:
$ man flock
No manual entry for flock.
$
HPUX has generally taken the position of adopting both BSD and SysV
features, so if it doesn't exist here, it's not portable to older
Unixen ...
If only local locking is at issue then finding any one of fcntl()
locking, flock(),
Giles Lean [EMAIL PROTECTED] wrote:
Tom Lane writes:
$ man flock
No manual entry for flock.
$
HPUX has generally taken the position of adopting both BSD and SysV
features, so if it doesn't exist here, it's not portable to older
Unixen ...
If only local locking is at issue
Michael Paesold wrote:
Giles Lean [EMAIL PROTECTED] wrote:
Mind you NFS users are currently entirely unprotected from someone
starting a postmaster on a different NFS client using the same data
directory right now, which file locking would prevent. So there is
some win for NFS users as well as
Have people considered flock (advisory locking) on the postmaster.pid
file for backend detection? It has a nonblocking option. Don't most
OS's support it?
I can't understand why we can't get an easier solution to postmaster
detection than shared memory.
Bruce Momjian [EMAIL PROTECTED] writes:
Have people considered flock (advisory locking) on the postmaster.pid
file for backend detection?
$ man flock
No manual entry for flock.
$
HPUX has generally taken the position of adopting both BSD and SysV
features, so if it doesn't exist here, it's
Tom Lane wrote:
[ discussion of new startup interlock ]
This is not quite ready for prime time yet, because it's not very
bulletproof against the scenario where two would-be postmasters are
starting concurrently.
A solution to this is to require would-be postmasters to obtain an
exclusive
Giles Lean [EMAIL PROTECTED] writes:
Is there some reason that file locking is not acceptable? Is there
any platform or filesystem supported for use with PostgreSQL which
doesn't have working exclusive file locking?
How would we know? We have never tried to use such a feature.
For sure I
Tom Lane wrote:
Giles Lean [EMAIL PROTECTED] writes:
Is there some reason that file locking is not acceptable? Is there
any platform or filesystem supported for use with PostgreSQL which
doesn't have working exclusive file locking?
How would we know? We have never tried to use such