[TNM] pgAdmin III entries getting picked up when they shouldn't be

Douglas J Hunley doug.hunley at enterprisedb.com
Wed Jun 15 12:37:08 UTC 2016


I've got tnm (tail_n_mail-1.27.0-1.rhel6.noarch) installed and configured
thusly:
## Config file for the tail_n_mail program
## This file is automatically updated
## Last updated: Wed Jun 15 12:21:05 2016
EMAIL: root
MAILSUBJECT: HOST Postgres errors UNIQUE : NUMBER

INCLUDE: ERROR:
INCLUDE: FATAL:
INCLUDE: PANIC:

FILE1: /var/lib/pgsql/9.4/data/pg_log/postgresql-%H.log

And every time someone connects using pgAdmin III, the log entries for it
get flagged:
Date: Tue Jun 14 23:52:11 2016 UTC
Host: risdb01.phx.tandemradiology.com
Unique items: 117
Matches from /var/lib/pgsql/9.4/data/pg_log/postgresql-23.log: 117


[1] (from line 20,252,982)
?
2016-06-14 23:51:11 UTC [31610]: [3-1] user=trisdbuser,db=postgres,app=pgAdmin
III - Browser,client=10.130.2.95 LOG:  duration: 22.603 ms  statement:
SELECT version();

[2] (from line 20,253,480)
?
2016-06-14 23:51:11 UTC [31610]: [4-1] user=trisdbuser,db=postgres,app=pgAdmin
III - Browser,client=10.130.2.95 LOG:  duration: 30.933 ms  statement: SET
DateStyle=ISO;

[3] (from line 20,253,758)
?
2016-06-14 23:51:11 UTC [31610]: [5-1] user=trisdbuser,db=postgres,app=pgAdmin
III - Browser,client=10.130.2.95 LOG:  duration: 0.090 ms  statement: set
client_encoding to 'UNICODE'

[4] (from line 20,253,951)
?
2016-06-14 23:51:11 UTC [31610]: [6-1] user=trisdbuser,db=postgres,app=pgAdmin
III - Browser,client=10.130.2.95 LOG:  duration: 17.964 ms  statement:
SELECT usecreatedb, usesuper, CASE WHEN usesuper THEN
pg_postmaster_start_time() ELSE NULL END as upsince, CASE WHEN usesuper
THEN pg_conf_load_time() ELSE NULL END as confloadedsince, CASE WHEN
usesuper THEN pg_is_in_recovery() ELSE NULL END as inrecovery, CASE WHEN
usesuper THEN pg_last_xlog_receive_location() ELSE NULL END as receiveloc,
CASE WHEN usesuper THEN pg_last_xlog_replay_location() ELSE NULL END as
replayloc, CASE WHEN usesuper THEN pg_last_xact_replay_timestamp() ELSE
NULL END as replay_timestamp, CASE WHEN usesuper AND pg_is_in_recovery()
THEN pg_is_xlog_replay_paused() ELSE NULL END as isreplaypaused

[5] (from line 20,254,094)
?
2016-06-14 23:51:11 UTC [31610]: [7-1] user=trisdbuser,db=postgres,app=pgAdmin
III - Browser,client=10.130.2.95 LOG:  duration: 3.802 ms  statement:
SELECT rolcreaterole, rolcreatedb FROM pg_roles WHERE rolname =
current_user;


I tried excluding them using:
EXCLUDE: ^.*?pgAdmin

but that didn't work. I'm not even sure why the logs entries get caught as
there is no ERROR/FATAL/PANIC present. My .tailnmailrc is:
log_line_prefix = '%t [%p]: [%l-1] user=%u,db=%d,app=%a,client=%h '

Can anyone explain why these lines are getting caught and how to stop it?
Thanks!

-- 
  /    )/      \/   \
 (     / __    _\    )     Douglas J Hunley
  \    (/ o)  ( o)   )     Certified Postgres Engineer & Trainer
   \_  (_  )   \ ) _/      SSH: http://goo.gl/IUUkn7  PGP:
http://goo.gl/mdxx8u
     \  /\_/    \)/
      \/ <//|  |\\>
           _|  |
           \|_/
sp;   }
    ]
}
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/tnm/attachments/20160615/674b2ceb/attachment.html>


More information about the TNM mailing list