Thanks Phil- That was exactly what I needed. A couple of notes that might help others-
My goal was to get all of the SQL statements from a JDBC front-end to be logged as they are executed in the postgres.log file (and not in the syslog.) Adding the following to my postgresql.conf did the job: syslog = 0 silent_mode = off debug_print_query = on debug_pretty_print = on I'm not sure if the pretty print option does anything for the SQL, but it didn't hurt. -Nick > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Phil Geer > Sent: Monday, September 23, 2002 7:25 PM > To: [EMAIL PROTECTED]; pgsql-admin > Subject: Re: [ADMIN] logging queries > > > Here is a link to the doc you need. > > http://www.postgresql.org/idocs/index.php?runtime-config.html#LOGGING > > DEBUG_PRINT_QUERY (boolean) > DEBUG_PRINT_PARSE (boolean) > DEBUG_PRINT_REWRITTEN (boolean) > DEBUG_PRINT_PLAN (boolean) > DEBUG_PRETTY_PRINT (boolean) > > Hope this helps > Phil > ----- Original Message ----- > From: "Nick Fankhauser" <[EMAIL PROTECTED]> > To: "pgsql-admin" <[EMAIL PROTECTED]> > Sent: Monday, September 23, 2002 6:05 PM > Subject: [ADMIN] logging queries > > > > Hi- > > > > I'd like to set the logging or debug level so that the text of > the queries > > that are executed show up in the log file. It seems to me that I recall > this > > being discussed before, but I can't find any specific references in the > > runtime-config portion of the docs. > > > > Can someone tell me if this is possible & if so, what runtime > settings are > > needed? > > > > Thanks > > > > -Nick > > > > > -------------------------------------------------------------------------- > > Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax > 1.765.962.9788 > > Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster > ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
