From: Larry Lennhoff <llennhoff-postgres@pexicom.com>
To: pgsql-admin@postgresql.org
Subject: Suppressing duplicate key error messages in postgres log?
Date: Sat, 16 Oct 2004 21:35:35 -0400
Message-ID: <6.0.2.0.0.20041016212538.01b2d7f8@localhost> (raw)
Hi
I have a postgres table which relies on a unique index to act as a
semaphore to share a resource among many competing processes on several
different servers. This table is hit multiple times per second. The
postgres log is being filled by millions of messages of the sort
ERROR: Cannot insert a duplicate key into unique index ...
Is there any way to suppress this message so that it won't appear in the
log? I looked at the documentation and log_min_error_statement looked
promising. I set it to panic, but the messages continue. What am I doing
wrong?
Thanks in advance for any assistance
Larry
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: llennhoff-postgres@pexicom.com
Subject: Re: Suppressing duplicate key error messages in postgres log?
In-Reply-To: <6.0.2.0.0.20041016212538.01b2d7f8@localhost>
References: <6.0.2.0.0.20041016212538.01b2d7f8@localhost>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox