On 9/28/16 6:13 PM, Robert Haas wrote: > Christoph/Debian: > log_line_prefix = '%t [%p-%l] %q%u@%d ' > Peter: > log_line_prefix = '%t [%p]: [%l] %qapp=%a '
I'm aware of two existing guidelines on log line formats: syslog and pgbadger. Syslog output looks like this: Sep 28 00:58:56 hostname syslogd[46]: some text here pgbadger by default asks for this: log_line_prefix = '%t [%p]: [%l-1] user=%u,db=%d,app=%a,client=%h ' I don't know why it wants that "-1" there, and I'm actually not sure what the point of %l is in practice. Those are separate issues that are having their own lively discussions at times. I could drop the [%l] from my proposal if that causes concerns. On balance, I think my proposal is more in line with existing wide-spread conventions. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers