New install Zabbix 7.4 on Debian.
When I run: cat /usr/share/zabbix/sql-scripts/postgresql/timescaledb/schema.sql | sudo -u zabbix psql zabbix
Next I see notification:
Why does NOTIFICATION appear: function base36_decode(pg_catalog.varchar) does not exist ?
What am i doing wrong?
When I run: cat /usr/share/zabbix/sql-scripts/postgresql/timescaledb/schema.sql | sudo -u zabbix psql zabbix
Next I see notification:
Code:
@Zabbix:~$ cat /usr/share/zabbix/sql-scripts/postgresql/timescaledb/schema.sql | sudo -u zabbix psql zabbix CREATE FUNCTION NOTICE: function base36_decode(pg_catalog.varchar) does not exist, skipping DROP FUNCTION NOTICE: PostgreSQL version 16.9 (Debian 16.9-1.pgdg120+1) is valid NOTICE: TimescaleDB extension is detected NOTICE: TimescaleDB version 2.15.3 is valid WARNING: column type "character varying" used for "source" does not follow best practices HINT: Use datatype TEXT instead. WARNING: column type "character varying" used for "value" does not follow best practices HINT: Use datatype TEXT instead. WARNING: column type "character varying" used for "auditid" does not follow best practices HINT: Use datatype TEXT instead. WARNING: column type "character varying" used for "username" does not follow best practices HINT: Use datatype TEXT instead. WARNING: column type "character varying" used for "ip" does not follow best practices HINT: Use datatype TEXT instead. WARNING: column type "character varying" used for "resource_cuid" does not follow best practices HINT: Use datatype TEXT instead. WARNING: column type "character varying" used for "resourcename" does not follow best practices HINT: Use datatype TEXT instead. WARNING: column type "character varying" used for "recordsetid" does not follow best practices HINT: Use datatype TEXT instead. NOTICE: TimescaleDB is configured successfully DO
What am i doing wrong?
Comment