By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,660 Members | 1,299 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,660 IT Pros & Developers. It's quick & easy.

Loggin SQL Statements from JBOSS/JDBC

P: n/a
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 holidays! Snappier product search...
http://shopping.msn.com
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.