Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id A088E9FB654 for ; Tue, 19 Jun 2007 11:52:22 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 77751-08 for ; Tue, 19 Jun 2007 11:52:10 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from lists.commandprompt.com (host-254.commandprompt.net [207.173.203.254]) by postgresql.org (Postfix) with ESMTP id 10E6F9FB5C7 for ; Tue, 19 Jun 2007 11:52:18 -0300 (ADT) Received: from perhan.alvh.no-ip.org (190-13-143-52.bk13-dsl.surnet.cl [190.13.143.52]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id l5JEqERK026709; Tue, 19 Jun 2007 07:52:14 -0700 Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id A94A432A23; Tue, 19 Jun 2007 10:52:11 -0400 (CLT) Date: Tue, 19 Jun 2007 10:52:11 -0400 From: Alvaro Herrera To: Mario Splivalo Cc: pgsql-admin@postgresql.org Subject: Re: Postgres8.2 - turning off BINGLOG/PARSELOG Message-ID: <20070619145211.GM4265@alvh.no-ip.org> References: <1182263472.13561.43.camel@localhost.localdomain> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1182263472.13561.43.camel@localhost.localdomain> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: ClamAV version 0.88.5, clamav-milter version 0.88.5 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Tue, 19 Jun 2007 07:52:15 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/171 X-Sequence-Number: 25839 Mario Splivalo wrote: > I'm finaly switching to 8.2. I notice that ugly 'feature' from pg8.1 has > been fixed: logging the parametars of prepared statements. It's a bit > ugly, but it's there :) > 2007-06-19 16:22:15.555 CEST [4596] BINDLOG: duration: > 0.027 ms bind S_2: COMMIT > 2007-06-19 16:22:15.556 CEST [4596] COMMITLOG: duration: > 0.029 ms execute S_2: COMMIT > > log_line_prefix = '%m [%p] <%d> %i' One thing you should be aware of is that PARSELOG etc are really "PARSE" and "LOG", but there is no intervening space since you put no space at the end of log_line_prefix. So I suggest changing it to log_line_prefix = '%m [%p] <%d> %i ' Now, regarding your question, > Is there a way to turn off these PARSELOG and BINDLOG messages? I realy > need only the SELECTLOG (and SELECTDETAIL because there are the actuall > parametars)? I don't think so. You can increase log_min_duration_statement a bit so that only statements that take "long" are logged. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support