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?
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 |