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

postgres template: permission denied

    XMLWordPrintable

Details

    • Documentation task
    • Status: Confirmed
    • Trivial
    • Resolution: Unresolved
    • 5.4.6
    • None
    • None
    • None
    • postgresql 11.12
      Template DB PostgreSQL Agent 2 Version 0.37

    Description

      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] [email protected] ERROR:  permission denied for function pg_ls_waldir
      2021-11-26 08:41:38.168 CET [14486] [email protected] 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

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated: