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

Postgres Template - PostgreSQL is not running on {HOSTNAME}

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Won't fix
    • Icon: Trivial Trivial
    • None
    • 4.2.8
    • Templates (T)
    • None
    • Centos 7.7.1908
      Postgres 11

      **Hello,

       

      Steps to reproduce:

      1. Install Template DB Postgresql - settings according to doc's

      Result:

            **      Template seems to work but

             zabbix trigger returns problem: "PostgreSQL is not running on hostname1"

                Expression:

      {hostname1:proc.num[*postmaster*].last(0)}

      <7 

      ps -ef |grep [p]ostgres

      postgres 9110 1 0 Nov04 ? 00:00:03 /usr/pgsql-11/bin/postgres -D /opt/postgresql/data
      postgres 9111 9110 0 Nov04 ? 00:01:12 postgres: startup recovering 00000001000000000000006B
      postgres 9112 9110 0 Nov04 ? 00:00:05 postgres: checkpointer
      postgres 9113 9110 0 Nov04 ? 00:00:08 postgres: background writer
      postgres 9114 9110 0 Nov04 ? 00:00:03 postgres: stats collector
      postgres 9115 9110 0 Nov04 ? 00:07:40 postgres: walreceiver streaming 0/6BC56E40
      postgres 10124 9110 0 Nov06 ? 00:00:05 postgres: walsender streaming_barman 10.10.10.50(55976) streaming 0/6BC56E40
       
      

       

      ps -ef |grep [p]ostmaster

      no rows returned.

      Trying to change Trigger Expression to: 

      {hostname1[*postgres*].last(0)}

      <7

      Cause Error: Cannot update trigger

      • Incorrect item key "proc.num[*postgres*]" provided for trigger expression on "hostname1".
        Expected:

      according to database documentation: "postmaster is a deprecated alias of postgres."

      https://www.postgresql.org/docs/11/app-postmaster.html

      How may i change this trigger/item or solve this problem?

       

            edgar.akhmetshin Edgar Akhmetshin
            SetDBID SetDBID
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: