Ad Widget

Collapse

zabbix 7.4 - function base36_decode(pg_catalog.varchar) does not exist

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • rn3dcx
    Junior Member
    • Jul 2025
    • 4

    #1

    zabbix 7.4 - function base36_decode(pg_catalog.varchar) does not exist

    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:
    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
    Why does NOTIFICATION appear: function base36_decode(pg_catalog.varchar) does not exist ?
    What am i doing wrong?
    Last edited by rn3dcx; 18-07-2025, 10:10.
  • rn3dcx
    Junior Member
    • Jul 2025
    • 4

    #2
    Do you have any ideas on how to fix this?

    Comment

    Working...