Re: Log notice that checkpoint is to be written on shutdown
От | Andres Freund |
---|---|
Тема | Re: Log notice that checkpoint is to be written on shutdown |
Дата | |
Msg-id | 20141009122458.GC6724@awork2.anarazel.de обсуждение исходный текст |
Ответ на | Log notice that checkpoint is to be written on shutdown (Michael Banck <michael.banck@credativ.de>) |
Ответы |
Re: Log notice that checkpoint is to be written on shutdown
|
Список | pgsql-hackers |
On 2014-10-02 15:21:48 +0200, Michael Banck 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. > > In order to alert those users that a checkpoint is being written, I > propose to add a log message "waiting for checkpoint ..." on shutdown, > even if log_checkpoints is disabled, as this particular checkpoint might > be important information. > > I've attached a trivial patch for this, should it be added to the next > commitfest? How about flipping the default for log_checkpoints instead? There really isn't a good reason for having it disabled by default. Greetings, Andres Freund -- Andres Freund http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services
В списке pgsql-hackers по дате отправления: