pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: Add local-address escape "%L" to log_line_prefix.
Date: Mon, 07 Apr 2025 15:06:17 +0000
Message-ID: <E1u1o3F-0038Vk-1v@gemulon.postgresql.org> (raw)

Add local-address escape "%L" to log_line_prefix.

This escape shows the numeric server IP address that the client
has connected to.  Unix-socket connections will show "[local]".
Non-client processes (e.g. background processes) will show "[none]".

We expect that this option will be of interest to only a fairly
small number of users.  Therefore the implementation is optimized
for the case where it's not used (that is, we don't do the string
conversion until we have to), and we've not added the field to
csvlog or jsonlog formats.

Author: Greg Sabino Mullane <htamfids@gmail.com>
Reviewed-by: Cary Huang <cary.huang@highgo.ca>
Reviewed-by: David Steele <david@pgmasters.net>
Reviewed-by: Jim Jones <jim.jones@uni-muenster.de>
Reviewed-by: Tom Lane <tgl@sss.pgh.pa.us>
Discussion: https://postgr.es/m/CAKAnmmK-U+UicE-qbNU23K--Q5XTLdM6bj+gbkZBZkjyjrd3Ow@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/3516ea768c92ad0abc16dc4dd97e5eef6eab4237

Modified Files
--------------
doc/src/sgml/config.sgml                      |  6 +++++
src/backend/utils/error/elog.c                | 33 +++++++++++++++++++++++++++
src/backend/utils/misc/postgresql.conf.sample |  1 +
src/include/libpq/libpq-be.h                  |  3 +++
4 files changed, 43 insertions(+)



Message-ID: <E1u1o3F-0038Vk-1v@gemulon.postgresql.org>
Permalink:  ../E1u1o3F-0038Vk-1v@gemulon.postgresql.org/
Also on:    postgresql.org/message-id/E1u1o3F-0038Vk-1v@gemulon.postgresql.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-committers@postgresql.org
  Cc: tgl@sss.pgh.pa.us, pgsql-committers@lists.postgresql.org
  Subject: Re: pgsql: Add local-address escape "%L" to log_line_prefix.
  In-Reply-To: <E1u1o3F-0038Vk-1v@gemulon.postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox