-
Problem report
-
Resolution: Duplicate
-
Trivial
-
None
-
4.2.8
-
None
-
Centos 7.7.1908
Postgres 11
**Hello,
Steps to reproduce:
- 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?