public inbox for [email protected]  

help / color / mirror / Atom feed

From: Gena Makhomed <[email protected]>
To: Laurenz Albe <[email protected]>
Cc: [email protected]
Subject: Re: systemd[1]: postgresql-16.service: Killing process 25992 (postgres) with signal SIGKILL.
Date: Tue, 27 Feb 2024 23:34:10 +0200
Message-ID: <CAKYxhB=HZTxOQv=BJqENK+4Mbuyv2v0qmq66HZxZqnM0-1ZMCg@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<CAKYxhBmpx8-ch_38EprbEMu3G3sYm=-eZUySLzW5xP3B1bexuw@mail.gmail.com>
	<[email protected]>

On Mon, Feb 26, 2024 at 11:19 AM Laurenz Albe <[email protected]>
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*

view thread (5+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: systemd[1]: postgresql-16.service: Killing process 25992 (postgres) with signal SIGKILL.
  In-Reply-To: <CAKYxhB=HZTxOQv=BJqENK+4Mbuyv2v0qmq66HZxZqnM0-1ZMCg@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox