We would like to log sql activity from our web pages that
use postgresql databases. I read the documentation for 8.1 at postgresql.org. The
postgresql.conf file under the -Where to log- section has #log_destination = 'stderr' Is stderr the default or do I need to remove the comment
symbol to actually start logging to stderr? Are there recommended settings for all the different items
in where to log, when to log, and what to log? Our goal is to capture errors like when someone claims to
have submitted data, yet it is not in the database, and the record count skips
an increment—5360 then 5362, missing 5361. Thanks Marc |