Re: could not stat promote trigger file leads to shutdown - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: could not stat promote trigger file leads to shutdown
Date
Msg-id 20191117015901.GA23782@alvherre.pgsql
Whole thread Raw
In response to Re: could not stat promote trigger file leads to shutdown  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: could not stat promote trigger file leads to shutdown  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 2019-Nov-15, Tom Lane wrote:

> If we add a GUC-check-hook test, then the problem of misconfiguration
> is reduced to the previously unsolved problem that we have crappy
> feedback for erroneous on-the-fly configuration changes.  So it's
> still unsolved, but at least we've got one unsolved problem not two.

I am now against this kind of behavior, because nowadays it is common
to have external orchestrating systems stopping and starting postmaster
on their own volition.

If this kind of misconfiguration causes postmaster refuse to start, it
can effectively become a service-shutdown scenario which requires the
DBA to go temporarily mad.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-hackers by date:

Previous
From: Steve Singer
Date:
Subject: Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on thefly
Next
From: Alvaro Herrera
Date:
Subject: Re: Attempt to consolidate reading of XLOG page