Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-21039

Rights to pg_stat_activity for zbx_monitor. Postgresql template Zabbix agent 2

XMLWordPrintable

      Zabbix server 6.0.3

      Zabbix agent 2 - 5.4.12

      Template PostgreSQL by Zabbix agent 2 - 0.41

      PostgreSQL on host - 14 version

      Steps to reproduce:

      1. Apply template to Postgresql host
      2. Follow current instructions https://www.zabbix.com/ru/integrations/postgresql#postgresql_agent2
      3. Show active, idle, total from zabbix_get -s $DB-host -p 10050 -k pgsql.connections["tcp://localhost:5432","zbx_monitor","$PASS"]
      4. Create multiple connections. For example create DB test and run pgbench -h $DB-host -U $USER -c 50 test
      5. Show connection from pgsql.connections

      Result:
      You won't see changes. User zbx_monitor does not have enough permissions.

      Need add role pg_read_all_stats to the zbx_monitor.

      GRANT pg_read_all_stats TO zbx_monitor;

      It just needs to be added to doc, if you think it's the right decision https://www.zabbix.com/ru/integrations/postgresql#postgresql_agent2

            atocko Andrey Tocko (Inactive)
            kgup Kirill
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: