Thread: BUG #18361: systemd[1]: postgresql-16.service: Killing process 25992 (postgres) with signal SIGKILL.
BUG #18361: systemd[1]: postgresql-16.service: Killing process 25992 (postgres) with signal SIGKILL.
From
PG Bug reporting form
Date:
The following bug has been logged on the website: Bug reference: 18361 Logged by: Gena Makhomed Email address: makhomed@gmail.com PostgreSQL version: 16.2 Operating system: Rocky Linux release 9.3 Description: 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 ? # systemctl stop postgresql-16.service ; systemctl status postgresql-16.service ○ postgresql-16.service - PostgreSQL 16 database server Loaded: loaded (/usr/lib/systemd/system/postgresql-16.service; enabled; preset: disabled) Active: inactive (dead) since Sat 2024-02-24 12:47:19 UTC; 6ms ago Duration: 3.525s Docs: https://www.postgresql.org/docs/16/static/ Process: 26666 ExecStartPre=/usr/pgsql-16/bin/postgresql-16-check-db-dir ${PGDATA} (code=exited, status=0/SUCCESS) Process: 26671 ExecStart=/usr/pgsql-16/bin/postgres -D ${PGDATA} (code=exited, status=0/SUCCESS) Main PID: 26671 (code=exited, status=0/SUCCESS) CPU: 43ms Feb 24 12:47:15 postgres-16.example.net systemd[1]: Starting PostgreSQL 16 database server... Feb 24 12:47:15 postgres-16.example.net postgres[26671]: 2024-02-24 12:47:15.985 UTC [26671] LOG: redirecting log output to logging collector process Feb 24 12:47:15 postgres-16.example.net postgres[26671]: 2024-02-24 12:47:15.985 UTC [26671] HINT: Future log output will appear in directory "log". Feb 24 12:47:15 postgres-16.example.net systemd[1]: Started PostgreSQL 16 database server. 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.