Yup, someone emailed me privately - this fixed the problem.. Thanks! On Fri, Aug 27, 2010 at 2:55 AM, Thomas Kellerer <spam_eater@xxxxxxx> wrote: > Mike Christensen, 27.08.2010 11:39: >> >> Hi all - >> >> I've noticed my log files for Postgres are getting way too big, since >> every single SQL statement being run ends up in the log. However, >> nothing I change in postgresql.conf seems to make a bit of >> difference.. I've tried restarting postgres, deleting all the >> existing logs, etc. No matter what I do, every statement is logged. >> >> What I want is to only log SQL statements that result in errors. >> Here's my config options: >> >> log_destination = 'stderr' >> logging_collector = on >> client_min_messages = error >> log_min_messages = error >> log_error_verbosity = default >> log_min_error_statement = error >> log_min_duration_statement = 3000 >> log_statement = 'all' >> >> Pretty much everything else log related is commented out.. What am I >> doing wrong? Thanks! > > > log_statement = 'all' > > should be > > log_statement = 'none' > > Regards > Thomas > > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
