Received: from maia.hub.org (maia-4.hub.org [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 210E363559C for ; Tue, 11 May 2010 15:06:34 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 27197-03 for ; Tue, 11 May 2010 18:06:26 +0000 (UTC) X-Greylist: delayed 00:19:03.803587 by SQLgrey-1.7.6 Received: from ndmsnpf01.ndc.nasa.gov (ndmsnpf01.ndc.nasa.gov [198.117.0.121]) by mail.postgresql.org (Postfix) with ESMTP id 7648D633EBD for ; Tue, 11 May 2010 15:05:35 -0300 (ADT) Received: from ndmsppt02.ndc.nasa.gov (ndmsppt02.ndc.nasa.gov [198.117.0.101]) by ndmsnpf01.ndc.nasa.gov (Postfix) with ESMTP id 50140278093 for ; Tue, 11 May 2010 12:46:30 -0500 (CDT) Received: from ndmshub01.ndc.nasa.gov (ndmshub01-pub.ndc.nasa.gov [198.117.0.160]) by ndmsppt02.ndc.nasa.gov (8.14.3/8.14.3) with ESMTP id o4BHkUtB008347 for ; Tue, 11 May 2010 12:46:30 -0500 Received: from LRC000959195.larc.nasa.gov (198.119.134.170) by smtp02.ndc.nasa.gov (198.117.0.160) with Microsoft SMTP Server (TLS) id 8.1.393.1; Tue, 11 May 2010 12:46:30 -0500 Message-ID: <4BE997F0.7030402@nasa.gov> Date: Tue, 11 May 2010 13:46:24 -0400 From: "Maria L. Wilson" Reply-To: Maria.L.Wilson-1@nasa.gov Organization: SSAI User-Agent: Thunderbird 2.0.0.24 (Macintosh/20100228) MIME-Version: 1.0 To: "pgsql-admin@postgresql.org" Subject: Logging parameters Content-Type: text/plain; charset="ISO-8859-1"; format=flowed Content-Transfer-Encoding: 7bit X-Proofpoint-Virus-Version: vendor=fsecure engine=1.12.8161:2.4.5, 1.2.40, 4.0.166 definitions=2010-05-11_04:2010-02-06, 2010-05-11, 2010-05-11 signatures=0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-4.21 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_MED=-2.3, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201005/119 X-Sequence-Number: 34592 Trying to do some modifications to the amount of logging that our postgres database server (8.4 on linux) does on our production servers and had a few questions that I hope someone would clear up. Basically - in production, it would be nice to limit some of the logging and let the dev/test database servers be the most verbose. It was my understanding that I could do this by setting log_min_duration_statement to some large interval and I would not see all the other SQL. This does not seem to be the case. What it looks like it's doing is just not showing the duration of the SQL unless it is longer than this parameter. What I'm trying to do is limit what is logged on production to be only the necessary stuff.... Here's my parameters currently..... #client_min_messages = notice #log_min_messages = notice #log_error_verbosity = default # terse, default, or verbose messages #log_min_error_statement = error log_min_duration_statement = 2000 # -1 is disabled, 0 logs all statements # and their durations. #silent_mode = off debug_pretty_print = on log_connections = on log_disconnections = on log_duration = on log_line_prefix = '%u %h %m [%p] [%d] ' # Special values: log_statement = 'all' # none, ddl, mod, all Could you all give me some recommendations?? thanks!! Maria Wilson NASA/Langley Research Center Hampton, Virginia 23681