Re: logging all queries in 7.1.3

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.