Re: Filter logging by table

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: "Yves Lavoie, GaYLi" <ylavoie(at)yveslavoie(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Filter logging by table
Date: 2016-11-25 21:30:05
Message-ID: CAECtzeWpnNggS_ozytd0_Vg3xHkZW4itG2-Z7qJ_hapCziW_yw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

2016-11-22 19:19 GMT+01:00 Yves Lavoie, GaYLi <ylavoie(at)yveslavoie(dot)com>:

> 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?
>
>
There's no way to do that natively with PostgreSQL. But perhaps some
extensions can help you get that, though I know none that would.

--
Guillaume.
http://blog.guillaume.lelarge.info
http://www.dalibo.com

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2016-11-25 21:42:37 Re: Filter logging by table
Previous Message Marc-Olaf Jaschke 2016-11-25 19:39:41 Some questions about old_snapshot_threshold