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.98.2) (envelope-from ) id 1xA7Zj-00000002So8-3vek for pgsql-docs@arkaria.postgresql.org; Fri, 25 Sep 2026 15:11:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xA7Zi-00000001KfQ-0Exl for pgsql-docs@arkaria.postgresql.org; Fri, 25 Sep 2026 15:10:58 +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.98.2) (envelope-from ) id 1xA7Zh-00000001KfI-3Cpi for pgsql-docs@lists.postgresql.org; Fri, 25 Sep 2026 15:10:57 +0000 Received: from mail-wr2-x0f.google.com ([2a00:1450:4864:30::f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1xA7Ze-00000001DOZ-1h8j for pgsql-docs@lists.postgresql.org; Fri, 25 Sep 2026 15:10:56 +0000 Received: by mail-wr2-x0f.google.com with SMTP id ffacd0b85a97d-488811c9ebaso366677f8f.2 for ; Fri, 25 Sep 2026 08:10:54 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1790349053; x=1790953853; darn=lists.postgresql.org; h=mime-version:user-agent:content-type:references:in-reply-to:date:to :from:subject:message-id:from:to:cc:subject:date:message-id:reply-to :content-type; bh=78CgWMPPwuxzt1wDfFZM2mhki7WcjR0Yj8qG7fwW8fk=; b=Ocrzekx3GkOanRtW/DsmMQoHGH/23HCciAQ1V78msNvEZqPqBIvMEeICjjmlLXLl2M MpTbOiTz+s5ZwRBgfb9q9e5KJHIGdkPSTch96nfmn+a/BrBZAUMmzrmKoaB0rgXeXDHC oOIOsZyAP/J/IxymbHuVX7tlA07aU+dX0UNkUi07Q+fDoWvPfGTzuamjnuPHUVDEklBJ u+IbkeuKbw6+1KfLOuZy113/4UqLXePYlysDXxspPjf5YtGj58f3ByWvS3uOjvLdH/wq zaktYhWeB+BCXBgsm8hClhE1+EnGO8UBez+qERt21+yHPbxAj+O7SawF2eTl0tWOdixp hlTg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20260707; t=1790349053; x=1790953853; h=mime-version:user-agent:content-type:references:in-reply-to:date:to :from:subject:message-id:x-gm-gg:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to:content-type; bh=78CgWMPPwuxzt1wDfFZM2mhki7WcjR0Yj8qG7fwW8fk=; b=WHB8x56Orwd79PDC/NBIhBjThZ4/NOYxZLPVEC2xtZK18Viuso1aeUPU/XmGnRP+DS M1L2Z53vRj2GTfVbmrNe5iG/LgBSNzGz4szQrf23XwikSSsUvWKDRAbm1wo1etZvoKIz z35f/XdfE6HjKRhWxzt6scQFFtwQawzN+tzp7TJkG0Hz+P2HKuKMPE8x4Y1BqxmCtMhk aEywK97V8Hroil2mHpN+MAtb3WODviqmJ0jZQneW65GzDprUj0vHAT672ZVx80mAA8GC lqTGDsivwxupFkSnnZ73aMZak0Uj/MkXMhik1HL601WPckDWNEsEKFhd6qgdmJH+TdHx XPTA== X-Forwarded-Encrypted: i=1; AKwUvBxDKkFX95mKw+vn1ayAHbO4o7xrB6zMZoGGQ+7KOVnU8RZuOeKNoyx7iup34s+YrsN04om4/bNdUOBp@lists.postgresql.org X-Gm-Message-State: AFuF++l3GlWc4B7VnZMziruKlpjUhFlXLuMAe3vF5EnipxqEsZgBs29w lRx3M1YPXaHHqto7HRKJZX2pMd6fqz70bYkTUO5Ghrs2Srk/ccAr+4yLZAq+k+08H9Kk8gPEO68 EH5cA X-Gm-Gg: AYBFou3g/2EAqB0Y/xTsdPNtEZ/8PtO1ds15tims9wZ2EBzgKQkpfFxdnPYEesCH3CF +Ge4LyIzMNFKqUAe7b1jJJOfGcVhhbGk8cQImSn6RoeHSA5+3H1Cx6EGpG828b8fvaqBsJFDFto yISz1An9t1Rv844YFfY6Z23lgDpCmr90+su/tWcm+8R3Cn98UZ/yiDfMFCZ9GCYL7bSR1sCJzQ+ 1d/oN5dhSOosogmkjFCvjGzJUMrQBzvb71QmXPmU/5kBBeEzQrqm/Wba35NpBclegxfOo2DBye+ yC0QqwqT++moWjb6BBHqnSv7MqF+BpbASqsTc+c/3+BYQiQVH3Bewnr3kpACxLAKjRR8VHQuoFS +gerh+5j4g1VzD2Bmyascqdc5CT6T0F8rVlFoGlSXnONBjWLhK1z+HGCyGaHOvPKWoYWiPMMNhA PRAtnF57uR0Def8tXy3vKonS8W5betHCvJrJTLaHFzbeoRD4q6mN2jqhdDs/8s5ECuZYk6CRo0d NfdYgsKpBkLsU8XTAG69bOuhffH X-Received: by 2002:a5d:5f88:0:b0:486:e920:6726 with SMTP id ffacd0b85a97d-488716ad408mr12170312f8f.51.1790349052879; Fri, 25 Sep 2026 08:10:52 -0700 (PDT) Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:70:5cd8:b34a:1a0f:f6eb:95a9]) by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-4887a64f9bcsm7862363f8f.32.2026.09.25.08.10.51 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 25 Sep 2026 08:10:52 -0700 (PDT) Message-ID: <42af2f4ed8afe739f2e8f8add80100b2ba2d7808.camel@cybertec.at> Subject: Re: log_line_prefix and JSON log format From: Laurenz Albe To: michael@schoenitzer.de, pgsql-docs@lists.postgresql.org Date: Fri, 25 Sep 2026 17:10:50 +0200 In-Reply-To: <179032875673.1026201.6950455317699774504@wrigleys.postgresql.org> References: <179032875673.1026201.6950455317699774504@wrigleys.postgresql.org> Content-Type: multipart/mixed; boundary="=-1gZoclWpmZxtqSg6AlLG" User-Agent: Evolution 3.60.2 (3.60.2-2.fc44) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --=-1gZoclWpmZxtqSg6AlLG Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Fri, 2026-09-25 at 09:32 +0000, PG Doc comments form wrote: > Page: https://www.postgresql.org/docs/18/index.html >=20 > I noticed, that it not documented anywhere what log_line_prefix will do, = if > log_destination =3D 'jsonlog' (Or CSV). From my tests it seems it is igno= red > and does nothing. But we weren't sure and would be helpful to have this > documented. True; here is a patch. Yours, Laurenz Albe --=-1gZoclWpmZxtqSg6AlLG Content-Disposition: attachment; filename="v1-0001-Doc-no-log_line_prefix-in-csvlog-or-jsonlog.patch" Content-Type: text/x-patch; name="v1-0001-Doc-no-log_line_prefix-in-csvlog-or-jsonlog.patch"; charset="ISO-8859-1" Content-Transfer-Encoding: base64 RnJvbSA2NmE2NjllZmIwZDY1YTkwMTZkOTBhYTQ5ZDczMjlkNzA5YjM3NzZhIE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5h dD4KRGF0ZTogRnJpLCAyNSBTZXAgMjAyNiAxNzowNDozOCArMDIwMApTdWJqZWN0OiBbUEFUQ0gg djFdIERvYzogbm8gbG9nX2xpbmVfcHJlZml4IGluIGNzdmxvZyBvciBqc29ubG9nCk1JTUUtVmVy c2lvbjogMS4wCkNvbnRlbnQtVHlwZTogdGV4dC9wbGFpbjsgY2hhcnNldD1VVEYtOApDb250ZW50 LVRyYW5zZmVyLUVuY29kaW5nOiA4Yml0CgpUaGUgZG9jdW1lbnRhdGlvbiBkaWRuJ3QgbWFrZSBj bGVhciB0aGF0ICJsb2dfbGluZV9wcmVmaXgiIGlzCm5vdCBvdXRwdXQgaWYgImxvZ19kZXN0aW5h dGlvbiIgaXMgImNzdmxvZyIgb3IgImpzb25sb2ciLgoKQXV0aG9yOiBMYXVyZW56IEFsYmUgPGxh dXJlbnouYWxiZUBjeWJlcnRlYy5hdD4KUmVwb3J0ZWQtYnk6IE1pY2hhZWwgU2Now7ZuaXR6ZXIg PG1pY2hhZWxAc2Nob2VuaXR6ZXIuZGU+CkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20v MTc5MDMyODc1NjczLjEwMjYyMDEuNjk1MDQ1NTMxNzY5OTc3NDUwNEB3cmlnbGV5cy5wb3N0Z3Jl c3FsLm9yZwotLS0KIGRvYy9zcmMvc2dtbC9jb25maWcuc2dtbCB8IDMgKystCiAxIGZpbGUgY2hh bmdlZCwgMiBpbnNlcnRpb25zKCspLCAxIGRlbGV0aW9uKC0pCgpkaWZmIC0tZ2l0IGEvZG9jL3Ny Yy9zZ21sL2NvbmZpZy5zZ21sIGIvZG9jL3NyYy9zZ21sL2NvbmZpZy5zZ21sCmluZGV4IDAxNjVl YjllYzAyLi5mMjc3ZDMxMTIzMiAxMDA2NDQKLS0tIGEvZG9jL3NyYy9zZ21sL2NvbmZpZy5zZ21s CisrKyBiL2RvYy9zcmMvc2dtbC9jb25maWcuc2dtbApAQCAtODIyNCw3ICs4MjI0LDggQEAgbG9j YWwwLiogICAgL3Zhci9sb2cvcG9zdGdyZXNxbAogICAgICAgPGxpc3RpdGVtPgogICAgICAgIDxw YXJhPgogICAgICAgICAgVGhpcyBpcyBhIDxmdW5jdGlvbj5wcmludGY8L2Z1bmN0aW9uPi1zdHls ZSBzdHJpbmcgdGhhdCBpcyBvdXRwdXQgYXQgdGhlCi0gICAgICAgICBiZWdpbm5pbmcgb2YgZWFj aCBsb2cgbGluZS4KKyAgICAgICAgIGJlZ2lubmluZyBvZiBlYWNoIGxvZyBsaW5lLCBleGNlcHQg d2hlbiA8dmFybmFtZT5sb2dfZGVzdGluYXRpb248L3Zhcm5hbWU+CisgICAgICAgICBpcyA8bGl0 ZXJhbD5jc3Zsb2c8L2xpdGVyYWw+IG9yIDxsaXRlcmFsPmpzb25sb2c8L2xpdGVyYWw+LgogICAg ICAgICAgPGxpdGVyYWw+JTwvbGl0ZXJhbD4gY2hhcmFjdGVycyBiZWdpbiA8cXVvdGU+ZXNjYXBl IHNlcXVlbmNlczwvcXVvdGU+CiAgICAgICAgICB0aGF0IGFyZSByZXBsYWNlZCB3aXRoIHN0YXR1 cyBpbmZvcm1hdGlvbiBhcyBvdXRsaW5lZCBiZWxvdy4KICAgICAgICAgIFVucmVjb2duaXplZCBl c2NhcGVzIGFyZSBpZ25vcmVkLiBPdGhlcgotLSAKMi41NS4wCgo= --=-1gZoclWpmZxtqSg6AlLG--