Immediate shutdown during recovery - Mailing list pgsql-hackers

From Fujii Masao
Subject Immediate shutdown during recovery
Date
Msg-id 3f0b79eb0811280156s78a3730en73aca49b6e95d3cb@mail.gmail.com
Whole thread Raw
Responses Re: Immediate shutdown during recovery  ("Fujii Masao" <masao.fujii@gmail.com>)
List pgsql-hackers
Hi,

The immediate shutdown (pg_ctl -m i stop) might not be able to
kill the startup process during archive recovery. It's because
the startup process calls system() which ignores SIGQUIT for
executing the restore_command. So, only the startup process
might survive the immediate shutdown and continue redoing up
to the end. Is this desirable behavior? This sounds odd for me.

In order to prevent the surviving, I think that the startup process
should check whether postmaster is still alive periodically. This
idea is already adopted in the archiver process which also calls
system() for executing archive_command.

What is your opinion?

Regards,

-- 
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center


pgsql-hackers by date:

Previous
From: tomas@tuxteam.de
Date:
Subject: Re: Simple postgresql.conf wizard
Next
From: Simon Riggs
Date:
Subject: Re: Review: Hot standby