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 1utpbR-00EZsz-ON for pgsql-general@arkaria.postgresql.org; Wed, 03 Sep 2025 15:40:55 +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 1utpbQ-00A1be-OX for pgsql-general@arkaria.postgresql.org; Wed, 03 Sep 2025 15:40:53 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1utpbQ-00A1bV-Bc for pgsql-general@lists.postgresql.org; Wed, 03 Sep 2025 15:40:52 +0000 Received: from mout02.posteo.de ([185.67.36.66]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1utpbO-000LvN-0S for pgsql-general@lists.postgresql.org; Wed, 03 Sep 2025 15:40:51 +0000 Received: from submission (posteo.de [185.67.36.169]) by mout02.posteo.de (Postfix) with ESMTPS id 2F01A240103 for ; Wed, 3 Sep 2025 17:40:46 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=posteo.de; s=2017; t=1756914046; bh=Fv0vrFlGoxEipkv1iERdtQ2i3r+OCwM9oOnnTUHllsU=; h=Date:From:Subject:To:MIME-Version:Autocrypt:Message-Id: Content-Type:From; b=ryIjSeso1MHodRmNMPCuNLULVNr9lVzbl4UOcH3e98EydDzce7A4vW69O3L4hKFJ4 IdpQJ8oP80bDnMORWg7AjkOfwzwvtEmgdfsbOGSr8U2XP6ISQsFdu8TICCh/EePNTg kjFUJDlAjXDJ5V143rjhO9RY2uH5nEEDys59kknEZR9Wp9WAJr+9QgD0B5J4nHfCpn koxAZu2YCfd8ik4TmlAhrvjMHJLAFgISzzInPRRTusEUrSHWP3mIfNFTXdpH/uAxJB daOjgDJ5ggevhMGgiB6nQimJ6ip3zd4Bv1bSKdM2RWVhFYOxwDPZ0hf3QekKX/7vK+ SNUMwlJyykobA== Received: from customer (localhost [127.0.0.1]) by submission (posteo.de) with ESMTPSA id 4cH6JY4YP8z9rxR for ; Wed, 3 Sep 2025 17:40:45 +0200 (CEST) Received: from deneb (localhost [127.0.0.1]) by deneb.fritz.box (Postfix) with ESMTP id AAE5A3004A1 for ; Wed, 03 Sep 2025 17:40:44 +0200 (CEST) Date: Wed, 03 Sep 2025 15:40:45 +0000 From: Albrecht =?iso-8859-1?b?RHJl3w==?= Subject: Q: limit the length of log file entries? To: pgsql-general@lists.postgresql.org MIME-Version: 1.0 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="=-rgI2AKbjFFHtIDFIzcKF" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --=-rgI2AKbjFFHtIDFIzcKF Content-Type: text/plain; charset=UTF-8 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Hi all, I wonder if it would be possible to limit the length of individual log line= s being written to the log file. Background: I have a PL/PGsql DB function 'addval(_id text, _data bytea) RETURNS VOID'.= When a broken bytea is passed as 2nd parameter, something like albrecht@test FEHLER: ung=C3=BCltige hexadezimale Ziffer: =C2=BBr=C2=AB be= i Zeichen 28 albrecht@test ANWEISUNG: SELECT FROM addval('hopp', '\xbroken') is printed in the log file. This is fine and very helpful in this case, bu= t I have a =E2=80=9Cfriendly user=E2=80=9D who transmitted a broken hex str= ing of ~100 KBytes as second parameter, resulting in a log line of this siz= e which is not really readable and when done frequently quickly fills the l= ogs. The log settings are, inter alia log_parameter_max_length =3D 256 log_parameter_max_length_on_error =3D 256 log_error_verbosity =3D TERSE but seem to have not the desired effect in this case. I use PostgreSQL version 17.6-1.pgdg13+1 on Debian Trixie. Thanks in advance for any help, Albrecht. --=-rgI2AKbjFFHtIDFIzcKF Content-Type: application/pgp-signature; name=openpgp-digital-signature.asc Content-Description: This is a digitally signed message part. -----BEGIN PGP SIGNATURE----- iQEzBAABCgAdFiEEcCEPemLFTtyGf4zATKlvDmfn2fgFAmi4YWsACgkQTKlvDmfn 2fg0OAf/aV0X/ff9+dp10NQynr2b2s3rSrGkKUY2KcO2Q+TIIZmjja0ayms+5T6G O7+QmLYF2uyUUgCaGh3/krYQmWQASdBq6bLxlBTHLHB/UZ2v9+FTJgBxA4nbmfZo +QMUPTWttaorKsgR0NRrBBQLMNIVHr1IKH02uf5dqFC8Ap8cQ0GaJNIX4qZEhdyM r754KtHrfi2/7cHPeRIRiq5bRJRl1GH4RPlybGUAwDvpfTTmv4TakDy76U2sX2W4 0p0ftrfUOs27nIvmEmK9+hUwE1GIYqiwhPPr53+F/8qlK1XfLgx8GTYnizQsHF8S 1Kp6iggKoqQ4jCw15D6/dmHkxj0TIA== =+1gm -----END PGP SIGNATURE----- --=-rgI2AKbjFFHtIDFIzcKF--