From 8b06e6aba8773df8040b357a1cb058879ed2d94f Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Mon, 6 May 2013 08:59:39 -0400 Subject: Revert idea of zer-padding padding session id in log_line_prefix Removal of doc adjustment and release note mention as well. --- doc/src/sgml/config.sgml | 6 +++--- doc/src/sgml/release-9.3.sgml | 8 -------- 2 files changed, 3 insertions(+), 11 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index 7b3e6179470..d750f0800b7 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -4089,14 +4089,14 @@ local0.* /var/log/postgresql The %c escape prints a quasi-unique session identifier, - consisting of two 4-byte hexadecimal numbers separated by a dot. - The numbers are the process start time and the + consisting of two 4-byte hexadecimal numbers (without leading zeros) + separated by a dot. The numbers are the process start time and the process ID, so %c can also be used as a space saving way of printing those items. For example, to generate the session identifier from pg_stat_activity, use this query: SELECT to_hex(EXTRACT(EPOCH FROM backend_start)::integer) || '.' || - regexp_replace('0000' || '0133e3', '^0*(.{4,})$', '\1') + to_hex(pid) FROM pg_stat_activity; diff --git a/doc/src/sgml/release-9.3.sgml b/doc/src/sgml/release-9.3.sgml index 32839b7d2f1..d64e8e357f1 100644 --- a/doc/src/sgml/release-9.3.sgml +++ b/doc/src/sgml/release-9.3.sgml @@ -78,14 +78,6 @@ - - - Have session id (%c) in log_line_prefix - always output at least four hex digits after the period (Bruce Momjian) - - - -- cgit v1.2.3