Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows

Поиск
Список
Период
Сортировка
Искать
От
Kyotaro Horiguchi
Тема
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows
Дата
Msg-id
20240606.171515.1237539015915565828.horikyota.ntt@gmail.com
Ответ на
Список
Дерево обсуждения
pg_ctl start may return 0 even if the postmaster has been already started on Windows "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows Michael Paquier <michael@paquier.xyz>
RE: pg_ctl start may return 0 even if the postmaster has been already started on Windows "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows Kyotaro Horiguchi <horikyota.ntt@gmail.com>
RE: pg_ctl start may return 0 even if the postmaster has been already started on Windows "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows Kyotaro Horiguchi <horikyota.ntt@gmail.com>
RE: pg_ctl start may return 0 even if the postmaster has been already started on Windows "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
RE: pg_ctl start may return 0 even if the postmaster has been already started on Windows "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows Kyotaro Horiguchi <horikyota.ntt@gmail.com>
RE: pg_ctl start may return 0 even if the postmaster has been already started on Windows "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows Shlok Kyal <shlok.kyal.oss@gmail.com>
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows Kyotaro Horiguchi <horikyota.ntt@gmail.com>
RE: pg_ctl start may return 0 even if the postmaster has been already started on Windows "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows Kyotaro Horiguchi <horikyota.ntt@gmail.com>
RE: pg_ctl start may return 0 even if the postmaster has been already started on Windows "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows Robert Haas <robertmhaas@gmail.com>
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows Michael Paquier <michael@paquier.xyz>
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows Robert Haas <robertmhaas@gmail.com>
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows Michael Paquier <michael@paquier.xyz>
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows Noah Misch <noah@leadboat.com>
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows Michael Paquier <michael@paquier.xyz>
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows Michael Paquier <michael@paquier.xyz>
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows Andrew Dunstan <andrew@dunslane.net>
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows Sutou Kouhei <kou@clear-code.com>
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows Yasir Shah <yasir.hussain.shah@gmail.com>
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows Yasir <yasir.hussain.shah@gmail.com>
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows Robert Haas <robertmhaas@gmail.com>
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows vignesh C <vignesh21@gmail.com>
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows Bryan Green <dbryan.green@gmail.com>
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows Bryan Green <dbryan.green@gmail.com>
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows Álvaro Herrera <alvherre@kurilemu.de>
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows Michael Paquier <michael@paquier.xyz>
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows Michael Paquier <michael@paquier.xyz>
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows Tom Lane <tgl@sss.pgh.pa.us>
At Thu, 06 Jun 2024 16:45:00 +0900 (JST), Kyotaro Horiguchi  wrote in 
> I have been thinking about this since then. At first, I thought it
> referred to FindFirstChangeNotification() and friends, and inotify on
> Linux. However, I haven't found a way to simplify the specified code
> area using those APIs.

By the way, the need to shift by 2 seconds to tolerate clock skew
suggests that the current launcher-postmaster association mechanism is
somewhat unreliable. Couldn't we add a command line option to
postmaster to explicitly pass a unique identifier (say, pid itself) of
the launcher? If it is not specified, the number should be the PID of
the immediate parent process.

This change avoids the need for the special treatment for Windows.

regards.

-- 
Kyotaro Horiguchi
NTT Open Source Software Center


В списке pgsql-hackers по дате отправления
От: Kyotaro Horiguchi
Дата:
От: Kyotaro Horiguchi
Дата:
FAQ