the postgres process is not killed when the postmaster is killed

Поиск
Список
Период
Сортировка
От 范国腾
Тема the postgres process is not killed when the postmaster is killed
Дата
Msg-id 9444e7902dbb495ba7640a9636bf069b@EX01.highgo.com
обсуждение исходный текст
Ответы Re: the postgres process is not killed when the postmaster is killed  (Michael Paquier <michael@paquier.xyz>)
Список 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

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: TOAST table repeatedly corrupted
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: the postgres process is not killed when the postmaster is killed