log_line_info

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: "Patches (PostgreSQL)" <pgsql-patches(at)postgresql(dot)org>
Subject: log_line_info
Date: 2004-02-23 18:09:06
Message-ID: 403A41C2.6000705@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches


Attached is a patch for tagging log lines produced by backends. It is
not quite ready for application - this is for people to look over and
play with.

For my testing I used the following settings:

log_connections = true
log_disconnections = true
log_line_info = '%T [%P] %U(at)%D(%C:%S) %I line:%L '
log_statement = true
log_hostname = true
log_source_port = true

Comments welcome

(Rod Taylor has suggested adding in escapes for remote host and remote
port. This can be done easily enough - I want to call a halt at some
stage and get the basics of this in. Extending it will then be easy).

cheers

andrew

Attachment Content-Type Size
log_line_info.patch2 text/plain 18.8 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Mosberger 2004-02-23 18:18:33 dbt-2 tests & profiling on ia64
Previous Message Marc G. Fournier 2004-02-23 18:01:01 Re: Heads up: 7.3.6 and 7.4.2 coming soon

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2004-02-24 03:41:26 Re: client_encoding in dump file
Previous Message Tom Lane 2004-02-23 04:32:00 Re: [GENERAL] dblink: rollback transaction