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

[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