Re: PSA: Systemd will kill PostgreSQL

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: PSA: Systemd will kill PostgreSQL
Дата
Msg-id 11841.1471361061@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: PSA: Systemd will kill PostgreSQL  (Magnus Hagander <magnus@hagander.net>)
Ответы Re: PSA: Systemd will kill PostgreSQL  (Magnus Hagander <magnus@hagander.net>)
Re: PSA: Systemd will kill PostgreSQL  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Список pgsql-hackers
Magnus Hagander <magnus@hagander.net> writes:
> On Aug 16, 2016 5:11 PM, "Tom Lane" <tgl@sss.pgh.pa.us> wrote:
>> Dunno, it was still working the last time I used Fedora for anything much.
>> Admittedly, that was about three years ago.  But the issue would still
>> arise if you prefer "pg_ctl start".

> There are two independent changes AFAIK. One is that whenever a user that
> logged in interactively logs out all their processes are killed, regardless
> of nohup. The other one is the one about shared memory mentioned here. They
> will both independently kill postgres sessions launched manually. Or with
> pg_ctl.

Not sure I believe that --- the cases that have been reported to us
involved postgres processes that were still alive but had had their
SysV semaphore sets deleted out from under them.  Likely the SysV
shmem segments too, but that wouldn't cause any observable effects
for the running cluster.  (It *would* risk breaking the interlock
against starting a new postmaster, I fear.)

It might be that both behaviors exist now but more people know about
how to turn off the killing-processes one.
        regards, tom lane



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

Предыдущее
От: Anastasia Lubennikova
Дата:
Сообщение: Re: Re: GiST optimizing memmoves in gistplacetopage for fixed-size updates [PoC]
Следующее
От: Aleksander Alekseev
Дата:
Сообщение: Re: [GENERAL] C++ port of Postgres