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

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Michael Banck <michael(dot)banck(at)credativ(dot)de>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Log notice that checkpoint is to be written on shutdown
Date: 2014-10-04 18:21:03
Message-ID: CAMkU=1wW6ekM=BKHRd731E2tfRwm8-fgFh+oBAVH6TL28K3TgQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Oct 2, 2014 at 6:21 AM, Michael Banck <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?

Cheers,

Jeff

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2014-10-04 18:21:24 Re: Aussie timezone database changes incoming
Previous Message Michael Banck 2014-10-04 18:02:36 Re: Log notice that checkpoint is to be written on shutdown