From: Scott Ribe <scott_ribe@elevated-dev.com>
To: Rossi, Maria <maria.rossi@us.pgds.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Suppress 'duplicate key' at errorlog?
Date: Mon, 30 Mar 2015 17:15:29 -0600
Message-ID: <4BFDA821-C2D3-4614-A66F-FF0D9FDEE5EB@elevated-dev.com> (raw)
In-Reply-To: <33A4D5087BF0D44DA69C5EEF666BC1D74263DD2C@usprmbp01c>
References: <33A4D5087BF0D44DA69C5EEF666BC1D74263DD2C@usprmbp01c>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
On Mar 30, 2015, at 3:03 PM, Rossi, Maria <maria.rossi@us.pgds.com> wrote:
>
> Hi,
>
> Is there a way to suppress a ‘duplicate key’ msg from the errorlog? Due to a bug in a 3rd party application, this keeps on appearing and I am concerned that it will fill up the filesystem. I can delete the old errorlog, but if there is any other meaningful msgs out there, I would lose that too.
No way to turn off that specific error message, but you could filter them out of the log, being careful of course not to filter any messages which might be more meaningful. You could also prevent the errors from being raised by using a trigger, but I don't like that idea very much at all.
--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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 using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott_ribe@elevated-dev.com, maria.rossi@us.pgds.com
Subject: Re: Suppress 'duplicate key' at errorlog?
In-Reply-To: <4BFDA821-C2D3-4614-A66F-FF0D9FDEE5EB@elevated-dev.com>
* 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