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

PostgreSQL Template Has Error with Trigger PostgreSQL: Service is down

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Won't fix
    • Icon: Minor Minor
    • None
    • 4.4.4
    • Templates (T)
    • None
    • CentOS 7. Initially installed 4.0 from source and upgraded to 4.4
    • Sprint 61 (Feb 2020), Sprint 62 (Mar 2020), Sprint 63 (Apr 2020), Sprint 64 (May 2020), Sprint 65 (Jun 2020), Sprint 66 (Jul 2020), Sprint 67 (Aug 2020), Sprint 68 (Sep 2020), Sprint 69 (Oct 2020), Sprint 70 (Nov 2020), Sprint 71 (Dec 2020), Sprint 72 (Jan 2021), Sprint 73 (Feb 2021), Sprint 74 (Mar 2021)

      When using the PostgreSQL template seen in the github located at https://github.com/lesovsky/zabbix-extensions/tree/master/files/postgresql

       

      The template has an error with the pgping item and trigger. Trigger states that postgres is down when receiving a value of 0. A value of 0 means it is up.

      This uses the pg_ready command which has: 

      0=Accepting connections Normally

      1=Rejecting Connections

      2=No Response

      3=No Attempt

      https://www.postgresql.org/docs/9.6/app-pg-isready.html

       

       

       

            zabbix.dev Zabbix Development Team
            grisemu22 Craig Emmerthal
            Team INT
            Votes:
            2 Vote for this issue
            Watchers:
            8 Start watching this issue

              Created:
              Updated:
              Resolved: