Re: [GENERAL] Loggin SQL Statements from JBOSS/JDBC

[Thomas LeBlanc]

Where are the log files written?

Thanks,
Thomas LeBlanc

From: Richard Huxton <[EMAIL PROTECTED]>
To: "Thomas LeBlanc" <[EMAIL PROTECTED]>,[EMAIL PROTECTED]
Subject: Re: [GENERAL] Loggin SQL Statements from JBOSS/JDBC
Date: Fri, 14 Nov 2003 17:07:37 +0000
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
_________________________________________________________________
From Beethoven to the Rolling Stones, your favorite music is always playing 
on MSN Radio Plus. No ads, no talk. Trial month FREE!  
http://join.msn.com/?page=offers/premiumradio

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings