ip:8080 or ip:80/zabbix
user: Admin(admin)/zabbix
MySQL template: MySQL by Zabbix agent 2
PostgreSQL template: PostgreSQL by Zabbix agent 2
- b. set Macros var
MySQL set:{$MYSQL.DSN} {$MYSQL.PASSWORD} {$MYSQL.USER}
PostgreSQL set: {$PG.DATABASE} {$PG.PASSWORD} {$PG.URI} {$PG.USER}
more please visit: https://git.zabbix.com/projects/ZBX/repos/zabbix/browse/templates/db/postgresql?at=release/6.2
xxx. add test data
pgbench -i -s 100 -U postgres test
pgbench -P 1 -c 32 -j 4 -T 300 -U postgres test
create.sql
file from zabbix-server-pgsql container, /usr/share/doc/zabbix-server-pgsql/create.sql.gz file