Re: logging queries

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: pgsql-admin-owner(at)postgresql(dot)org
> [mailto:pgsql-admin-owner(at)postgresql(dot)org]On Behalf Of Phil Geer
> Sent: Monday, September 23, 2002 7:25 PM
> To: nickf(at)ontko(dot)com; 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" <nickf(at)ontko(dot)com>
> To: "pgsql-admin" <pgsql-admin(at)postgresql(dot)org>
> 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 nickf(at)ontko(dot)com 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 majordomo(at)postgresql(dot)org)