Re: Filter logging by table
| От | David G. Johnston |
|---|---|
| Тема | Re: Filter logging by table |
| Дата | |
| Msg-id | CAKFQuwaUSw1nCQmHLFn+eFtW03ZTe9dv3-KbmOAwrdiMZBGpDg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Filter logging by table ("Yves Lavoie, GaYLi" <ylavoie@yveslavoie.com>) |
| Список | pgsql-admin |
Hi PG Gurus,
I need to filter out logging for some tables. We have an application
which often query for a settings table and for pg_proc. This pollutes
postgresql.log with numerous useless queries and we are looking for a
way to skip logging entirely for those. Any suggestion?
Don't know for sure if this will work but I'd probably wrap the relevant query in a function and add "SET log_statements = none" at the top. You'll need to make the function "security definer" and make it owned by a superuser.
David J.
В списке pgsql-admin по дате отправления: