Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s6WPE-0005xN-Kx for pgsql-general@arkaria.postgresql.org; Mon, 13 May 2024 14:11:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1s6WPE-000PDo-HX for pgsql-general@arkaria.postgresql.org; Mon, 13 May 2024 14:11:56 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s6WPE-000PDG-1y for pgsql-general@lists.postgresql.org; Mon, 13 May 2024 14:11:56 +0000 Received: from mx4.stadt-zuerich.ch ([194.56.33.13]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s6WPA-0001Av-7Y for pgsql-general@lists.postgresql.org; Mon, 13 May 2024 14:11:55 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=zuerich.ch; i=@zuerich.ch; l=9759; q=dns/txt; s=zuerichch202311; t=1715609513; x=1747145513; h=from:to:subject:date:message-id:mime-version; bh=LhADI26YSPVoXlaJh1NayaC1YQmhKfXTe3XHTcnx1zo=; b=LgQFbe+owuB+4QTR4LfoiAvw0bXSg8OL06tLhMdsttgJ5tv6XR0m00X+ +SW6D9iWk2RAtNM4A04n4Akns9W/EYvpVnzkPOebl5BoxcL6HSKSnqndI qscr/d8P5qloQ9mc+F5hh3XpmwUpUqT1Rvb/l5hoCS3xd66DZACueTZT+ 2yN8LdCe4OMFfgJ0GTYq8XJDN4ECcIzJpNYkVL51h8VeRyhWbzMkiuyY7 AsadJ9uBOLgHtADHH2V/HatgrH/byaTuDE6HlVfZmuqzmirfpAtwH3tKL 0RqY24jH4fMdcoTfJXHi6Nb9sNMBJCZe8koG08COT29BvBFrkVqe/JvSZ Q==; X-IronPort-AV: E=Sophos;i="6.08,158,1712613600"; d="scan'208,217";a="54109912" Received: from unknown (HELO SZHM27371.global.szh.loc) ([10.7.49.50]) by mx4.prm.szh.zone with ESMTP/TLS/AES256-GCM-SHA384; 13 May 2024 16:11:51 +0200 Received: from SZHM27371.global.szh.loc (10.7.49.52) by SZHM27371.global.szh.loc (10.7.49.52) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256) id 15.1.2375.18; Mon, 13 May 2024 16:11:51 +0200 Received: from szhm30935.global.szh.loc (172.26.4.39) by SZHM27371.global.szh.loc (10.7.49.53) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256) id 15.1.2375.18 via Frontend Transport; Mon, 13 May 2024 16:11:50 +0200 Received: from ZR1P278CU001.outbound.protection.outlook.com (40.93.85.8) by smtp.stadt-zuerich.ch (172.27.4.39) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.2.792.3; Mon, 13 May 2024 16:11:50 +0200 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=NKpHcmlWLs9Dr2PmesXFiItWKQ5EU27aXt04HCQSIS6ErCKG9TdvegCguTGZPJtb9+DdOrj3AO7ZoLkycVV6bmtJWoEbwTb3XmkPBqHSSBY8OWJQvuD4467rX9h8Fmr+uwEjgl3Fkrhv2CEoMLiMPqjX3nxLg8Pc9TxSae/PEIZgvgZIFBQyoQDHfp6cfh8kkGoHIpvlrzb5+B8XTOyIzBKObdca+E9LLIgYyJWkzN6oPbLBaSLO5cgUwbSwAP/kSjUjIVZzNffXYAb7PCPh9fbynxAeKkNMucGwEbJHZYEXWPKYZuaV5U9zMmoim5aN3PPtOMb3uCS29bwyPEZsRA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=LhADI26YSPVoXlaJh1NayaC1YQmhKfXTe3XHTcnx1zo=; b=eg/TYuEdTQF8BcdhupniqUVW619JmuI4n2/gjPSjDtEGz4lbQyLJ3zokC5dpL/LqJQ2J79IUktrrf4AOL2dqQzSABSI5BtcM2TU0Ucit0GnP+R5rorstIoIeMSkgZ8ZCbpBUugwn9wiOrZXDLDJnX6kSM8jNGiURIWc5rGJ18vKNSXnmDvX/YzrSW5I/V8OWGpyqTJC72yPMJgs8eMlkh/9BsCW8j+APbcB0tMkk5LUPJ9rVeF+5jqizJVBw4DqNuGGQxNBVFavM2XsLtBlaispG3XhVz0EODPIRmsjr3c8fbdrb3bKYJ+qgF7DfML/HRhNWxCUi91DVu6wtPVt83w== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=zuerich.ch; dmarc=pass action=none header.from=zuerich.ch; dkim=pass header.d=zuerich.ch; arc=none Received: from GV0P278MB0099.CHEP278.PROD.OUTLOOK.COM (2603:10a6:710:27::12) by ZR3P278MB1712.CHEP278.PROD.OUTLOOK.COM (2603:10a6:910:8d::7) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.7544.55; Mon, 13 May 2024 14:10:50 +0000 Received: from GV0P278MB0099.CHEP278.PROD.OUTLOOK.COM ([fe80::bf73:d490:294c:3df3]) by GV0P278MB0099.CHEP278.PROD.OUTLOOK.COM ([fe80::bf73:d490:294c:3df3%6]) with mapi id 15.20.7544.052; Mon, 13 May 2024 14:10:50 +0000 From: "Zwettler Markus (OIZ)" To: "pgsql-general@lists.postgresql.org" Subject: how to completely turn off statement error logging Thread-Topic: how to completely turn off statement error logging Thread-Index: AdqlPSI0/jnyLfc3T9G92kdRs5g7ig== Date: Mon, 13 May 2024 14:10:49 +0000 Message-ID: Accept-Language: de-DE, en-US Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=zuerich.ch; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: GV0P278MB0099:EE_|ZR3P278MB1712:EE_ x-ms-office365-filtering-correlation-id: f87d89ff-5da8-41c7-b8bf-08dc73567e20 x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230031|376005|366007|1800799015|38070700009; x-microsoft-antispam-message-info: =?us-ascii?Q?cocQhZJy7c3nVBoGyZWsB0cOenusM0TbXZ4aE9H0WLjojRBEOvpS1bwxgjAc?= =?us-ascii?Q?jIgv2T3V8CR6K8xZ84ExXityGU2GweunZhnJ7Qy/aCWtIePjAiIPixZsSnRi?= =?us-ascii?Q?LkFxi35al7L5hUfdG5y+3x2l2XKiTK+ZvTls5z9bx7pK5qXRBASuKyuIBVRH?= =?us-ascii?Q?XyrWltqprWtnEFwjF228Ick5D1kC7XHF8BZKP6/t2GxJHwMzKycQ7jftcEmU?= =?us-ascii?Q?zrsmXVJdl/tSRPYsfh1u6On9nVJ5gbrdBYK4tRgvY7LmbrZ9/SHUMRzI1Uyu?= =?us-ascii?Q?Kw0OdeYEjL141r7H4sjcZhJFXoF+g71WH5L0IyiTEzfPmOqTYdTcNDuuncgN?= =?us-ascii?Q?tuqM86hdrc3fpZ0IJ3Ugh0dgXnQhwBRrnLafpsgksd0LbdGGBrR8n3QyY0Cn?= =?us-ascii?Q?ctm6GOOXE5APoCth2oS1Ws8s/aOuAj/jRWy4afR95GS6TcP6fw2PtAU55Iv8?= =?us-ascii?Q?OjDi/OrEnqtD5gT7KLOLrGkEw4tLzYs/+zAw8DlU6LaQrvnwWu+R0hXpZNZj?= =?us-ascii?Q?Wn6SR/JHTSGwpIIp84by9K7xztdMyRtXzMXdwfh+aMvZgFsoT4flfZZVNSaL?= =?us-ascii?Q?cy9v0tqyTGeGXMURXtZHYpM8yP1bGBL/WcZMpmLDNBfmGmx0zAAQ00W6RLFf?= =?us-ascii?Q?0Yxk9Q8vhlx7BWt3deMNBJutKNjMMIsa/Faxq41ccgq6lCRVuMTjG6PLAmEe?= =?us-ascii?Q?PBMDYEfadVdPhpMrU3nOU7bMNFT35Kt9UK6Y5lesdLqsF+lNWIkU/8dTQjt5?= =?us-ascii?Q?EbGmuc9pBiTbSaVeKpwBPB2zgSdJJcNxxeHv34l6Iu50BfGMjbc1nL2sIYvo?= =?us-ascii?Q?3UZQGOc+ktEqOw8aLSXNy0NTZTj52bU5pX0B9qnrFPDymqsunCTHnqhh/kuK?= =?us-ascii?Q?mbElRepFG8KHkdTypyDqDs2P4PwSJEpDcPSF2R81WyiUuFrCbF7gq2Ykx6ZA?= =?us-ascii?Q?FXyQdj8ERVFBKClCN6/q2wN/7j/3XulGi3HOGJKGgRbciwgODvxggihPqRpe?= =?us-ascii?Q?xQ5CA3oN5mGDjY2NeT/ac/YnqATNg5uBJnedZus42F9iKayZXO17DR0k1eQR?= =?us-ascii?Q?DRoHK+OtHxBdLvIXl/TzatxGP5OmudBDBd5G8nfzB2Y67X/IoKFXmuQPyKWH?= =?us-ascii?Q?/juWnFJS29o2HLfzK8BTQt3GnGBP5Rmdg1ud0OeZgYD4pDd87qk/e4hDR1Gm?= =?us-ascii?Q?xbXhgxW5milk412Bxd9F0i+QnMlxtwL12B7Ghpoll55eYgrgpmujY8GgTR19?= =?us-ascii?Q?56jtE07+XJSxt0R3Gy9xW0V4kgPz0fSrBdr7N1aRWCVdXFNGLwWqJZ+Bu3bx?= =?us-ascii?Q?aeBM50jPHMSV+KUYlU4/eo9WpwnCMM8pd/tMcruijSP7qQ=3D=3D?= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:GV0P278MB0099.CHEP278.PROD.OUTLOOK.COM;PTR:;CAT:NONE;SFS:(13230031)(376005)(366007)(1800799015)(38070700009);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?us-ascii?Q?c0DAXxLJyYNaXHOy8TBWKEoMAzryOFU1N3teoEfb34RXf3z5eIsbDevOMrja?= =?us-ascii?Q?L4RZq7my8S2m9agfetyeTs0vcKQlINSJnkYhyvvMl1YuHhncrE+Kez7Ba8pV?= =?us-ascii?Q?BlKGr9qUaoDCZu7plDPBle5DL7KTra+zevW2Y0y3Rdt1DkRckOeU58FAdhqb?= =?us-ascii?Q?p5ZnrKUSyJbY8igTi508WaG7L+3XP6rCmu64p2keLgoWUv2RxtlbhqTxUaBY?= =?us-ascii?Q?2GEd2rkyk3OlzHcZsEVHb/GSCHagCqVTDHaM4AvBUVqUTqI2KJwmiN5oWTEY?= =?us-ascii?Q?jghXbkHx9FYHbgEFFGzev7yTryWImG1766/5mxDzTsXkxiLNgwWcO0IkKYz1?= =?us-ascii?Q?eEODZS1tiLHwK2m4hyFQ9MlR/tCovTs/J07obAqIgOPPMqXMDA7cBUBhdSVx?= =?us-ascii?Q?0FNEn6t3S7v2o/DW293U14oW2yqIFL7Zkgt9iQkLLd7u+Eli6hfmcY1IoFeW?= =?us-ascii?Q?fOsnPW+ukguUNmcJ/Udei5dkNxauEJqZYENuVC8507Odvrk9CVYWyc+ySqrY?= =?us-ascii?Q?sUn2NleZRXrlFoLw9ZsS5mPavVUdli7TWO6mjmWx2Fmo6nGTwvxZuZHqPzT2?= =?us-ascii?Q?bjiP5m3xzz0Nsc2FZ4yGt+MWAyujPQBURPN2cf7DX9So5DbuJREtSQtQFFfC?= =?us-ascii?Q?RY8iyUnzpZdnbnn1/KtZYtv8rdIkrPmbdofFwWED+y2O8Z2GNY8u3yGm1t2q?= =?us-ascii?Q?AHXIFdtI9Z2j6W0ii5gBUHiWT9qnzO+4EWU05HowkLjHrY970HTxW+clsVt5?= =?us-ascii?Q?VaDEAkQHxXF4rc4sHbXFjEpXL+TZcaZcd9cj6tvzPEKSq62Km7WlIQ7l7O4i?= =?us-ascii?Q?lmTyzXiM+axAwt48DXhSjqO9weChMOJlzt7gKliU3n8A0N8CsdS/e2Xf6kt2?= =?us-ascii?Q?Wwwum8SZAf+SKY+11mJTqx0rRVIMRnmQHHwPvGRRpxDH43a6PX9xyDr3u3td?= =?us-ascii?Q?WET8VXxAHQaEXZcEBd17jO668CX37ZTNz7edtz9G+uxQDttKYKLzzIYbUl77?= =?us-ascii?Q?dn9YlkEJ0r9+2LVnFJziZGqzmaIbYyHVT5+RPXAm5YZkmtffcjhxIrhWe3nO?= =?us-ascii?Q?/MsmolD0+Gf1w4j4YPh9m3cTvddZ5MfWeTKhaHxi1/jQdpw3Wph0K5g/N1cf?= =?us-ascii?Q?CdDnt3FYTvB++cH6rsmQuaz+rpJE+R4f9g7U9O+6swDPgkc4ZUmVZxrHkE+P?= =?us-ascii?Q?jDFnKjJ3be/pDovSep6w8P0U1hcDHMOgIToIQGZR2NhgLML5a5kC+nLivOP2?= =?us-ascii?Q?Izr9pxnPCuBYZYrY22Ejqws5IWEg4mebGttA/4PMrO+h1LYQz1nuJsT3TCOa?= =?us-ascii?Q?Fc+vw3B5fj6sZ8eyotqp++xQTTOT3Vr1Bral/VciL9z4+Kn1OodA/afZYX08?= =?us-ascii?Q?SJ9DFzUU/mdUdyOLPbV3JXwRx88iItMQeTVSmCnVgnZzpmlad0YvdzHaCAL1?= =?us-ascii?Q?ZteLzQJOWN9DQXYzIFWtLwyKppr3LMh4w2CukFQ6vLos1BV7lP1fVkkfKRqp?= =?us-ascii?Q?MaqgjL7McTJRbQH5btthJYIj3JcGM2XFSJ7xNDaA27YuTR8mayEtLLObtkcv?= =?us-ascii?Q?iU5P5Xn/bWnYDNSSPpdMT/cHa31eGPY0uVP16+VG?= Content-Type: multipart/alternative; boundary="_000_GV0P278MB00991074B9126020E024E8A38BE22GV0P278MB0099CHEP_" MIME-Version: 1.0 X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: GV0P278MB0099.CHEP278.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-Network-Message-Id: f87d89ff-5da8-41c7-b8bf-08dc73567e20 X-MS-Exchange-CrossTenant-originalarrivaltime: 13 May 2024 14:10:49.9599 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 9f489fcc-e452-4509-8234-6f97b42d0117 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: dQehkfuSojMKSUtsXAfPcaHV2nfh3fnj+198XGiGVK5Ey9TKsIA2VHz+ylgDE7U7VEa+qC2uFQGkxTGJGqtwy/nRT4Nl9wQGVK12MPPjfGc= X-MS-Exchange-Transport-CrossTenantHeadersStamped: ZR3P278MB1712 X-OriginatorOrg: zuerich.ch List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_GV0P278MB00991074B9126020E024E8A38BE22GV0P278MB0099CHEP_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable I don't want to log statement errors in the server logfile - whether the st= atement string nor the error message. I set "log_min_error_statement =3D panic" according to the docs: To effectively turn off logging of failing statements, set this parameter t= o PANIC. But error messages are still logged: $ psql psql (12.17) SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384, bit= s: 256, compression: off) Type "help" for help. pcl_l300=3D# show log_min_error_statement; log_min_error_statement ------------------------- panic (1 row) pcl_l300=3D# select error_817 / 0; ERROR: column "error_817" does not exist LINE 1: select error_817 / 0; ^ pcl_l300=3D# 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? --_000_GV0P278MB00991074B9126020E024E8A38BE22GV0P278MB0099CHEP_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

I do= n't want to log statement errors in the server logfile – whether the = statement string nor the error message.



I se= t "log_min_error_statement =3D panic" according to the docs:=

 

<= quote>

To e= ffectively turn off logging of failing statements, set this parameter to&nb= sp;PANIC.

<= /quote>



But = error messages are still logged:

$ psql

psql= (12.17)

SSL = connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384, bits: 2= 56, compression: off)

Type= "help" for help.

 

pcl_= l300=3D# show log_min_error_statement;

log_= min_error_statement

----= ---------------------

pani= c

(1 r= ow)

 

pcl_= l300=3D# select error_817 / 0;

ERRO= R:  column "error_817" does not exist

LINE= 1: select error_817 / 0;

&nbs= p;            &= nbsp; ^

pcl_= l300=3D# exit

$ fg= rep error_817 pg_statsinfo.log

2024= -05-13 16:01:14 CEST 36421 ERROR:  column "error_817" does n= ot exist


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

 

--_000_GV0P278MB00991074B9126020E024E8A38BE22GV0P278MB0099CHEP_--