Re: systemd[1]: postgresql-16.service: Killing process 25992 (postgres) with signal SIGKILL.

Поиск
Список
Период
Сортировка
От Gena Makhomed
Тема Re: systemd[1]: postgresql-16.service: Killing process 25992 (postgres) with signal SIGKILL.
Дата
Msg-id CAKYxhB=HZTxOQv=BJqENK+4Mbuyv2v0qmq66HZxZqnM0-1ZMCg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: systemd[1]: postgresql-16.service: Killing process 25992 (postgres) with signal SIGKILL.  (Laurenz Albe <laurenz.albe@cybertec.at>)
Ответы Re: systemd[1]: postgresql-16.service: Killing process 25992 (postgres) with signal SIGKILL.  (Devrim Gündüz <devrim@gunduz.org>)
Список pgsql-pkg-yum
On Mon, Feb 26, 2024 at 11:19 AM Laurenz Albe <laurenz.albe@cybertec.at> wrote:

> Bug reference:      18361
> PostgreSQL version: 16.2
> Operating system:   Rocky Linux release 9.3
>
> PostgreSQL 16.2 installed on the Rocky Linux release 9.3 server from
> official repository with official instruction from page
> https://www.postgresql.org/download/linux/redhat/
>
> when I execute command
>
> # systemctl stop postgresql-16.service ; systemctl status
> postgresql-16.service
>
> I see, what PostgreSQL 16.2 was killed by SIGKILL.
>
> this is a bug, as I understand, because database will be corrupted.
>
> Is it possible to fix this bug and stop killing PostgreSQL with signal
> SIGKILL ?
>
> Feb 24 12:47:19 postgres-16.example.net systemd[1]: Stopping PostgreSQL 16 database server...
> Feb 24 12:47:19 postgres-16.example.net systemd[1]: postgresql-16.service: Killing process 26672 (postgres) with signal SIGKILL.
> Feb 24 12:47:19 postgres-16.example.net systemd[1]: postgresql-16.service: Deactivated successfully.
> Feb 24 12:47:19 postgres-16.example.net systemd[1]: Stopped PostgreSQL 16 database server.

Strange.  In my "postgresql-16.service", I find

  TimeoutStopSec=1h

which should make systemd wait for an hour after sending SIGTERM before it
uses SIGKILL.  Is your setting different?

No, I do not change anything in the postgresql-16.service file, I just install Postgres 16.2 on the virtual machine with Rocky Linux 9.3, using detailed step-by step instruction, provided on the page https://www.postgresql.org/download/linux/redhat/ for Rocky Linux 9 and execute:

# systemctl start postgresql-16.service ; systemctl status

wait some time, and when - execute this command:

# systemctl stop postgresql-16.service ; systemctl status
and got result:

postgresql-16.service: Killing process 26672 (postgres) with signal SIGKILL.

Is it possible to avoid this SIGKILL ?


--
Please consider the environment before printing

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

Предыдущее
От: Devrim Gündüz
Дата:
Сообщение: Installing PostgreSQL on SLES 15 just got easier – and better!
Следующее
От: Devrim Gündüz
Дата:
Сообщение: Re: systemd[1]: postgresql-16.service: Killing process 25992 (postgres) with signal SIGKILL.