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

From Peter Eisentraut
Subject could not stat promote trigger file leads to shutdown
Date
Msg-id 3d22ae93-db56-9487-555b-ca6518ec036c@2ndquadrant.com
Whole thread Raw
Responses Re: could not stat promote trigger file leads to shutdown  (Fujii Masao <masao.fujii@gmail.com>)
Re: could not stat promote trigger file leads to shutdown  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
I have seen the error

     could not stat promote trigger file "...": Permission denied

because of a misconfiguration (for example, setting promote_trigger_file 
to point into a directory to which you don't have appropriate read or 
execute access).

The problem is that because this happens in the startup process, the 
ERROR is turned into a FATAL and the whole instance shuts down.  That 
seems like a harsh penalty.  Would it be better to turn this ERROR into 
a WARNING?

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-hackers by date:

Previous
From: Sehrope Sarkuni
Date:
Subject: Re: ssl passphrase callback
Next
From: Fujii Masao
Date:
Subject: Re: Allow CREATE OR REPLACE VIEW to rename the columns