Re: Improving backend startup interlock

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Improving backend startup interlock
Дата
Msg-id 7395.1033268767@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Improving backend startup interlock  (Giles Lean <giles@nemeton.com.au>)
Ответы Re: Improving backend startup interlock  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-hackers
Giles Lean <giles@nemeton.com.au> writes:
> I'm certainly no fan of NFS locking, but if someone trusts their NFS
> client and server implementations enough to put their data on, they
> might as well trust it to get a single lock file for startup right
> too.  IMHO.  Your mileage may vary.

Well, my local man page for lockf() sez
    The advisory record-locking capabilities of lockf() are implemented    throughout the network by the ``network lock
daemon''(see lockd(1M)).    If the file server crashes and is rebooted, the lock daemon attempts    to recover all
locksassociated with the crashed server.  If a lock    cannot be reclaimed, the process that held the lock is issued a
 SIGLOST signal.
 

and the lockd man page mentions that not only lockd but statd have to be
running locally *and* at the NFS server.

This sure sounds like file locking on NFS introduces additional
failure modes above and beyond what we have already.

Since the entire point of this locking exercise is to improve PG's
robustness, solutions that depend on other daemons not crashing
don't sound like a step forward to me.  I'm willing to trust the local
kernel, but I get antsy if I have to trust more than that.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Giles Lean
Дата:
Сообщение: Re: Improving backend startup interlock
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: NUMERIC's transcendental functions