Re: file-locking and postmaster.pid

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: file-locking and postmaster.pid
Дата
в 17:35:04
Msg-id
1623.1148502887@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
file-locking and postmaster.pid Andreas Joseph Krogh <andreak@officenet.no>
Re: file-locking and postmaster.pid korry <korry@appx.com>
Re: file-locking and postmaster.pid Andreas Joseph Krogh <andreak@officenet.no>
Re: file-locking and postmaster.pid korry <korry@appx.com>
Re: file-locking and postmaster.pid Alvaro Herrera <alvherre@commandprompt.com>
Re: file-locking and postmaster.pid korry <korry@appx.com>
Re: file-locking and postmaster.pid Alvaro Herrera <alvherre@commandprompt.com>
Re: file-locking and postmaster.pid korry <korry@appx.com>
Re: file-locking and postmaster.pid Alvaro Herrera <alvherre@commandprompt.com>
Re: file-locking and postmaster.pid korry <korry@appx.com>
Re: file-locking and postmaster.pid Alvaro Herrera <alvherre@commandprompt.com>
Re: file-locking and postmaster.pid korry <korry@appx.com>
Re: file-locking and postmaster.pid Tom Lane <tgl@sss.pgh.pa.us>
Re: file-locking and postmaster.pid Tom Lane <tgl@sss.pgh.pa.us>
Re: file-locking and postmaster.pid Tom Lane <tgl@sss.pgh.pa.us>
Re: file-locking and postmaster.pid korry <korry@appx.com>
Re: file-locking and postmaster.pid Tom Lane <tgl@sss.pgh.pa.us>
Re: file-locking and postmaster.pid korry <korry@appx.com>
Re: file-locking and postmaster.pid Tom Lane <tgl@sss.pgh.pa.us>
Re: file-locking and postmaster.pid korry <korry@appx.com>
Re: file-locking and postmaster.pid Tom Lane <tgl@sss.pgh.pa.us>
Re: file-locking and postmaster.pid korry <korry@appx.com>
Re: file-locking and postmaster.pid Andreas Joseph Krogh <andreak@officenet.no>
Re: file-locking and postmaster.pid Tom Lane <tgl@sss.pgh.pa.us>
Re: file-locking and postmaster.pid Andrew Dunstan <andrew@dunslane.net>
Re: file-locking and postmaster.pid Alvaro Herrera <alvherre@commandprompt.com>
Re: file-locking and postmaster.pid Alvaro Herrera <alvherre@commandprompt.com>
Re: file-locking and postmaster.pid Andrew Dunstan <andrew@dunslane.net>
Re: file-locking and postmaster.pid Alvaro Herrera <alvherre@commandprompt.com>
Re: file-locking and postmaster.pid Tom Lane <tgl@sss.pgh.pa.us>
Re: file-locking and postmaster.pid Andreas Joseph Krogh <andreak@officenet.no>
Re: file-locking and postmaster.pid Tom Lane <tgl@sss.pgh.pa.us>
Re: file-locking and postmaster.pid Adis Nezirovic <adis@linux.org.ba>
Re: file-locking and postmaster.pid Tom Lane <tgl@sss.pgh.pa.us>
Re: file-locking and postmaster.pid Adis Nezirovic <adis@linux.org.ba>
Re: file-locking and postmaster.pid Andreas Joseph Krogh <andreak@officenet.no>
Re: file-locking and postmaster.pid Andreas Joseph Krogh <andreak@officenet.no>
Re: file-locking and postmaster.pid "Andrej Ricnik-Bay" <andrej.groups@gmail.com>
Re: file-locking and postmaster.pid Andreas Joseph Krogh <andreak@officenet.no>
Alvaro Herrera  writes:
> Certainly on all platforms there must be *some* locking primitive.  We
> just need to figure out the appropiate parameters to fcntl() or flock()
> or lockf() on each.

Quite aside from the hassle factor of needing to deal with N variants of
the syscalls, I'm not convinced that it's guaranteed to work.  ISTR that
for instance NFS file locking is pretty much Alice-in-Wonderland :-(

Since the entire point here is to have a guaranteed bulletproof check,
locks that work most of the time on most platforms/filesystems aren't
gonna be an improvement.
		regards, tom lane

В списке pgsql-hackers по дате отправления
От: Alvaro Herrera
Дата:
От: Josh Berkus
Дата:
FAQ