Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 45C91171224E for ; Tue, 6 Mar 2012 17:43:20 -0400 (AST) Received: from qmta06.westchester.pa.mail.comcast.net ([76.96.62.56]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1S52A9-0006VV-M7 for pgsql-admin@postgresql.org; Tue, 06 Mar 2012 21:43:19 +0000 Received: from omta23.westchester.pa.mail.comcast.net ([76.96.62.74]) by qmta06.westchester.pa.mail.comcast.net with comcast id iH6G1i0061c6gX856Mj3nA; Tue, 06 Mar 2012 21:43:03 +0000 Received: from homie ([68.45.149.190]) by omta23.westchester.pa.mail.comcast.net with comcast id iMj31i02S46izrY3jMj3dB; Tue, 06 Mar 2012 21:43:03 +0000 Received: by homie (Postfix, from userid 1000) id EA81E181952; Tue, 6 Mar 2012 16:43:01 -0500 (EST) To: "Campbell\, Lance" Cc: "pgsql-admin\@postgresql.org" Subject: Re: logging issue References: From: Jerry Sievers Date: Tue, 06 Mar 2012 16:43:01 -0500 In-Reply-To: (Lance Campbell's message of "Tue\, 6 Mar 2012 21\:04\:23 +0000") Message-ID: <87aa3tpfru.fsf@comcast.net> User-Agent: Gnus/5.11 (Gnus v5.11) Emacs/22.2 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Pg-Spam-Score: -0.7 (/) X-Archive-Number: 201203/18 X-Sequence-Number: 39206 "Campbell, Lance" writes: > PostgreSQL 9.1.3 > > I just moved our test database from PostgreSQL 9.0 to 9.1. I also > changed my log settings. I am seeing every single SQL statement > that PostgreSQL performs by my Java applications. Is there some way > to only display the details when there is an error? I would assume > yes. But for some reason I am getting all SQL statements. I just > want the errors. I have included below my settings for the logging > section. Any help would be greatly appreciated. Thanks! > Change log_statement to 'none' and pg_ctl reload the server. -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consulting@comcast.net p: 305.321.1144