Re: [JDBC] Logging Queries

From: Peter Mount <peter(at)retep(dot)org(dot)uk>
To: Hunter Hillegas <lists(at)lastonepicked(dot)com>, PostgreSQL <pgsql-general(at)postgresql(dot)org>, Postgre JDBC <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: [JDBC] Logging Queries
Date: 2001-03-29 09:20:44
Message-ID: 5.0.2.1.0.20010329101851.01ff1aa0@mail.retep.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

At 12:01 27/03/01 -0800, Hunter Hillegas wrote:
>I'm having a problem with queries sent in from a Java program.
>
>Is there any way to have the server log the queries that are coming in so I
>can see what's actually getting processed?

From the server:
Can't remember which, but -d1 or -d2 when you start the postmaster
sometimes works (higher values show too much detail like the query plans etc).

From within the driver: use DriverManager.setLogStream()

PeterM

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Karel Zak 2001-03-29 09:30:29 Re: stored procedure and timestamp
Previous Message Peter Mount 2001-03-29 09:12:45 Re: fastpath error?

Browse pgsql-jdbc by date

  From Date Subject
Next Message Eric Frazier 2001-03-29 10:14:32 Re: [JDBC] Logging Queries
Previous Message Peter Mount 2001-03-29 09:12:45 Re: fastpath error?