Re: logging all queries in 7.1.3
Thomas F.O'Connell <tfo@monsterlabs.com>
From: "Thomas F. O'Connell" <tfo@monsterlabs.com>
To: pgsql-general@postgresql.org
Date: 2002-03-25T17:50:32Z
Lists: pgsql-general
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.