manual:appendix:install:timescaledb

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
manual:appendix:install:timescaledb [2021/05/17 11:38]
127.0.0.1 external edit
manual:appendix:install:timescaledb [2021/08/13 04:37] (current)
marinagen fixing incorrect command
Line 23: Line 23:
 Then run the ''​timescaledb.sql''​ script located in database/​postgresql. For new installations the script must be run after the regular PostgreSQL database has been created with initial schema/data (see [[:​manual/​appendix/​install/​db_scripts|database creation]]): ​ Then run the ''​timescaledb.sql''​ script located in database/​postgresql. For new installations the script must be run after the regular PostgreSQL database has been created with initial schema/data (see [[:​manual/​appendix/​install/​db_scripts|database creation]]): ​
  
-  ​cat timescaledb.sql | sudo -u zabbix psql zabbix +  ​zcat /​usr/​share/​doc/​zabbix-sql-scripts/​postgresql/​timescaledb.sql.gz | sudo -u zabbix psql zabbix 
 +  
 The migration of existing history and trend data may take a lot of time. Zabbix server and frontend must be down for the period of migration. The migration of existing history and trend data may take a lot of time. Zabbix server and frontend must be down for the period of migration.