variable is IP or DNS name of MySQL or PostgreSQL server. By default, value is mysql-server or postgres-server for MySQL or PostgreSQL respectively DB_SERVER_PORT Server Proxy Web interface This variable server and ’zabbix_proxy’ for Zabbix proxy. 88 POSTGRES_USER Server Web interface PostgreSQL database user. By default, value is ’zabbix’. POSTGRES_PASSWORD Server Web interface PostgreSQL database database password. By default, value is ’zabbix’. POSTGRES_DB Server Web interface Zabbix database name. By default, value is ’zabbix’ for Zabbix server and ’zabbix_proxy’ for Zabbix proxy. PHP_TZ Web-interface

variable is IP or DNS name of MySQL or PostgreSQL server. By default, value is mysql-server or postgres-server for MySQL or PostgreSQL respectively DB_SERVER_PORT Server Proxy Web interface This variable Zabbix server and ’zabbix_proxy’ for Zabbix proxy. POSTGRES_USER Server Web interface PostgreSQL database user. By default, value is ’zabbix’. POSTGRES_PASSWORD Server Web interface PostgreSQL database database password. By default, value is ’zabbix’. POSTGRES_DB Server Web interface Zabbix database name. By default, value is ’zabbix’ for Zabbix server and ’zabbix_proxy’ for Zabbix proxy. PHP_TZ Web-interface

prompted and repeat the password (note, you may first be asked for a sudo password): shell> sudo -u postgres createuser --pwprompt zabbix Now we will set up the database zabbix (last parameter) with the previously previously created user as the owner (-O zabbix) and import initial schema and data: shell> sudo -u postgres createdb -O zabbix zabbix shell> zcat /usr/share/doc/zabbix-server-pgsql/create.sql.gz | sudo -u variable is IP or DNS name of MySQL or PostgreSQL server. By default, value is mysql-server or postgres-server for MySQL or PostgreSQL respectively DB_SERVER_PORT Server Proxy Web interface This variable

variable is IP or DNS name of MySQL or PostgreSQL server. By default, value is mysql-server or postgres-server for MySQL or PostgreSQL respectively DB_SERVER_PORT Server Proxy Web interface This variable Zabbix server and ’zabbix_proxy’ for Zabbix proxy. POSTGRES_USER Server Web interface PostgreSQL database user. By default, value is ’zabbix’. POSTGRES_PASSWORD Server Web interface PostgreSQL database database password. By default, value is ’zabbix’. 73 POSTGRES_DB Server Web interface Zabbix database name. By default, value is ’zabbix’ for Zabbix server and ’zabbix_proxy’ for Zabbix proxy. PHP_TZ

variable is IP or DNS name of MySQL or PostgreSQL server. By default, value is mysql-server or postgres-server for MySQL or PostgreSQL respectively DB_SERVER_PORT Server Proxy Web interface This variable Zabbix server and ’zabbix_proxy’ for Zabbix proxy. POSTGRES_USER Server Web interface PostgreSQL database user. By default, value is ’zabbix’. POSTGRES_PASSWORD Server Web interface PostgreSQL database database password. By default, value is ’zabbix’. POSTGRES_DB Server Web interface Zabbix database name. By default, value is ’zabbix’ for Zabbix server and ’zabbix_proxy’ for Zabbix proxy. PHP_TZ Web-interface

variable is IP or DNS name of MySQL or PostgreSQL server. By default, value is mysql-server or postgres-server for MySQL or PostgreSQL respectively DB_SERVER_PORT Server Proxy Web interface This variable Zabbix server and ’zabbix_proxy’ for Zabbix proxy. POSTGRES_USER Server Web interface PostgreSQL database user. By default, value is ’zabbix’. POSTGRES_PASSWORD Server Web interface PostgreSQL database database password. By default, value is ’zabbix’. POSTGRES_DB Server Web interface Zabbix database name. By default, value is ’zabbix’ for Zabbix server and ’zabbix_proxy’ for Zabbix proxy. PHP_TZ Web-interface

variable is IP or DNS name of MySQL or PostgreSQL server. By default, value is mysql-server or postgres-server for MySQL or PostgreSQL respectively DB_SERVER_PORT Server Proxy Web interface This variable Zabbix server and ’zabbix_proxy’ for Zabbix proxy. POSTGRES_USER Server Web interface PostgreSQL database user. By default, value is ’zabbix’. POSTGRES_PASSWORD Server Web interface PostgreSQL database database password. By default, value is ’zabbix’. POSTGRES_DB Server Web interface Zabbix database name. By default, value is ’zabbix’ for Zabbix server and ’zabbix_proxy’ for Zabbix proxy. PHP_TZ Web-interface

when prompted and repeat password (note, you may first be asked for sudo password): shell> sudo -u postgres createuser --pwprompt zabbix 现在将以先前创建的用户作为数据库所有者（参数：-O zabbix）设置数据库 zabbix（最后一个参数）并导入 initial schema initial schema and data (assuming you are in the root directory of Zabbix sources): shell> sudo -u postgres createdb -O zabbix zabbix 如果使用 Zabbix 程序包按照手册Debian/Ubuntu 或RHEL/CentOS导入数据到数据库。 If you use Zabbix specific DB by executing: echo "CREATE EXTENSION IF NOT EXISTS timescaledb CASCADE;" | sudo -u postgres psql zabbix Running this command requires database administrator privileges. Note: If you use

shell> sudo -u postgres createuser --pwprompt zabbix 现在将以先前创建的用户作为数据库所有者（参数：-O zabbix）设置数据库 zabbix（最后一个参数）并导入 initial schema 和数据 （假设当前目录位于 Zabbix sources 的根目录中）： shell> sudo -u postgres createdb -O zabbix 还必须通过执行以下命令为特定的数据库启用 TimescaleDB 扩展项： echo "CREATE EXTENSION IF NOT EXISTS timescaledb CASCADE;" | sudo -u postgres psql zabbix 运行此命令需要数据库管理员权限。 Note: 如果你使用的数据库 schema 不是’public’ 模式则需要通过以上命令添加 SCHEMA 子句，例如： echo echo "CREATE EXTENSION IF NOT EXISTS timescaledb SCHEMA yourschema CASCADE;" | sudo -u postgres psql zabbix 然后运行位于 database/postgresql 中的 timescaledb.sql 脚本。对于新的安装，必须在使用初始 schema/data 创建常规 PostgreSQL 数

prompted and repeat the password (note, you may first be asked for a sudo password): shell> sudo -u postgres createuser --pwprompt zabbix Now we will set up the database zabbix (last parameter) with the previously previously created user as the owner (-O zabbix) and import initial schema and data: shell> sudo -u postgres createdb -O zabbix -E Unicode -T template0 zabbix shell> zcat /usr/share/doc/zabbix-server-pgsql/create variable is IP or DNS name of MySQL or PostgreSQL server. By default, value is mysql-server or postgres-server for MySQL or PostgreSQL respectively DB_SERVER_PORT Server Proxy Web interface This variable