Re: should we enable log_checkpoints out of the box?

On Fri, Nov 5, 2021 at 03:29:37PM +0100, Michael Banck wrote:
> Am Freitag, dem 05.11.2021 um 11:27 -0300 schrieb Alvaro Herrera:
> > On 2021-Nov-03, Jan Wieck wrote:
> > > On 11/3/21 09:09, Robert Haas wrote:
> > >
> > > > For better or for worse, the distinction between ERROR, FATAL,
> > > > and
> > > > PANIC is entirely based on what we do after printing the message,
> > > > and NOT on how serious the message is.
> > >
> > > THAT is a real problem with our error handling and logging system.
> >
> > Agreed.
>
> Well that, and the fact those distinctions are only done for user-
> facing events, whereas it seems to me we only distinguish between LOG
> and PANIC for server-facing events; maybe we need one or more
> additional levels here in order to make it easier for admins to see the
> really bad things that are happening?

Agreed. We have three levels of non-error message for the client (info,
notice, warning), but only one level for error (query is stopped),
ERROR. Seems we need another level that stops the current query and
indicates it contains information that would be useful for database
server administrators.

--
Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com

If only the physical world exists, free will is an illusion.