[check_postgres] output pg_stat_activity on warn/error
Thomas Güttler
guettliml at thomas-guettler.de
Wed Jun 11 07:36:47 UTC 2014
Since there was no reply on github, I try it here:
check_postgres works well. If I receive an error or warning, I know that something is wrong.
But I can't see what is going on.
It would be great to see the pg_stat_activity output if there is something wrong.
http://www.postgresql.org/docs/9.2/static/monitoring-stats.html#PG-STAT-ACTIVITY-VIEW
Our applications set the "application_name" which makes the output even more useful, but I guess a lot of applications
don't do it.
See: https://github.com/bucardo/check_postgres/issues/65
We use check_postgres not with nagios, but a different solution which can handle more output.
Any idea how to get more info if there is warning or error. It would be great to get more info to
see as soon as possible what makes the trouble.
Thomas Güttler
More information about the Check_postgres
mailing list