Re: [RFC] Shouldn't we remove annoying FATAL messages from server log? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [RFC] Shouldn't we remove annoying FATAL messages from server log?
Date
Msg-id 16175.1386258393@sss.pgh.pa.us
Whole thread Raw
In response to [RFC] Shouldn't we remove annoying FATAL messages from server log?  ("MauMau" <maumau307@gmail.com>)
Responses Re: [RFC] Shouldn't we remove annoying FATAL messages from server log?
Re: [RFC] Shouldn't we remove annoying FATAL messages from server log?
List pgsql-hackers
"MauMau" <maumau307@gmail.com> writes:
> Shouldn't we lower the severity or avoiding those messages to server log? 

No.  They are FATAL so far as the individual session is concerned.
Possibly some documentation effort is needed here, but I don't think
any change in the code behavior would be an improvement.

> 1. FATAL:  the database system is starting up
> 2. FATAL:  the database system is shutting down
> 3. FATAL:  the database system is in recovery mode
> 4. FATAL:  sorry, too many clients already
> Report these as FATAL to the client because the client wants to know the 
> reason.  But don't output them to server log because they are not necessary 
> for DBAs (4 is subtle.)

The notion that a DBA should not be allowed to find out how often #4 is
happening is insane.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: Performance Improvement by reducing WAL for Update Operation
Next
From: Metin Doslu
Date:
Subject: Re: Parallel Select query performance and shared buffers