From: Gaetano Mendola <mendola@bigfoot.com>
Subject: Re: logging
Date: Fri, 01 Oct 2004 10:37:21 +0200
Organization: PYRENET Midi-pyrenees Provider
Lines: 25
Message-ID: <415D1741.3010006@bigfoot.com>
References: <82E30406384FFB44AFD1012BAB230B5505F40D1B@shiva.au.lpint.net>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
To: Theo Galanakis <Theo.Galanakis@lonelyplanet.com.au>
User-Agent: Mozilla Thunderbird 0.8 (Windows/20040913)
In-Reply-To: <82E30406384FFB44AFD1012BAB230B5505F40D1B@shiva.au.lpint.net>
To: pgsql-admin@postgresql.org

Theo Galanakis wrote:
> I'm currently logging postgres dubugging to syslogs and wanted to know 
> if it is possible to log which database each log entry is refering to? 
> At the moment it looks something like this :
> 
> Sep 30 02:49:59 tickle postgres[31285]: [31-1] LOG:  statement: select * 
> from content_objects^M
> Sep 30 02:49:59 tickle postgres[31285]: [31-2] ^I^I^I^Iwhere 
> content_object_id = ^M
> Sep 30 02:49:59 tickle postgres[31285]: [31-3] ^I^I^I^I^I'680'
> Sep 30 02:49:59 tickle postgres[31285]: [32-1] LOG:  duration: 1.147 ms
> 
> I was thinking of perhaps looking at the table in the sql and trying to 
> match it up the information_schema.columns and obtain the database from 
> that! However I thought that if there was a debugging option available 
> it would save a heap of time.

Unfortunately I have to say that is impossible to do it for version < 8.0
( that BTW is still in beta phase ).


Regards
Gaetano Mendola