Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id B19229FB2FF for ; Tue, 30 Jan 2007 13:27:08 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 30836-10 for ; Tue, 30 Jan 2007 13:27:03 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id 587809FA29C for ; Tue, 30 Jan 2007 13:27:02 -0400 (AST) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=phlogiston.dydns.org) by main2.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1HBwvw-0005R5-AF for pgsql-sql@postgresql.org; Tue, 30 Jan 2007 12:38:16 -0500 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id C04183FAF; Tue, 30 Jan 2007 12:26:51 -0500 (EST) Date: Tue, 30 Jan 2007 12:26:51 -0500 From: Andrew Sullivan To: pgsql-sql@postgresql.org Subject: Re: Log, Logs and more Logs Message-ID: <20070130172651.GD32170@phlogiston.dyndns.org> References: <55c095e90701300901y41197404q4c26032ff0a28e22@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <55c095e90701300901y41197404q4c26032ff0a28e22@mail.gmail.com> User-Agent: Mutt/1.5.9i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/163 X-Sequence-Number: 27315 On Tue, Jan 30, 2007 at 03:01:05PM -0200, Ezequias Rodrigues da Rocha wrote: > I know there are many logs in postgresql but I don't have many > familiarity with all them. It's not totally plain what you want to have happen -- whether you want all queries, whether you merely want ERRORs to show up in your logs, or whether you want only ERRORS to show their queries. If it's the latter, then my suggestion is to set log_min_messages to ERROR and log_min_error_statement to ERROR as well. The section of the manual you really want to read is http://www.postgresql.org/docs/8.2/static/runtime-config-logging.html A -- Andrew Sullivan | ajs@crankycanuck.ca If they don't do anything, we don't need their acronym. --Josh Hamilton, on the US FEMA