Re: Filter logging by table - Mailing list pgsql-admin

From Guillaume Lelarge
Subject Re: Filter logging by table
Date
Msg-id CAECtzeWpnNggS_ozytd0_Vg3xHkZW4itG2-Z7qJ_hapCziW_yw@mail.gmail.com
Whole thread Raw
In response to Filter logging by table  ("Yves Lavoie, GaYLi" <ylavoie@yveslavoie.com>)
List pgsql-admin
Hi,

2016-11-22 19:19 GMT+01:00 Yves Lavoie, GaYLi <ylavoie@yveslavoie.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.


--

pgsql-admin by date:

Previous
From: Marc-Olaf Jaschke
Date:
Subject: Some questions about old_snapshot_threshold
Next
From: "David G. Johnston"
Date:
Subject: Re: Filter logging by table