X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 8F6769FA385 for ; Thu, 17 Aug 2006 13:17:51 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 92275-09 for ; Thu, 17 Aug 2006 16:17:50 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from mail.gmx.net (mail.gmx.de [213.165.64.20]) by postgresql.org (Postfix) with SMTP id D84BE9FA2F3 for ; Thu, 17 Aug 2006 13:17:49 -0300 (ADT) Received: (qmail invoked by alias); 17 Aug 2006 16:17:48 -0000 Received: from dslb-084-063-116-078.pools.arcor-ip.net (EHLO colt.pezone.net) [84.63.116.78] by mail.gmx.net (mp007) with SMTP; 17 Aug 2006 18:17:48 +0200 X-Authenticated: #495269 From: Peter Eisentraut To: pgsql-admin@postgresql.org Subject: Re: Monitoring error messages Date: Thu, 17 Aug 2006 18:17:47 +0200 User-Agent: KMail/1.9.3 Cc: robin.c.smith@bt.com References: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200608171817.47633.peter_e@gmx.net> X-Y-GMX-Trusted: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200608/207 X-Sequence-Number: 22750 robin.c.smith@bt.com wrote: > These are both logged as ERROR: which is easy to check for with > automatic monitoring. However I wouldn't want to be called out to fix > a non-existent error where someone has typed in some nonsense. Is it > easy to suppress the syntax errors so that the real database errors > are obvious? I think the short answer is "No", unless you do your own post-processing. But note that syntax errors may also point to mistakes in your application code. If you want to filter out randomness that occurs during interactive sessions, I'd rather attack the problem there. You could, for example, alter the logging settings in your .psqlrc file. -- Peter Eisentraut http://developer.postgresql.org/~petere/