[root@sk1zbx001p ~]# sudo -u zabbix zabbix_get -s 172.27.32.147 -k "agent.version" 3.0.3 # LOG on zabbix-agent (sk1psql001t) 6273:20160611:151346.808 Requested [agent.version] 6273:20160611:151346.808 Sending back [3.0.3] [root@sk1zbx001p ~]# sudo -u zabbix zabbix_get -s 172.27.32.147 -k system.cpu.load[all,avg1] 0.000000 # LOG on zabbix-agent (sk1psql001t) 6273:20160611:151556.753 Requested [system.cpu.load[percpu,avg5]] 6273:20160611:151556.753 Sending back [0.010000] [root@sk1zbx001p ~]# sudo -u zabbix zabbix_get -s 172.27.32.147 -k "pg.modver" zabbix_get [7880]: Check access restrictions in Zabbix agent configuration # LOG on zabbix-agent (sk1psql001t) 6272:20160611:151527.710 Requested [pg.modver] 6272:20160611:151527.710 In MODVER 6272:20160611:151527.710 End of MODVER [root@sk1psql001t ~]# zabbix_get -s 127.0.0.1 -k "pg.connect[user=monitoring]" zabbix_get [22892]: Check access restrictions in Zabbix agent configuration # LOG on zabbix-agent (sk1psql001t) 6274:20160611:151725.873 In PG_CONNECT() 6274:20160611:151725.873 In pg_connect() 6274:20160611:151725.873 Connecting to PostgreSQL with: user=monitoring 6274:20160611:151725.881 End of pg_connect() 6274:20160611:151725.881 End of PG_CONNECT() [root@sk1psql001t ~]# ps -aux | grep zabbix zabbix 22855 0.0 0.2 93396 2344 ? S 15:56 0:00 /usr/sbin/zabbix_agentd -c /etc/zabbix/zabbix_agentd.conf zabbix 22856 0.0 0.1 93396 1484 ? S 15:56 0:00 /usr/sbin/zabbix_agentd: collector [idle 1 sec] zabbix 22857 0.0 0.2 95600 2848 ? S 15:56 0:00 /usr/sbin/zabbix_agentd: listener #1 [waiting for connection] zabbix 22858 0.0 0.2 95600 2844 ? S 15:56 0:00 /usr/sbin/zabbix_agentd: listener #2 [waiting for connection] zabbix 22859 0.0 0.2 95600 2992 ? S 15:56 0:00 /usr/sbin/zabbix_agentd: listener #3 [waiting for connection] zabbix 22860 0.0 0.3 95736 3084 ? S 15:56 0:00 /usr/sbin/zabbix_agentd: active checks #1 [idle 1 sec] zabbix 22861 0.0 0.2 93528 2212 ? S 15:56 0:00 /usr/sbin/zabbix_agentd: active checks #2 [idle 1 sec] root 22906 0.0 0.0 112648 968 pts/0 R+ 15:58 0:00 grep --color=auto zabbix [root@sk1psql001t ~]# sudo -u zabbix psql -U monitoring could not change directory to "/root" psql (9.2.15) Type "help" for help. monitoring=> [root@sk1psql001t ~]# sudo -u zabbix zabbix_agentd -p | grep '^pg\.' zabbix_agentd [23369]: Starting agent module libzbxpgsql 0.2.1 pg.modver pg.connect pg.version pg.starttime pg.uptime pg.setting[,,data_directory] [m|ZBX_NOTSUPPORTED] [Unknown error.] pg.setting.discovery pg.query.string[,,SELECT 'Lorem ipsum dolor';] pg.query.integer[,,SELECT pg_backend_pid();] pg.query.double[,,SELECT CAST(1234 AS double precision);] pg.query.discovery[,,SELECT * FROM pg_database;] pg.backends.count pg.queries.longest pg.checkpoints_timed pg.checkpoints_req pg.checkpoint_write_time pg.checkpoint_sync_time pg.buffers_checkpoint pg.buffers_clean pg.maxwritten_clean pg.buffers_backend pg.buffers_backend_fsync pg.buffers_alloc pg.stats_reset pg.db.discovery pg.namespace.discovery pg.schema.discovery pg.tablespace.discovery pg.table.discovery pg.table.children.discovery[,,pg_proc] pg.index.discovery pg.db.size pg.table.size pg.table.rows pg.table.children[,,pg_database] pg.table.children.size[,,pg_database] pg.table.children.rows[,,pg_database] pg.index.size pg.index.rows pg.tablespace.size[,,pg_default] pg.namespace.size[,,pg_catalog] pg.schema.size[,,pg_catalog] pg.db.numbackends pg.db.xact_commit pg.db.xact_rollback pg.db.blks_read pg.db.blks_hit pg.db.tup_returned pg.db.tup_fetched pg.db.tup_inserted pg.db.tup_updated pg.db.tup_deleted pg.db.conflicts pg.db.temp_files pg.db.temp_bytes pg.db.deadlocks pg.db.blk_read_time pg.db.blk_write_time pg.db.stats_reset[,,postgres,,,] pg.table.seq_scan pg.table.seq_tup_read pg.table.idx_scan pg.table.idx_tup_fetch pg.table.n_tup_ins pg.table.n_tup_upd pg.table.n_tup_del pg.table.n_tup_hot_upd pg.table.n_live_tup pg.table.n_dead_tup pg.table.last_vacuum[,,pg_database] pg.table.last_autovacuum[,,pg_database] pg.table.last_analyze[,,pg_database] pg.table.last_autoanalyze[,,pg_database] pg.table.vacuum_count pg.table.autovacuum_count pg.table.analyze_count pg.table.autoanalyze_count pg.table.heap_blks_read pg.table.heap_blks_hit pg.table.idx_blks_read pg.table.idx_blks_hit pg.table.toast_blks_read pg.table.toast_blks_hit pg.table.tidx_blks_read pg.table.tidx_blks_hit pg.index.idx_scan pg.index.idx_tup_read pg.index.idx_tup_fetch pg.index.idx_blks_read pg.index.idx_blks_hit