[ZBX-16888] Postgres Template - PostgreSQL is not running on {HOSTNAME} Created: 2019 Nov 09  Updated: 2019 Nov 09  Resolved: 2019 Nov 09

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Templates (T)
Affects Version/s: 4.2.8
Fix Version/s: None

Type: Problem report Priority: Trivial
Reporter: SetDBID Assignee: Zabbix Support Team
Resolution: Duplicate Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Centos 7.7.1908
Postgres 11



 Description   

**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?

 



 Comments   
Comment by SetDBID [ 2019 Nov 09 ]

duplicte with zbx-16889

Generated at Fri Apr 11 09:15:32 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.