Zabbix 6.0をTimescaleDB対応のPostgreSQLとの組み合わせでインストールした

# lxc launch ubuntu:22.04

# sudo -u postgres createuser --pwprompt zabbix
could not change directory to "/root": Permission denied
Enter password for new role:
Enter it again:
# sudo -u postgres createdb -O zabbix zabbix
could not change directory to "/root": Permission denied

# zcat /usr/share/zabbix-sql-scripts/postgresql/server.sql.gz | sudo -u zabbix psql zabbix
(大量に流れていく)
COMMIT

# echo 'CREATE EXTENSION IF NOT EXISTS timescaledb;' | sudo -u zabbix psql zabbix
could not change directory to "/root": Permission denied
WARNING:
WELCOME TO
 _____ _                               _     ____________
|_   _(_)                             | |    |  _  \ ___ \
  | |  _ _ __ ___   ___  ___  ___ __ _| | ___| | | | |_/ /
  | | | |  _ ` _ \ / _ \/ __|/ __/ _` | |/ _ \ | | | ___ \
  | | | | | | | | |  __/\__ \ (_| (_| | |  __/ |/ /| |_/ /
  |_| |_|_| |_| |_|\___||___/\___\__,_|_|\___|___/ \____/
			   Running version 2.7.2
For more information on TimescaleDB, please visit the following links:

 1. Getting started: https://docs.timescale.com/timescaledb/latest/getting-started
 2. API reference documentation: https://docs.timescale.com/api/latest
 3. How TimescaleDB is designed: https://docs.timescale.com/timescaledb/latest/overview/core-concepts

Note: TimescaleDB collects anonymous reports to better understand and assist our users.
For more information and how to disable, please see our docs https://docs.timescale.com/timescaledb/latest/how-to-guides/configuration/telemetry.

CREATE EXTENSION

# cat /usr/share/zabbix-sql-scripts/postgresql/timescaledb.sql | sudo -u zabbix psql zabbix
could not change directory to "/root": Permission denied
NOTICE:  PostgreSQL version 14.5 (Debian 14.5-1.pgdg110+1) is valid
NOTICE:  TimescaleDB extension is detected
NOTICE:  TimescaleDB version 2.7.2 is valid
NOTICE:  TimescaleDB is configured successfully
DO

# echo 'Include=/etc/zabbix_server.conf.d/*.conf' >> /etc/zabbix/zabbix_server.conf
# mkdir -p /etc/zabbix_server.conf.d
# install -m 640 -o root -g zabbix <(echo 'DBPassword=SomeDataBasePassword') /etc/zabbix_server.conf.d/DBPassword.conf
# systemctl enable zabbix-server.service --now

root@zabbix-202210:~# cat /usr/share/zabbix-sql-scripts/postgresql/timescaledb.sql | sudo -u zabbix psql zabbix
could not change directory to "/root": Permission denied
NOTICE:  PostgreSQL version 14.5 (Debian 14.5-1.pgdg110+1) is valid
ERROR:  TimescaleDB extension is not installed
CONTEXT:  PL/pgSQL function inline_code_block line 42 at RAISE
root@zabbix-202210:~# su postgres -c psql
could not change directory to "/root": Permission denied
psql (14.5 (Debian 14.5-1.pgdg110+1))
Type "help" for help.

postgres=# CREATE database example;
CREATE DATABASE
postgres=# \c example
You are now connected to database "example" as user "postgres".
example=# CREATE EXTENSION IF NOT EXISTS timescaledb;
FATAL:  extension "timescaledb" must be preloaded
HINT:  Please preload the timescaledb library via shared_preload_libraries.

This can be done by editing the config file at: /etc/postgresql/14/main/postgresql.conf
and adding 'timescaledb' to the list in the shared_preload_libraries config.
		# Modify postgresql.conf:
		shared_preload_libraries = 'timescaledb'

Another way to do this, if not preloading other libraries, is with the command:
		echo "shared_preload_libraries = 'timescaledb'" >> /etc/postgresql/14/main/postgresql.conf

(Will require a database restart.)

If you REALLY know what you are doing and would like to load the library without preloading, you can disable this check with:
		SET timescaledb.allow_install_without_preload = 'on';
server closed the connection unexpectedly
		This probably means the server terminated abnormally
		before or while processing the request.
The connection to the server was lost. Attempting reset: Succeeded.
example=# \dx
				 List of installed extensions
  Name   | Version |   Schema   |         Description
---------+---------+------------+------------------------------
 plpgsql | 1.0     | pg_catalog | PL/pgSQL procedural language
(1 row)

example=#
\q
root@zabbix-202210:~#

root@zabbix-202210:~# echo 'CREATE EXTENSION IF NOT EXISTS timescaledb;' | sudo -u zabbix psql zabbix
could not change directory to "/root": Permission denied
WARNING:
WELCOME TO
 _____ _                               _     ____________
|_   _(_)                             | |    |  _  \ ___ \
  | |  _ _ __ ___   ___  ___  ___ __ _| | ___| | | | |_/ /
  | | | |  _ ` _ \ / _ \/ __|/ __/ _` | |/ _ \ | | | ___ \
  | | | | | | | | |  __/\__ \ (_| (_| | |  __/ |/ /| |_/ /
  |_| |_|_| |_| |_|\___||___/\___\__,_|_|\___|___/ \____/
			   Running version 2.8.0
For more information on TimescaleDB, please visit the following links:

 1. Getting started: https://docs.timescale.com/timescaledb/latest/getting-started
 2. API reference documentation: https://docs.timescale.com/api/latest
 3. How TimescaleDB is designed: https://docs.timescale.com/timescaledb/latest/overview/core-concepts

Note: TimescaleDB collects anonymous reports to better understand and assist our users.
For more information and how to disable, please see our docs https://docs.timescale.com/timescaledb/latest/how-to-guides/configuration/telemetry.

CREATE EXTENSION
root@zabbix-202210:~# cat /usr/share/zabbix-sql-scripts/postgresql/timescaledb.sql | sudo -u zabbix psql zabbix
could not change directory to "/root": Permission denied
NOTICE:  PostgreSQL version 14.5 (Debian 14.5-1.pgdg110+1) is valid
NOTICE:  TimescaleDB extension is detected
NOTICE:  TimescaleDB version 2.8.0 is valid
NOTICE:  TimescaleDB is configured successfully
DO

root@zabbix-202210:~# systemctl start zabbix-server.service
Job for zabbix-server.service failed because the service did not take the steps required by its unit configuration.
See "systemctl status zabbix-server.service" and "journalctl -xe" for details.
root@zabbix-202210:~# tail -n2 /var/log/zabbix/zabbix_server.log
 16613:20221006:075126.437 Unsupported DB! timescaledb version is 20800 which is higher than maximum of 20799
 16613:20221006:075126.437 Recommended version should not be higher than TimescaleDB Community Edition 2.7.
root@zabbix-202210:~#