[TNM] EXCLUDE filter not working for temptable?
David
dbwagoner at gmail.com
Thu Oct 30 12:52:54 UTC 2014
I want to use tail_n_mail to monitor for temp tables. I am trying to
filter out temp tables created by my vacuum cron job, as shown in the log
example excerpt below:
2014-10-30 01:02:01 EDT [30494]: [1-1] user=postgres,db=MyDB LOG:
statement: CREATE TEMP TABLE vacuum_l AS SELECT oid AS lo FROM
pg_largeobject_metadata
I've tried these two versions of the EXCLUDE statement in
my tnm.config.tempfile.txt file:
EXCLUDE: CREATE TEMP TABLE vacuum_l
EXCLUDE: "CREATE TEMP TABLE vacuum_l"
I still get email like the following:
Date: Thu Oct 30 06:15:02 2014 EDT
Host: myserver
Matches from
/postgres/data/9.2AS/data/pg_log/postgresql-2014-10-30_000000.log: 2
Top items by arithmetic mean | Top items by total size
----------------------------------+-------------------------------
*Questions*:
1. Why is my EXCLUDE not working?
2. Why is the output table empty?
Thanks for your help!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/tnm/attachments/20141030/bcfacfb2/attachment.html>
More information about the TNM
mailing list