Re: Suppress 'duplicate key' at errorlog? - Mailing list pgsql-admin

<p dir="ltr">I _do_ want to phone in on the whole duplicate key issue.<p dir="ltr">Sure, this could be a race
condition.It could be bad programming. It could be a variety of things.<p dir="ltr">You ABSOLUTELY do not want to
ignorethat. Ignoring and moving on will cause consistency problems. Catch it and add it to a log or an email.
Continue.<pdir="ltr">Do NOT silently ignore something trying to add a duplicate key.<br /><div class="cm_quote" style="
color:#787878">On Mon, Mar 30, 2015 at 5:45 PM, David G. Johnston <<a
href="mailto:david.g.johnston@gmail.com">david.g.johnston@gmail.com</a>>wrote:</div><br /><div id="oldcontent"
style="background-color:rgb(255, 255, 255); background-position: initial initial; background-repeat: initial
initial;"><blockquotestyle=""><div dir="ltr"><div class="gmail_default"
style="font-family:arial,helvetica,sans-serif"><spanstyle="font-family:arial,sans-serif">On Mon, Mar 30, 2015 at 2:03
PM,Rossi, Maria </span><span dir="ltr" style="font-family:arial,sans-serif"><<a
href="mailto:maria.rossi@us.pgds.com">maria.rossi@us.pgds.com</a>></span><spanstyle="font-family:arial,sans-serif">
wrote:</span><br/></div><div class="gmail_extra"><div class="gmail_quote"><blockquote class="gmail_quote"
style="margin:00 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div lang="EN-US"><div><p
class="MsoNormal">Hi,<u></u><u></u><pclass="MsoNormal"><u></u> <u></u><p class="MsoNormal">Is there a way to suppress a
‘duplicatekey’ msg  from the errorlog?  Due to a bug in a 3<sup>rd</sup> party application,  this keeps on appearing
andI am concerned that it will fill up the filesystem.    I can delete  the old errorlog,  but if there is any other
meaningfulmsgs out there, I would lose that too.<u></u><u></u><p class="MsoNormal"><u></u> <u></u><p
class="MsoNormal">Thanks.<span class="HOEnZb"><font color="#888888"><u></u><u></u></font></span><span
class="HOEnZb"><fontcolor="#888888"><p class="MsoNormal"><u></u> <u></u><p class="MsoNormal"><b><span
style="font-size:10.0pt;font-family:"TimesNew Roman",serif;color:teal">Maria </span></b><span
style="color:#1f497d"><u></u><u></u></span><p
class="MsoNormal"><u></u> <u></u></font></span></div></div></blockquote></div><br/></div><div class="gmail_extra"><div
class="gmail_default"style="font-family:arial,helvetica,sans-serif">Not in any way that doesn't also entail the "but if
thereis any other meaningful msgs out there, I would lose that too." risk.</div><div class="gmail_default"
style="font-family:arial,helvetica,sans-serif"><br/></div><div class="gmail_default"
style="font-family:arial,helvetica,sans-serif">Stopthinking about the limited problem of removing the excessive
messagesand just learn how to deal with high-volume log situations generally.  At worse you could a simple log rotation
andarchive with a cleanup "sed" script that deletes these messages.  Suggest setting "application_name" in order to be
moretargeted.</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><br /></div><div
class="gmail_default"style="font-family:arial,helvetica,sans-serif">David J.​</div><br
/></div></div></blockquote></div>