[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 |
Description |
**Hello,
Steps to reproduce:
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
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 |