I have created a user peramater as follows:
UserParameter=psql.transactions,psql -U postgres --tuples-only -c "select sum(xact_commit) + sum(xact_rollback) from pg_stat_database"
How do I get information out of that?
I created a Template called Template_PGSQL. Under that I added an item with a key name of psql.transactions, Type is Zabbix Agent. After linking that template to the hosts that have the above user paramater, that item returns no data.
So what have I done wrong?
UserParameter=psql.transactions,psql -U postgres --tuples-only -c "select sum(xact_commit) + sum(xact_rollback) from pg_stat_database"
How do I get information out of that?
I created a Template called Template_PGSQL. Under that I added an item with a key name of psql.transactions, Type is Zabbix Agent. After linking that template to the hosts that have the above user paramater, that item returns no data.
So what have I done wrong?