X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id A286BD1C511 for ; Mon, 17 May 2004 20:19:17 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 39266-01 for ; Mon, 17 May 2004 20:18:59 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id AE8E6D1CA41 for ; Mon, 17 May 2004 20:18:56 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i4HNIuSx041227 for ; Mon, 17 May 2004 23:18:56 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i4HNCXXW033651 for pgsql-admin@postgresql.org; Mon, 17 May 2004 23:12:33 GMT From: Gaetano Mendola X-Newsgroups: comp.databases.postgresql.admin Subject: Re: Log msg Date: Tue, 18 May 2004 01:12:23 +0200 Organization: PYRENET Midi-pyrenees Provider Lines: 30 Message-ID: <40A946D7.2060508@bigfoot.com> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@pyrenet.fr To: Jie Liang User-Agent: Mozilla Thunderbird 0.6 (Windows/20040502) X-Accept-Language: en-us, en In-Reply-To: To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200405/170 X-Sequence-Number: 13486 Jie Liang wrote: > Hi,All, > > > How to config log file to log statement without CONTEXT stuff? I want > log query, but not the detail unless there is a problem, > e.g. Delete aaa from mytable where mysqlfunction(bbb); > I want log this statement, > but not any CONTEXT inside mysqlfunction, because it will easily filled > up my disk if mytable have millions of entries, meanwhile, the log file > become useless. > But if I set log_statement = true, log file will log millions of > statement in mysqlfunction, but I set log_statement=false, log file > won't log query at all. > Simply say, I want log what I execute(my query), but not how execute > (process) . Decrease the verbosity of your logs using: log_error_verbosity = terse Regards Gaetano Mendola