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 1uuCD3-004RsH-7H for pgsql-general@arkaria.postgresql.org; Thu, 04 Sep 2025 15:49:14 +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 1uuCD2-00HZen-9S for pgsql-general@arkaria.postgresql.org; Thu, 04 Sep 2025 15:49:12 +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 1uuCCL-00HV4z-4w for pgsql-general@lists.postgresql.org; Thu, 04 Sep 2025 15:48:29 +0000 Received: from mout01.posteo.de ([185.67.36.65]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uuCCH-000YaA-2y for pgsql-general@lists.postgresql.org; Thu, 04 Sep 2025 15:48:28 +0000 Received: from submission (posteo.de [185.67.36.169]) by mout01.posteo.de (Postfix) with ESMTPS id CBA78240027 for ; Thu, 4 Sep 2025 17:48:24 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=posteo.de; s=2017; t=1757000904; bh=fakldboY/u39c9y5YL9TIBk2RW4549Hw/FRiPn7IFO4=; h=Date:From:Subject:To:Cc:MIME-Version:Autocrypt:Message-Id: Content-Type:From; b=GeyvU489KRC2v3Wbn+fgm5S40wg4/+1HpkNrREC/gvVJfbFnOqYL6ohL80V/ulDqp 9bR4XbiuI1SAIbWh+E6WEbiZCW46a2Ei10w06Xhu8DuacOZmGVWk4XPr3mdPOEFECa PVWc4neULxVNhuvUTWJeGzCiv7Rtch6ILz+cariMkl2hOtLg/YSuM7Pe2kywstn15W sugSPKsPCH7K5wpNVSFkdrn10zRQcnZIKHEI0U4mnvO1X2aS5WHlVBuRunBu05FUf+ lmSkUnF7AGfmtUFOQdhMuFwnFEqwUNecejxubzQ2soRHZi/KT6L7iSqAQ9pHF2nA3f 6HbKlAmQfl89Q== Received: from customer (localhost [127.0.0.1]) by submission (posteo.de) with ESMTPSA id 4cHkQt4jQbz6tvc; Thu, 4 Sep 2025 17:48:22 +0200 (CEST) Received: from deneb (localhost [127.0.0.1]) by deneb.fritz.box (Postfix) with ESMTP id 75AFD300459; Thu, 04 Sep 2025 17:48:22 +0200 (CEST) Date: Thu, 04 Sep 2025 15:48:24 +0000 From: Albrecht =?iso-8859-1?b?RHJl3w==?= Subject: Re: Q: limit the length of log file entries? To: Tom Lane Cc: pgsql-general@lists.postgresql.org MIME-Version: 1.0 In-Reply-To: <832141.1756926428@sss.pgh.pa.us> Autocrypt: addr=albrecht.dress@posteo.de; prefer-encrypt=mutual; keydata= mQENBFZeB1EBCADhnPQMF2jqSiftx8rmkJ042TTo5Dj5zI89g4Ea2rNGrk70GT+g0wVg1r2Z dWNN3/BM+Hurm/uKqhlj20peqmpbmAdR2R3avztfAdi0XK1wIyMKzER4z2ieo8mY2yZdcrTt jL/P92RHpHMqpITxZBTk5p+TH02LdRgibBglcmc+gN8pF0ZMmMsbGT4J9ytyWXR7xvh+JCBN 0NRhn8+Rz315bnKZPpGkbKaWwfQUsLwlRalLB2Tvc0nNIoTl1RPBHLIVdR/X4fVg3JJqqfzh Jqshmd52PP3oHqNqgPMjHMuvGGQfIOWHifaZxKPyvS9AD+dMFZLFsW6J6Hgfm4YEJ3wtABEB AAG0KUFsYnJlY2h0IERyZcOfIDxhbGJyZWNodC5kcmVzc0Bwb3N0ZW8uZGU+iQFRBBMBCgA7 AhsDBQsJCAcCBhUKCQgLAgQWAgMBAh4BAheAFiEEWb0xPegrNlm4ImZP6kPO+zObgzoFAmO+ 9jYCGQEACgkQ6kPO+zObgzrtpwf/dr6P8QRLHnouFjpfJwN0mcysFU+qfyD22by9yXjsMjg+ dpFRnH46zsOXuynspiQ1Q+2WZfpzJXX9onIE1dHdaz34Bpg6p6/gzzRILU1R1lAXNcSLlTqq PWGi0vu/yckqxEZsjxZLOt+KFlMYQJ/QpT0ejpzzji0Xe1rV7Q1kxOPswiPj5+Cj5gZ784nI 46cIy9hNOyre4AbolLHmgf3VuXddc9bgfo5P+YgcUXK3oMQslZ+1n/E9VG2T3+4mEO+ElEle +pUtZYPauItAP+YMnuy59NdfhtzFm6RmfuPq+jsHtBsO0Fooe7rNs+EXibFLuB4FarJK9rPf cN48tTfI+rkBDQRWXgq9AQgA4jjtGwjlY5UcUvaC10WI9hQC5LcCDbiNeJD2B9HSTrBGvoiu RaVeYJLLhRUDxQgJ0CJ020dOiV6RMaFU3m8mqhRveY2K/QRA5cQKtds7SVDWAei9lJPFIU8y e0/Ub1VBOlDk8h4OEJYa8TK/1iASUzoCS8dPj2F+e3lvIhSJArrUkIsqC+E2kOvhTzk6r21n 6IIbpraLwwtyRK1r7zhBCaIZOf4jd//Zw8GlKe2fbBC7I8V11HvwUwD6a6t9aJ4qBRwab3z4 NS6c6pCbRKrEXxRtycRDzNZjsU/WqgsrGaB8/v0PQziyTSK4be4BJ2vG31qveqKadWJF8fOD AwxsnQARAQABiQI+BBgBAgAJBQJWXgq9AhsCASkJEOpDzvszm4M6wF0gBBkBAgAGBQJWXgq9 AAoJEEypbw5n59n4jXEH/Awx/zmVCEyqTWQ69/9kWKDet2xSnl6o7BCoFGip9T6GEwzW6Q0H vWH2AB9TD9Y271LL5e4mKObDpPtHC1zVRD1lS6DGeWmqTYQ19XKA4dHyzIhn776FgCzJG0gi 4n2ASUQTMeLuTEs6PUohUQpw9mYWgEymWaJqKT/7Y3jjV6F+I67zde4wrMG/bb/pbsGqGEyx 3lisV2NwiCUxLoav+k1atQH608dqX0A8zvoaffepMwpVcPshaJeyxndIFWqSfc9RZ5phK+4Y G/mk/p3sRHZAWr+i9/gBJMtfTpmvC2x6zOzAkYDkSrZlV7BlhNJEgRzIY3/dunvlj/chL7ie ae+x/wf/YyspQSsHs77yLgRyjYrZP9KsFBAm6ZDfIH0Zv5nwRjEL7hEv/w9lGa6/vgsHZqRz 8axTls/ob8DuvytcMvV6VG5IZM7MgOI2fmjxWXUygHoDFB4wpW2qTGcWTqEYApdgrqUzUH99 epmFFwfNZuKQHctTApy8H9rOIdFqCOENs4RzrKqwdt0yEE4FutQ9CbagmOA43rlnQvNP9wLS TSOBOPr34bnE1ik4m/viG5WoEjYO58mnEaHoVSXIe/TVazoSha4qKPqd99VU4gc0V54TN2Bt O30JRmHQOgMGJT9tjwBLwCOcJ+TxvpT5B5h1b890C6FMwEvTxFM175WDzMqG4bkBDQRWXgxL AQgAzTl7tKzNVFWecvxW9VJJXJro3PzIKC8wDVCEqqJ3190yolZ6b5minEDGdvcbJN5reKLL /tTXoYRlqFaK5UlBlVha4IcLpjz8YG+VkQFRODY2lDL7Y2cl7BwP1I+0PlgL1IDXkm0+gpGU ZYh/3ml2/aWX+o9ObQ5teQAQFjI/UhHWmUMEHBA2bow261Gv6McddHj8hhYaRLqIWuslNAuh XOihuo8uSeS220e0awPzhD4bUaUVZ7+6nS8iGbcCVDzV8+yV065uN7BoySxd845k1SYa5wl6 dNDYauMnSHVqsaJJ0TZhCd6o9B3nm/ox1q/aXBBgVuhbkbUv1sSFkiIrfwARAQABiQEfBBgB AgAJBQJWXgxLAhsMAAoJEOpDzvszm4M6v4wIAL+KjjGzeKrnfucLSQjAr90JKh2NllF6jPLI 96x8nNeVPhcxjpo0DcTiCcO8reRKcLP4clTxKdJXOqjzL03mZ4N5QDTXz1QbyC9xblE3BoHN yjsdoJwe2aVRtG2jUs4qjGWx141FkvHtrm/WIh95+YElujqtb3htHjS2rRab8AeIO5H7Mg+i fPP4kX7hQ5GOgDXH8uKX3rgZfV3juBLzXOxNGuyotN+tONoHaABeDK2xDKhQiEByA9I5as3N YvFnI8ZMAuWKn6yVc6eD0TqRGjDT/LRCqisSuFeQhanx4xpYo0Q+BSHybVPxs3jC587Fapir T7Xw36ZsA3NZ/oAySNs= Message-Id: Content-Type: multipart/signed; micalg=PGP-SHA512; protocol="application/pgp-signature"; boundary="=-KOShI8kCLQa51ioAIcB+" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --=-KOShI8kCLQa51ioAIcB+ Content-Type: text/plain; charset=UTF-8 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Am 03.09.25 21:07 schrieb(en) Tom Lane: > There isn't any provision for limiting the length of source queries > quoted in the log. I see, thanks for the clarification. IMHO, it would be nice to have such a= n option, though=E2=80=A6 > Had your user sent the bytea value as a query > parameter, then log_parameter_max_length[_on_error] would have > applied, but this looks like the value was just inline in the query. I can confirm that the limitation is applied when I call PQexecParams() fro= m a little c test application with the data included in the paramValues arr= ay. The overlong log lines result from queries in a Python script using th= e psycopg2 module =E2=80=93 no idea how this component formats the query. Thanks again, Albrecht. --=-KOShI8kCLQa51ioAIcB+ Content-Type: application/pgp-signature; name=openpgp-digital-signature.asc Content-Description: This is a digitally signed message part. -----BEGIN PGP SIGNATURE----- iQEzBAABCgAdFiEEcCEPemLFTtyGf4zATKlvDmfn2fgFAmi5tMEACgkQTKlvDmfn 2fijygf/cObqk6h2BJwb8n3nmXQ/Nreub1lFl1FpPiFtHs8ZvDAHl45j9yvDGdmB lOKV7Bi4FVm4YV6xwH071QPbMbCvOSFSWXYJ33bD3bnGtOWjwzctdQcQ1WQTV6vu vwyw1NsMgTmSTTSVIBp1u1MLYbfqscumgU59hZskecRiV0+5HFNG6kh5paAKI8Af JPUFjEn7PeB3RnXb4KUDhvBTg/wbw3sYZ6+3p6fmvruPdAUC6SZyYTeVjVTudJ2b wGUVIrJ8uUtYORXsxDdFfpuz3RvE4IMFIgqLbNE09kQqBst02rCuMKDo4+C4FyN3 7qJswvq5noCgodr4VF9kLiejZUPhOg== =IRKu -----END PGP SIGNATURE----- --=-KOShI8kCLQa51ioAIcB+--