在zabbix中使用使用pg_monz模板日常监控postgresql发生sh: psql: command not found错误

导入pg_monz模板，监控显示postgresql服务没有启动，查看agent端postgresql服务已经启动。查看zabbix-server.log查看到以下错误。
10784:20180809:183958.229 item “agent1:psql.active_connections[{KaTeX parse error: Expected 'EOF', got '}' at position 7: PGHOST}̲,{PGPORT},{KaTeX parse error: Expected 'EOF', got '}' at position 7: PGROLE}̲,{PGDATABASE}]” became not supported: Received value [sh: psql: command not found] is not suitable for value type [Numeric (unsigned)] and data type [Decimal]
解决办法：postgrseql安装后，psql默认在在/usr/local/pgsql/bin/，即使设置PATH环境变数也不好使。
[root@localhost bin]# ln -s /usr/local/pgsql/bin/psql /usr/local/bin/psql
[root@localhost bin]# ln -s /usr/local/pgsql/bin/psql /usr/local/psql