I am trying to install zabbix with postgresql and timeshare db. I follow the instruction on https://docs.timescale.com/self-host...llation-linux/ to install timescale and postresql on a new debain 12 installation.
It all seems to work just fine until i try to import the sql default
It all seems to work just fine until i try to import the sql default
Code:
mcncyo@postgreSQL:~$ cat /usr/share/zabbix-sql-scripts/postgresql/timescaledb.sql | sudo -u postgres psql zabbix
NOTICE: PostgreSQL version 14.12 (Debian 14.12-1.pgdg120+1) is valid
NOTICE: TimescaleDB extension is detected
NOTICE: TimescaleDB version 2.15.0 is valid
ERROR: relation "history" does not exist
LINE 1: SELECT create_hypertable('history', 'clock', chunk_time_inte...
^
QUERY: SELECT create_hypertable('history', 'clock', chunk_time_interval => 86400, migrate_data => true)
CONTEXT: PL/pgSQL function inline_code_block line 59 at PERFORM