Re: Loggin SQL Statements from JBOSS/JDBC - Mailing list pgsql-general

From Richard Huxton
Subject Re: Loggin SQL Statements from JBOSS/JDBC
Date
Msg-id 200311141707.37699.dev@archonet.com
Whole thread Raw
In response to Loggin SQL Statements from JBOSS/JDBC  ("Thomas LeBlanc" <thomasatiem@hotmail.com>)
List pgsql-general
On Friday 14 November 2003 16:15, Thomas LeBlanc wrote:
> Are there settings in PostgreSQL to log SQL Statements from client apps?
>
> Is yes, where are they logged to?
>
> We set log_statement=On, but where does the log get sritten to?

Depends on how you start PG - you'll need to check your startup scripts.

If you want to, you can set it up to use syslog (set syslog=2, see the
relevant section of the manuals)



--
  Richard Huxton
  Archonet Ltd

pgsql-general by date:

Previous
From: Manfred Koizar
Date:
Subject: Re: Conservation of OIDs
Next
From: "Thomas LeBlanc"
Date:
Subject: Re: Loggin SQL Statements from JBOSS/JDBC