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

2006-11-17 Thread Gregory Stark
"Tom Lane" <[EMAIL PROTECTED]> writes: > Gregory Stark <[EMAIL PROTECTED]> writes: >> Sure, but it might be getting delivered to, say, your "sleep" command. You >> haven't checked the return value of sleep to handle any errors that may >> occur. >> As it stands you have to check for errors from e

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

2006-11-17 Thread Tom Lane
Gregory Stark <[EMAIL PROTECTED]> writes: > Sure, but it might be getting delivered to, say, your "sleep" command. You > haven't checked the return value of sleep to handle any errors that may occur. > As it stands you have to check for errors from every single command executed > by your script. T

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

2006-11-17 Thread Stephen Harris
On Fri, Nov 17, 2006 at 09:39:39PM -0500, Gregory Stark wrote: > "Stephen Harris" <[EMAIL PROTECTED]> writes: > > [...variable setup...] > > while [ ! -f $wanted_file ] > > do > > if [ -f $abort_file ] > > then > > exit 1 > > fi > > sleep 5 > > done > > cat $wanted_f

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

2006-11-17 Thread Gregory Stark
"Stephen Harris" <[EMAIL PROTECTED]> writes: > My script was just a ksh script and didn't do anything special with signals. > Essentially it does > #!/bin/ksh -p > > [...variable setup...] > while [ ! -f $wanted_file ] > do > if [ -f $abort_file ] > then > exit 1 > fi >

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

2006-11-17 Thread Stephen Harris
On Fri, Nov 17, 2006 at 05:03:44PM -0500, Tom Lane wrote: > Stephen Harris <[EMAIL PROTECTED]> writes: > > Doing a shutdown "immediate" isn't to clever because it actually leaves > > the recovery threads running > > > LOG: restored log file "00010001003E" from archive > > LOG: receiv

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

2006-11-17 Thread Tom Lane
Stephen Harris <[EMAIL PROTECTED]> writes: > Doing a shutdown "immediate" isn't to clever because it actually leaves > the recovery threads running > LOG: restored log file "00010001003E" from archive > LOG: received immediate shutdown request > LOG: restored log file "00010

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

2006-11-17 Thread Stephen Harris
I'm using 8.2beta3 but I'm asking here before posting to the devel lists as suggested by that lists guidelines.. First the question, because it might be simple and I'm stupid. However I'll then go into detail in case I'm not so silly. In a database which is in recovery mode waiting on an externa