Re: [GENERAL] Shutting down a warm standby database in 8.2beta3

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [GENERAL] Shutting down a warm standby database in 8.2beta3
Дата
Msg-id 7306.1164040204@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [GENERAL] Shutting down a warm standby database in 8.2beta3  ("Magnus Hagander" <mha@sollentuna.net>)
Ответы Re: [GENERAL] Shutting down a warm standby database in 8.2beta3  ("Magnus Hagander" <mha@sollentuna.net>)
Список pgsql-hackers
"Magnus Hagander" <mha@sollentuna.net> writes:
> I haven't really been folliowing this thread. What exactly is it you
> want to accomplish (maybe there is a different way to fix it on win32)?
> Kill a process along with all it's subprocesses?

Right.  The problem (as seen on Unix) is that if the recovery subprocess
is waiting for a recovery_command script to complete, it doesn't react
to SIGQUIT (because system() ignores SIGQUIT) and the script doesn't
react either (because it never gets the signal at all).  We'd like
"pg_ctl stop -m immediate" to abort the script and then have the
recovery process fail, allowing restart later.  More generally, it
seems like any time a backend is executing system(), the called script
ought to be subject to SIGINT or SIGQUIT signals sent to the backend
by the postmaster.
        regards, tom lane


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

Предыдущее
От: "Simon Riggs"
Дата:
Сообщение: Re: [PATCHES] Transaction start in pg_stat_activity
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [PATCHES] Transaction start in pg_stat_activity