manual:appendix:install:db_scripts

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
manual:appendix:install:db_scripts [2019/03/01 14:04]
martins-v punctuation fix
manual:appendix:install:db_scripts [2020/03/06 08:07] (current)
martins-v fixing link target
Line 56: Line 56:
 <note warning>​Currently TimescaleDB is not supported by Zabbix proxy.</​note>​ <note warning>​Currently TimescaleDB is not supported by Zabbix proxy.</​note>​
  
-We assume that TimescaleDB extension has been already installed ​in the database (see [[https://​docs.timescale.com/​v1.1/​getting-started/​installation|installation instructions]]).+We assume that TimescaleDB extension has been already installed ​on the database ​server ​(see [[https://​docs.timescale.com/​latest/​getting-started/​installation|installation instructions]]).
  
 TimescaleDB extension must also be enabled for the specific DB by executing: TimescaleDB extension must also be enabled for the specific DB by executing:
Line 63: Line 63:
  
 Running this command requires database administrator privileges. ​ Running this command requires database administrator privileges. ​
 +
 +<​note>​If you use a database schema other than '​public'​ you need to add a SCHEMA clause to the command above. E.g.:\\ ''​echo %%"​%%CREATE EXTENSION IF NOT EXISTS timescaledb SCHEMA yourschema CASCADE;​%%"​%% | sudo -u postgres psql zabbix''</​note>​
  
 The ''​timescaledb.sql''​ script is located in database/​postgresql. The script must be run after the regular PostgreSQL database has been created with initial schema/data (see section above): The ''​timescaledb.sql''​ script is located in database/​postgresql. The script must be run after the regular PostgreSQL database has been created with initial schema/data (see section above):