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

postgres template: permission denied

XMLWordPrintable

    • Icon: Documentation task Documentation task
    • Resolution: Fixed
    • Icon: Trivial Trivial
    • None
    • 5.4.6
    • None
    • None
    • postgresql 11.12
      Template DB PostgreSQL Agent 2 Version 0.37

      Steps to reproduce:

      follow the instruxctions on https://git.zabbix.com/projects/ZBX/repos/zabbix/browse/templates/db/postgresql_agent2

       

      Result:

      2021-11-26 08:41:38.168 CET [14486] zbx_monitor@postgres ERROR:  permission denied for function pg_ls_waldir
      2021-11-26 08:41:38.168 CET [14486] zbx_monitor@postgres STATEMENT:  SELECT row_to_json(T)
                                          FROM (
                                                      SELECT
                                                              pg_wal_lsn_diff(pg_current_wal_lsn(),'0/00000000') AS WRITE,
                                                              count(*)
                                                      FROM pg_ls_waldir() AS COUNT
                                                      ) T;

      Expected:
      no permission denied

            zabbix.dev Zabbix Development Team
            shad0w Stefan
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: