PostgreSQL: shell> psql -U psql> create database zabbix; psql> \q shell> cd create/schema shell> cat postgresql.sql | psql -U zabbix shell> cd ../data shell> cat data.sql | psql -U zabbix shell> cat images_pgsql.sql | psql -U zabbix For SQLite: 66 shell> cd create/schema shell> cat sqlite.sql | sqlite3 /var/lib/sqlite/zabbix.db shell> cd ../data shell> cat data CHARACTER SET UTF8; For PostgreSQL: shell> psql -U psql> create database zabbix; psql> \q shell> cd create/schema shell> cat postgresql.sql | psql -U zabbix For SQLite: shell> cd

PostgreSQL, also run: # cat /usr/share/zabbix-sql-scripts/postgresql/timescaledb.sql | sudo -u zabbix psql zabbix Warning: TimescaleDB is supported with Zabbix server only. SELinux configuration Zabbix PostgreSQL (or SQLite): # cat /usr/share/zabbix-sql-scripts/postgresql/proxy.sql | sudo -u zabbix psql zabbix # cat /usr/share/zabbix-sql-scripts/sqlite3/proxy.sql | sqlite3 zabbix.db Configure database PostgreSQL, also run: # cat /usr/share/zabbix-sql-scripts/postgresql/timescaledb.sql | sudo -u zabbix psql zabbix Warning: TimescaleDB is supported with Zabbix server only. SELinux configuration See SELinux

PostgreSQL, also run: cat /usr/share/zabbix-sql-scripts/postgresql/timescaledb.sql | sudo -u zabbix psql zabbix Warning: TimescaleDB is supported with Zabbix server only. PHP 7.2 Zabbix frontend requires with PostgreSQL (or SQLite): cat /usr/share/zabbix-sql-scripts/postgresql/proxy.sql | sudo -u zabbix psql zabbix cat /usr/share/zabbix-sql-scripts/sqlite3/proxy.sql | sqlite3 zabbix.db Configure database PostgreSQL, also run: cat /usr/share/zabbix-sql-scripts/postgresql/timescaledb.sql | sudo -u zabbix psql zabbix Warning: TimescaleDB is supported with Zabbix server only. PHP 7.2 Zabbix frontend requires

gz | sudo -u zabbix psql zabbix With TimescaleDB, in addition to the previous command, also run: # zcat /usr/share/doc/zabbix-server-pgsql*/timescaledb.sql.gz | sudo -u zabbix psql zabbix Warning: TimescaleDB PostgreSQL (or SQLite): # zcat /usr/share/doc/zabbix-proxy-pgsql*/schema.sql.gz | sudo -u zabbix psql zabbix # zcat /usr/share/doc/zabbix-proxy-sqlite3*/schema.sql.gz | sqlite3 zabbix.db Configure database gz | sudo -u zabbix psql zabbix With TimescaleDB, in addition to the previous command, also run: # zcat /usr/share/doc/zabbix-server-pgsql*/timescaledb.sql.gz | sudo -u zabbix psql zabbix Warning: TimescaleDB

PostgreSQL, also run: cat /usr/share/zabbix-sql-scripts/postgresql/timescaledb.sql | sudo -u zabbix psql zabbix Warning: TimescaleDB is supported with Zabbix server only. SELinux configuration Zabbix with PostgreSQL (or SQLite): cat /usr/share/zabbix-sql-scripts/postgresql/proxy.sql | sudo -u zabbix psql zabbix cat /usr/share/zabbix-sql-scripts/sqlite3/proxy.sql | sqlite3 zabbix.db Configure database PostgreSQL, also run: cat /usr/share/zabbix-sql-scripts/postgresql/timescaledb.sql | sudo -u zabbix psql zabbix Warning: TimescaleDB is supported with Zabbix server only. SELinux configuration See SELinux

sudo -u psql zabbix With TimescaleDB, in addition to the previous command, also run: # zcat /usr/share/doc/zabbix-server-pgsql*/timescaledb.sql.gz | sudo -u psql zabbix Warning: PostgreSQL (or SQLite): # zcat /usr/share/doc/zabbix-proxy-pgsql*/schema.sql.gz | sudo -u psql zabbix # zcat /usr/share/doc/zabbix-proxy-sqlite3*/schema.sql.gz | sqlite3 zabbix.db 61 Configure sudo -u psql zabbix With TimescaleDB, in addition to the previous command, also run: # zcat /usr/share/doc/zabbix-server-pgsql*/timescaledb.sql.gz | sudo -u psql zabbix Warning:

PostgreSQL, also run: # cat /usr/share/zabbix-sql-scripts/postgresql/timescaledb.sql | sudo -u zabbix psql zabbix 72 Warning: TimescaleDB is supported with Zabbix server only. SELinux configuration Zabbix PostgreSQL (or SQLite): # cat /usr/share/zabbix-sql-scripts/postgresql/proxy.sql | sudo -u zabbix psql zabbix # cat /usr/share/zabbix-sql-scripts/sqlite3/proxy.sql | sqlite3 zabbix.db Configure database PostgreSQL, also run: # cat /usr/share/zabbix-sql-scripts/postgresql/timescaledb.sql | sudo -u zabbix psql zabbix Warning: TimescaleDB is supported with Zabbix server only. SELinux configuration See SELinux

gz | sudo -u zabbix psql zabbix Attention: The above commands are provided as an example that will work in most GNU/Linux installations. You can use different commands, e. g. psql -U depending commands: 70 shell> psql -U psql> create database zabbix; psql> \q Then import initial schema and data: # zcat /usr/share/doc/zabbix-server-pgsql/create.sql.gz | psql -U zabbix -u zabbix PostgreSQL command: # zcat /usr/share/doc/zabbix-proxy-pgsql-3.0.X/schema.sql.gz | psql -U zabbix SQLite command: # zcat /usr/share/doc/zabbix-proxy-sqlite3-3.0.X/schema.sql

gz | sudo -u zabbix psql zabbix Attention: The above commands are provided as an example that will work in most GNU/Linux installations. You can use different commands, e. g. psql -U depending following commands: shell> psql -U psql> create database zabbix; psql> \q Then import initial schema and data: # zcat /usr/share/doc/zabbix-server-pgsql/create.sql.gz | psql -U zabbix -u zabbix PostgreSQL command: # zcat /usr/share/doc/zabbix-proxy-pgsql-3.2.X/schema.sql.gz | psql -U zabbix SQLite command: # zcat /usr/share/doc/zabbix-proxy-sqlite3-3.2.X/schema.sql

PostgreSQL 的导入命令外，还需运行： ·# cat /usr/share/zabbix-sql-scripts/postgresql/timescaledb.sql | sudo -u zabbix psql zabbix Warning: 只有 Zabbix 服务器支持 TimescaleDB。 PHP 7.2 Zabbix 前端需要 7.2 或更新的 PHP 版本。 SELinux 配置 PostgreSQL（或 SQLite）的代理： ·# cat /usr/share/zabbix-sql-scripts/postgresql/proxy.sql | sudo -u zabbix psql zabbix ·# cat /usr/share/zabbix-sql-scripts/sqlite3/proxy.sql | sqlite3 zabbix.db 为 Zabbix 代理配置数据库 PostgreSQL 导入命令，还要执行： # cat /usr/share/doc/zabbix-sql-scripts/postgresql/timescaledb.sql | sudo -u zabbix psql zabbix Warning: TimescaleDB 仅支持 Zabbix 服务器。 PHP 7.2 Zabbix 前端需要 PHP 7.2 或更新的版本来启动 Zabbix 5.0。