Re: postmaster recovery and automatic restart suppression
От
Kevin Grittner
Тема
Re: postmaster recovery and automatic restart
suppression
Дата
Msg-id
4A2E846B020000250002779A@gw.wicourts.gov
Ответ на
Список
Дерево обсуждения
postmaster recovery and automatic restart suppression "Kolb, Harald (NSN - DE/Munich)" <harald.kolb@nsn.com>
Re: postmaster recovery and automatic restart suppression Fujii Masao <masao.fujii@gmail.com>
Re: postmaster recovery and automatic restart suppression "Kolb, Harald (NSN - DE/Munich)" <harald.kolb@nsn.com>
Re: postmaster recovery and automatic restart suppression Fujii Masao <masao.fujii@gmail.com>
Re: postmaster recovery and automatic restart suppression Gregory Stark <stark@enterprisedb.com>
Re: postmaster recovery and automatic restart suppression Tom Lane <tgl@sss.pgh.pa.us>
Re: postmaster recovery and automatic restart suppression Simon Riggs <simon@2ndQuadrant.com>
Re: postmaster recovery and automatic restart suppression Greg Stark <stark@enterprisedb.com>
Re: postmaster recovery and automatic restart suppression Tom Lane <tgl@sss.pgh.pa.us>
Re: postmaster recovery and automatic restart suppression Robert Haas <robertmhaas@gmail.com>
Re: postmaster recovery and automatic restart suppression Tom Lane <tgl@sss.pgh.pa.us>
Re: postmaster recovery and automatic restart suppression Robert Haas <robertmhaas@gmail.com>
Re: postmaster recovery and automatic restart suppression "Kolb, Harald (NSN - DE/Munich)" <harald.kolb@nsn.com>
Re: postmaster recovery and automatic restart suppression Simon Riggs <simon@2ndQuadrant.com>
Re: postmaster recovery and automatic restart suppression Fujii Masao <masao.fujii@gmail.com>
Re: postmaster recovery and automatic restart suppression Tom Lane <tgl@sss.pgh.pa.us>
Re: postmaster recovery and automatic restart suppression "Kolb, Harald (NSN - DE/Munich)" <harald.kolb@nsn.com>
Re: postmaster recovery and automatic restart suppression Alvaro Herrera <alvherre@commandprompt.com>
Re: postmaster recovery and automatic restart suppression "Czichy, Thoralf (NSN - FI/Helsinki)" <thoralf.czichy@nsn.com>
Re: postmaster recovery and automatic restart suppression Tom Lane <tgl@sss.pgh.pa.us>
Re: postmaster recovery and automatic restart suppression Fujii Masao <masao.fujii@gmail.com>
Re: postmaster recovery and automatic restart
suppression "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: postmaster recovery and automatic restart suppression Tom Lane <tgl@sss.pgh.pa.us>
Re: postmaster recovery and automatic restart
suppression "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: postmaster recovery and automatic restart suppression Simon Riggs <simon@2ndQuadrant.com>
Re: postmaster recovery and automatic restart suppression Greg Stark <greg.stark@enterprisedb.com>
Re: postmaster recovery and automatic restart suppression Fujii Masao <masao.fujii@gmail.com>
Tom Lane wrote: > "Kevin Grittner" writes: >> "Kolb, Harald (NSN - DE/Munich)" 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 по дате отправления
От: Andrew Dunstan
Дата: