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.