Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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: log_line_info.patch2
Description: text/plain (18.8 KB)

Responses

pgsql-hackers by date

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

pgsql-patches by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group