From: Gaetano Mendola <mendola@bigfoot.com>
To: Theo Galanakis <Theo.Galanakis@lonelyplanet.com.au>
Subject: Re: logging
Date: Fri, 01 Oct 2004 10:37:21 +0200
Message-ID: <415D1741.3010006@bigfoot.com> (raw)
In-Reply-To: <82E30406384FFB44AFD1012BAB230B5505F40D1B@shiva.au.lpint.net>
References: <82E30406384FFB44AFD1012BAB230B5505F40D1B@shiva.au.lpint.net>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: mendola@bigfoot.com, Theo.Galanakis@lonelyplanet.com.au
Subject: Re: logging
In-Reply-To: <415D1741.3010006@bigfoot.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox