Thread

Re: logging all queries in 7.1.3

Thomas F.O'Connell <tfo@monsterlabs.com> — 2002-03-25T17:50:32Z

take a look at $PGDATA/postgresql.conf.

there should be a line in there involving the variable debug_print_query.

if you include the line

debug_print_query = true

and restart postmaster, all queries should be reported to whatever 
logging facility you are using.

-tfo

Chris Beams wrote:
> I'm using postgres version 7.1.3 and have found very little
> documentation on how to log queries sent to the database.  I've found
> the debugging configuration ( -d[1..4] ), but nothing as to how to log
> every select, insert, update, etc.