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

On Mon, Feb 26, 2024 at 11:19 AM Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)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*