Re: [GENERAL] Shutting down a warm standby database in 8.2beta3 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [GENERAL] Shutting down a warm standby database in 8.2beta3
Date
Msg-id 25273.1163829718@sss.pgh.pa.us
Whole thread Raw
In response to Re: [GENERAL] Shutting down a warm standby database in 8.2beta3  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-hackers
Gregory Stark <stark@enterprisedb.com> writes:
> Hm, I tried to test that before I sent that. But I guess my test was faulty
> since I was really testing what process the terminal handling delivered the
> signal to:

Interesting.  I tried the same test on HPUX, and find that its /bin/sh
seems to ignore SIGQUIT but not SIGINT:

$ sh /tmp/test.sh ; echo $?
before                    -- typed ^C here
130
$ sh /tmp/test.sh ; echo $?
before                    -- typed ^\ here
/tmp/test.sh[4]: 25166 Quit(coredump)
sleep failed
after
0
$ 

There is nothing in the shell man page about this :-(

That seems to leave us back at square one.  How can we ensure an archive
or recovery script will fail on being signaled?  (Obviously we can't
prevent someone from trapping the signal, but it'd be good if the
default behavior was this way.)
        regards, tom lane


pgsql-hackers by date:

Previous
From: Gregory Stark
Date:
Subject: Re: [GENERAL] Shutting down a warm standby database in 8.2beta3
Next
From: Peter Eisentraut
Date:
Subject: Re: Proposal: syntax of operation with tsearch's configuration