Hi, On Fri, Nov 28, 2008 at 6:56 PM, Fujii Masao <[EMAIL PROTECTED]> wrote: > 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 RestoreArchivedFile(), there is the following code as the safeguard against the termination of restore_command by signal. But the safeguard might not work if restore_command defines its own signal handler for SIGQUIT like pg_standby. > signaled = WIFSIGNALED(rc) || WEXITSTATUS(rc) > 125; > > ereport(signaled ? FATAL : DEBUG2, > (errmsg("could not restore file \"%s\" from archive: return code %d", > xlogfname, rc))); Regards, -- Fujii Masao NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers