Re: Suppress 'duplicate key' at errorlog?

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: "Rossi, Maria" <maria(dot)rossi(at)us(dot)pgds(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Suppress 'duplicate key' at errorlog?
Date: 2015-03-30 23:15:29
Message-ID: 4BFDA821-C2D3-4614-A66F-FF0D9FDEE5EB@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Mar 30, 2015, at 3:03 PM, Rossi, Maria <maria(dot)rossi(at)us(dot)pgds(dot)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(at)elevated-dev(dot)com
http://www.elevated-dev.com/
https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Whitney 2015-03-31 00:12:48 Re: Suppress 'duplicate key' at errorlog?
Previous Message David G. Johnston 2015-03-30 23:05:34 Re: Suppress 'duplicate key' at errorlog?