-
Problem report
-
Resolution: Unresolved
-
Trivial
-
None
-
7.2.11, 7.4.1
-
None
-
postgresql 17.5
timescaledb 2.21
Zabbix fail to call timescaledb function if zabbix and timescaledb location in different schema
My postgresql structure is:
<database>.<schema_for_zabbix>.* <database>.<schema_for_tsdb>.* <database>.<schema_for_collect_log>.* ...
timescaledb was installed via command:
create extension timescaledb with schema tsdb cascade;
because all schemes in this database use timescaledb functions
then i set search_path:
alter database db_mon set search_path to zabbix, tsdb, collect_log;
but zabbix d'not works with this set
I think this is because before each call of a SQL query, zabbix overwrites the variable "search_path" with the one specified in the config file