Add local-address escape "%L" to log_line_prefix.
authorTom Lane <tgl@sss.pgh.pa.us>
Mon, 7 Apr 2025 14:57:26 +0000 (10:57 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Mon, 7 Apr 2025 15:06:05 +0000 (11:06 -0400)
commit3516ea768c92ad0abc16dc4dd97e5eef6eab4237
treed15a5f73490851f950891dee762786e330c1a975
parent8f5e419484c3efb613d971ec25b9bf344db3d0b0
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
doc/src/sgml/config.sgml
src/backend/utils/error/elog.c
src/backend/utils/misc/postgresql.conf.sample
src/include/libpq/libpq-be.h