Re: Log notice that checkpoint is to be written on shutdown

On 10/4/14, 1:21 PM, Jeff Janes wrote:
> On Thu, Oct 2, 2014 at 6:21 AM, Michael Banck <michael(dot)banck(at)credativ(dot)de <mailto:michael(dot)banck(at)credativ(dot)de>> wrote:
>
> Hi,
>
> we have seen repeatedly that users can be confused about why PostgreSQL
> is not shutting down even though they requested it. Usually, this is
> because `log_checkpoints' is not enabled and the final checkpoint is
> being written, delaying shutdown. As no message besides "shutting down"
> is written to the server log in this case, we even had users believing
> the server was hanging and pondering killing it manually.
>
>
> Wouldn't a better place to write this message be the terminal from which "pg_ctl stop" was invoked, rather than the server log file?
>
+1

Or do both. I suspect elog( INFO, ... ) might do that.