public inbox for [email protected]  

help / color / mirror / Atom feed

From: Zwettler Markus (OIZ) <[email protected]>
To: [email protected] <[email protected]>
Subject: how to completely turn off statement error logging
Date: Mon, 13 May 2024 14:10:49 +0000
Message-ID: <GV0P278MB00991074B9126020E024E8A38BE22@GV0P278MB0099.CHEP278.PROD.OUTLOOK.COM> (raw)

I don't want to log statement errors in the server logfile - whether the statement string nor the error message.


I set "log_min_error_statement = panic" according to the docs:

<quote>
To effectively turn off logging of failing statements, set this parameter to PANIC.
</quote>


But error messages are still logged:

$ psql
psql (12.17)
SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384, bits: 256, compression: off)
Type "help" for help.

pcl_l300=# show log_min_error_statement;
log_min_error_statement
-------------------------
panic
(1 row)

pcl_l300=# select error_817 / 0;
ERROR:  column "error_817" does not exist
LINE 1: select error_817 / 0;
               ^
pcl_l300=# exit
$ fgrep error_817 pg_statsinfo.log
2024-05-13 16:01:14 CEST 36421 ERROR:  column "error_817" does not exist


Question: How can I turn off logging of this statement based error message?

view thread (4+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: how to completely turn off statement error logging
  In-Reply-To: <GV0P278MB00991074B9126020E024E8A38BE22@GV0P278MB0099.CHEP278.PROD.OUTLOOK.COM>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox