More
Browsing Tag

PostgreSQL

Upgrading Zabbix 7 DB to PostgreSQL17 with Timescaledb 2.17

By Antti Hurme 25/11/2024 No Comments 4 Min Read

With Zabbix release 7.0.6 (Release Notes for Zabbix 7.0.6) both TimescaleDB extension 2.7 (ZBXNEXT-9532) and PostgreSQL 17 (ZBXNEXT-9238) became officially supported. Great! Time to upgrade the homelab environment! Upgrading to PostgreSQL 17 In my homelab environment, I’ve had PostgreSQL 15 before the upgrade with TimescaleDB extension version 2.15. Always refer to the official PostgreSQL upgrade manual for upgrade paths. Note that this is for a stand-alone single node PGSQL database,…

Continue Reading

Upgrading Zabbix with PSQL and TimescaleDB to specific version

By Antti Hurme 04/06/2024 No Comments 2 Min Read

When upgrading to Zabbix 7.0, the minimum version of TimescaleDB extension has been increased, thus you might encounter the following error if you’ve been conservative when upgrading the extension due to version mismatch. Starting Zabbix Server. Zabbix 7.0.0 (revision 49955f1fb5c).using configuration file: /etc/zabbix/zabbix_server.conf TimescaleDB version 20902 is not officially supported. Recommended version is at least TimescaleDB Community Edition 2.10.0.Zabbix Server stopped. Zabbix 7.0.0 (revision 49955f1fb5c). To upgrade the timescaledb extension,…

Continue Reading

[Z3005] Zabbix PostgreSQL database upgrade failed

By Antti Hurme 07/03/2023 No Comments 1 Min Read

When upgrading your Zabbix Database, you might encounter the following error “[Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  permission denied for schema public”. The zabbix user you’ve created doesn’t normally need access to the database schema to work, so this would only be relevant when upgrading the zabbix version, for example between 6.2.x to 6.4.0. To fix the error, you need to give the zabbix database user access to modify the public…

Continue Reading