Re: Revised patch for fixing archiver shutdown behavior

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Revised patch for fixing archiver shutdown behavior
Дата
Msg-id 5382.1199977991@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Revised patch for fixing archiver shutdown behavior  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: Revised patch for fixing archiver shutdown behavior  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: Revised patch for fixing archiver shutdown behavior  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-patches
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Something I'm still wondering is about the archiver/logger combination.
> What happens if a postmaster is stopped by the user and the archiver is
> still running, and the user starts a new postmaster?  This would launch
> a new archiver and logger; and there are now two loggers possibly
> writing to the same files, and truncated log lines could occur.

I'm not nearly as worried about that as I am about the prospect of
two concurrent archivers :-(

There was discussion of having a lock file for the archiver, but
it's still an open issue.  I'm not sure how to solve the problem
of stale lockfiles --- unlike the postmaster, the archiver can't
assume that it's the only live process with the postgres userid.
For example, after a system crash-and-restart, it's entirely
likely that the PID formerly held by the archiver is now held
by the bgwriter, making the lockfile (if any) look live.

Maybe we should go back to the plan of having the postmaster
wait for the archiver to exit.

            regards, tom lane

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

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: Re: reference problem of manifest.(win32.mak of libpq.dll)
Следующее
От: "Hiroshi Saito"
Дата:
Сообщение: Re: reference problem of manifest.(win32.mak of libpq.dll)