Re: logging sql from JDBC

Lists: pgsql-hackers
From: "David Parker" <dparker(at)tazznetworks(dot)com>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: logging sql from JDBC
Date: 2005-05-25 16:03:36
Message-ID: 07FDEE0ED7455A48AC42AC2070EDFF7C7466C6@corpsrv2.tazznetworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

It appears that SQL submited via the latest JDBC driver won't get logged
even if log_min_duration_statement is set appropriately. From what I've
found in the archives, this is because the driver uses an "extended"
version of the protocol.

Could somebody point me at the area of the source where this decision
gets made, and/or how difficult it would be to enable this logging?

Thanks!

- DAP
------------------------------------------------------------------------
----------
David Parker Tazz Networks (401) 709-5130



From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: David Parker <dparker(at)tazznetworks(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: logging sql from JDBC
Date: 2005-05-27 15:45:24
Message-ID: 1117208724.3844.556.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On Wed, 2005-05-25 at 12:03 -0400, David Parker wrote:
> Could somebody point me at the area of the source where this decision
> gets made, and/or how difficult it would be to enable this logging?

This has just been fixed for 8.1, patch recently submitted.

In the meantime, use p6spy

Best Regards, Simon Riggs