[GENERAL] Loggin SQL Statements from JBOSS/JDBC

2003-11-14 Thread Thomas LeBlanc
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? Thanks, Thomas LeBlanc _ MSN Shopping upgraded for the holida

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

2003-11-14 Thread Richard Huxton
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 start

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

2003-11-14 Thread Richard Huxton
On Friday 14 November 2003 17:08, Thomas LeBlanc wrote: > Where are the log files written? Usually somewhere in /var/log/ but it depends on your startup script. If you're on RedHat Linux and using the RPMs then your startup script is /etc/init.d/postgresql and it seems to redirect to /dev/null (

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

2003-11-14 Thread 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 + On Friday 14 Novem