Re: logging stuff - Mailing list pgsql-hackers

From scott.marlowe
Subject Re: logging stuff
Date
Msg-id Pine.LNX.4.33.0308051010070.13157-100000@css120.ihs.com
Whole thread Raw
In response to logging stuff  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: logging stuff
List pgsql-hackers
On Tue, 5 Aug 2003, Andrew Dunstan wrote:

> 
> (Responding to the deafening silence regarding my posts a couple of days 
> ago about logging dbnames and disconnections) ;-)
> 
> The dbname patch is now done. If nobody objects to the format 
> ("[db:yourdbname]") I'll submit it - I did it that way to make it fairly 
> easy to split a log file based on it, although you would have to be 
> careful with multiline log entries such as query strings. It is 
> intentionally minimalist.
> 
> I had some thoughts about logging disconnections - I can see a way to do 
> it via an on_proc_exit handler, I think. Then I started wondering if it 
> might be useful to log session times instead of just noting a disconnect 
> and letting the user have to calculate the time.
> 
> But I won't bother with this if there's no interest. *I* have no current 
> use for it, but I could well imagine others might. (I might too in the 
> future if I wanted to debug my connection pooling app).

Actually, I'd certainly like to see it done (both dbname and disconnect).

I'd guess the deafening silence was more because of no objctions than lack 
of interest.  I know for me it was.



pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: logging stuff
Next
From: Andrew Dunstan
Date:
Subject: Re: status of dbf2pg