Re: postmaster recovery and automatic restart suppression - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: postmaster recovery and automatic restart suppression
Date
Msg-id 4A2E846B020000250002779A@gw.wicourts.gov
Whole thread Raw
In response to Re: postmaster recovery and automatic restart suppression  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: postmaster recovery and automatic restart suppression  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> wrote: 
> "Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
>> "Kolb, Harald (NSN - DE/Munich)" <harald.kolb@nsn.com> wrote:
>>> There are some good reasons why a switchover could be an
>>> appropriate means in case the DB is facing troubles. It may be
>>> that the root cause is not the DB itself, but used resources or
>>> other things which are going crazy and hit the DB first
> 
>> Would an example of this be that one drive in a RAID has gone bad
>> and the hot spare rebuild has been triggered, leading to poor
>> performance for a while?  Is that the sort of issue where you see
>> value?
> 
> How would that be connected to a "no restart on crash" setting?
It wouldn't; but I'm trying to better understand the problem the OP is
trying to solve, to see where that leads.
My first reaction on hearing the request was that it might have *some*
use; but in trying to recall any restart where it is what I would have
wanted, I come up dry.  I haven't even really come up with a good
hypothetical use case.  But I get the feeling the OP has had some
problem this is attempting to address.  I'm just not clear what that
is.
-Kevin


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: page is uninitialized --- fixing
Next
From: Andrew Dunstan
Date:
Subject: Re: Problem with listen_addresses = '*' on 8.4beta2 on AIX