the postgres process is not killed when the postmaster is killed

From: 范国腾 <fanguoteng(at)highgo(dot)com>
To: "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: the postgres process is not killed when the postmaster is killed
Date: 2018-05-10 08:34:46
Message-ID: 9444e7902dbb495ba7640a9636bf069b@EX01.highgo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi,

Start a psql client to connect the postgres. Now we have the postmaster process and the postgres process as below:
postgres 2184 1 0 02:59 ? 00:00:00 /opt/HighGo/db/bin/postgres
postgres 2268 2184 0 04:08 ? 00:00:00 postgres: postgres highgo [local] idle

then run the “kill -9 2184” to kill the postmaster, all of the subprocess are killed except the postgres (PID 2268).

I could reproduce this issue every time.

If the process 2268 is still alive, pg_ctl start and pg_ctl stop will fail.

Is it a bug? What should I configure if I want all of the subprocess are killed?

Thanks
Steven

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2018-05-10 09:04:53 Re: the postgres process is not killed when the postmaster is killed
Previous Message Tom Lane 2018-05-09 22:46:04 Re: TOAST table repeatedly corrupted