Re: smart shutdown at end of transaction (was: Default mode for shutdown) - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: smart shutdown at end of transaction (was: Default mode for shutdown)
Date
Msg-id 4F9AB605020000250004749C@gw.wicourts.gov
Whole thread Raw
In response to Re: smart shutdown at end of transaction (was: Default mode for shutdown)  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List pgsql-hackers
Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> wrote:
> Just thinking out loud here..
In the spirit of kicking around ideas...
For those writing service scripts where you want a time limit on how
long a stop can take, so that the service script doesn't prevent OS
shutdown within a bounded time, it would also be nice to add an
escalation time limit; so if there isn't a shutdown withing k
seconds at one level it goes to the next.  If the building is on
fire and you need to power down all equipment before the fire
department cuts power and starts spraying water (a situation we had
at a courthouse a year or two ago), you really don't want the OS
waiting for anything for more than a limited number of seconds
before escalating to immediate.  We do that in our sh scripts now,
by using kill and sleep instead of trusting pg_ctl, but it seems
like it would be better to have pg_ctl know how to do that.
maybe?: --escalate-after=seconds
-Kevin


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: smart shutdown at end of transaction (was: Default mode for shutdown)
Next
From: Peter Eisentraut
Date:
Subject: Re: smart shutdown at end of transaction (was: Default mode for shutdown)