Re: Suppress 'duplicate key' at errorlog?
От | David G. Johnston |
---|---|
Тема | Re: Suppress 'duplicate key' at errorlog? |
Дата | |
Msg-id | CAKFQuwaQVcyePbseX56S3joRspLYAnmiVuDqbcdQ1zSRJHD19Q@mail.gmail.com обсуждение исходный текст |
Ответ на | Suppress 'duplicate key' at errorlog? ("Rossi, Maria" <maria.rossi@us.pgds.com>) |
Ответы |
Re: Suppress 'duplicate key' at errorlog?
|
Список | pgsql-admin |
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.
Thanks.
Maria
Not in any way that doesn't also entail the "but if there is any other meaningful msgs out there, I would lose that too." risk.
Stop thinking about the limited problem of removing the excessive messages and just learn how to deal with high-volume log situations generally. At worse you could a simple log rotation and archive with a cleanup "sed" script that deletes these messages. Suggest setting "application_name" in order to be more targeted.
David J.
В списке pgsql-admin по дате отправления: