Newly added hosts are not available untill zabbix_server restart

[9a8]

Dear community,

can you suggest what to troubleshoot. Seems I'm flailing to do it myself.

Situation: newly added hosts to zabbix are not monitored unless server restart (systemctl restart zabbix-server.service).
As our environment is quite static, I am not really sure when the issue starts. Can just guess that after migration of our zabbix 6.2 from mysql to postgresql/timescaledb

[9a8]

This morning I was able to address the root cause.
Root cause: missing triggers in the PostgreSQL database.

Two topics helped me:

https://www.zabbix.com/forum/zabbix-troubleshooting-and-problems/466090-new-zabbix-items-do-not-gather-data-unless-zabbix-server-is-restarted

https://support.zabbix.com/plugins/servlet/mobile#issue/ZBX-22948

To fix the issue I had to execute all statements related to triggers from /usr/share/zabbix-sql-scripts/postgresql/server.sql.gz (lines 2279 to 2844 for version 6.4) against zabbix database.

[9a8]

This morning I was able to address the root cause.
Root cause: missing triggers in the PostgreSQL database.

Two topics helped me:

https://www.zabbix.com/forum/zabbix-troubleshooting-and-problems/466090-new-zabbix-items-do-not-gather-data-unless-zabbix-server-is-restarted

https://support.zabbix.com/plugins/servlet/mobile#issue/ZBX-22948

To fix the issue I had to execute all statements related to triggers from /usr/share/zabbix-sql-scripts/postgresql/server.sql.gz (lines 2279 to 2844 for version 6.4) against zabbix database.