how to completely turn off statement error logging

From: "Zwettler Markus (OIZ)" <Markus(dot)Zwettler(at)zuerich(dot)ch>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: how to completely turn off statement error logging
Date: 2024-05-13 14:10:49
Message-ID: GV0P278MB00991074B9126020E024E8A38BE22@GV0P278MB0099.CHEP278.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Sabino Mullane 2024-05-13 14:13:54 Re: Postgresql active-active nodes in cluster
Previous Message Dimitrios Apostolou 2024-05-13 14:07:19 Re: SELECT DISTINCT chooses parallel seqscan instead of indexscan on huge table with 1000 partitions