Re: logging

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