Log notice that checkpoint is to be written on shutdown
От | Michael Banck |
---|---|
Тема | Log notice that checkpoint is to be written on shutdown |
Дата | |
Msg-id | 1412256108.5984.23.camel@hartree.muc.credativ.lan обсуждение исходный текст |
Ответы |
Re: Log notice that checkpoint is to be written on shutdown
Re: Log notice that checkpoint is to be written on shutdown Re: Log notice that checkpoint is to be written on shutdown Re: Log notice that checkpoint is to be written on shutdown Re: Log notice that checkpoint is to be written on shutdown |
Список | pgsql-hackers |
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? Cheers, Michael -- Michael Banck Projektleiter / Berater Tel.: +49 (2161) 4643-171 Fax: +49 (2161) 4643-100 Email: michael.banck@credativ.de credativ GmbH, HRB Mönchengladbach 12080 USt-ID-Nummer: DE204566209 Hohenzollernstr. 133, 41061 Mönchengladbach Geschäftsführung: Dr. Michael Meskes, Jörg Folz, Sascha Heuer
Вложения
В списке pgsql-hackers по дате отправления: