Re: Shutting down a warm standby database in 8.2beta3

On Wed, Nov 22, 2006 at 03:03:03PM -0500, Tom Lane wrote:
> Stephen Harris <lists(at)spuddy(dot)org> writes:
> > We can see that the sleep process got it!
> > /export/home/swharris/rr[37]: 29537 Quit(coredump)
> > And my script detects the trigger file
> > Wed Nov 22 13:43:51 EST 2006: End of recovery trigger file found
>
> > Now database recovery appears to continue as normal; the postgres
> > recovery processes are still running, despite having received SIGQUIT
>
> Well, sure, because system() will have ignored the SIGQUIT. You have to
> make the shell script return an abort code rather than exit(1) or
> whatever it's doing in this case. (I've tested that CVS HEAD does the

Hmm, on Linux I did a kill -QUIT on the process group and then rather
than cleanly exiting my recovery script I "kill -9"d it. The database
still completed recovery as previously described.

> right thing when the script is just a straight invocation of cp. But
> if the script is trapping errors, it's going to have to cooperate.)

The script doesn't trap errors; ksh itself plays with SIGQUIT.

I guess I should rewrite my script in perl and see what happens.

--

rgds
Stephen