timescaledb.sql missing in zabbix-sql-scripts_7.0.0~beta1-4+ubuntu22.04_all.deb

[dszabbix]

timescaledb.sql was present in zabbix-sql-scripts_7.0.0~alpha1 through alpha7, but is no longer present in alpha8,9 or beta1. The documentation still refers to using this script to set up Zabbix to use timescaleDB :

https://www.zabbix.com/documentation/7.0/en/manual/appendix/install/timescaledb#configuration

Are there updated instructions for how to enable timescaleDB on a fresh 7.0 installation?

Thank you.

[cyber]

Is there a "/usr/share/zabbix-sql-scripts/postgresql/timescaledb/schema.sql" ? At least, if looking on source package, it has moved and renamed... but identical file in alpha6 and beta1.
~/zabbix-7.0.0alpha6/database/postgresql/timescaledb.sql
~/zabbix-7.0.0beta1/database/postgresql/timescaledb/schema.sql

[dszabbix]

Thank you cyber and sorry for the late response (I didn't get an email notification and haven't been back here til now). Yes, schema.sql is there and works fine.

[db100]

how about kubernetes and dockerfiles ? where is the schame.sql file ?

[cyber]

how about kubernetes and dockerfiles ? where is the schame.sql file ?

you may need it only with clean install, if you upgrde, server does all required upgrade steps during first start.

[db100]

i believe a simple note in the documentation would be of great help !!

[cyber]

• db100 commented
  Today, 10:19
  i believe a simple note in the documentation would be of great help !!

I don't know... If the script is used for "initial DB creation" and is not mentioned in upgrade notes, then why would you need to run it...

[db100]

i ended up needing the script for migrating a non timescale instance onto a timescale one, after installing timescale in postgres.

the script was in the container but the path did not match the documented one AFAIK

[db100]

here the actual path inside the container: /usr/share/doc/zabbix-server-postgresql/timescaledb.sql which does not match whats written in the doc: https://www.zabbix.com/documentation...scaledb-schema

[viruslab]

the actual path inside the container:
/usr/share/doc/zabbix-server-postgresql/timescaledb.sql
which does not match whats written in the docs

This is really confusing. I spent so many time to find this.
Please fix this in the docs.

[Markku]

Please fix this in the docs.

Select the text in the docs and press Ctrl/Command-Enter to submit feedback (see the footer text on any documentation page). (I don't know how to do that on touch-only devices)

Markku