postgresql database patch 06030038 fails

[harribal]

All,

I'm trying to upgrade from Zabbix 6.2.9 to 7.0.X, without any intermediate upgrades, eg 6.2 -> 6.4 -> 7.0. I have not seen anywhere that this is required, but I may be wrong.
I have followed the upgrade procedure in https://www.zabbix.com/documentation/7.0/en/manual/in...

[Bacil123]

Hello All. We are setting up Zabbix with Nginx/Posgres combo as Frontend/Backend(Same Server).
Created initial DB as per Zabbix documentation:
sudo -u postgres createuser --pwprompt zabbix
sudo -u postgres createdb -O zabbix zabbix

Imported initial schema and data:...

[hector.estatut]

Hello everyone,
I'm new to this. Let me introduce myself, my name is Hector and I'm studying a vocational training course in Systems and Network Administration in Spain. The final degree project I'm going to present is related to monitoring with Zabbix. I've chosen to do it in the following way:...

[dieselfluxcapacitor]

I am trying to understand the correct way to migrate my old Zabbix PostgreSQL database to a new PostgreSQL server. My attempts to migrate the database have not been successful and I anticipate it has to do with TImescaleDB.

ENVIRONMENT:
SERVER A (old database server)

• Zabbix 6.4
• Ubuntu

...

[shafuq]

So I'm trying to setup timescaledb on my new zabbix installation:

Zabbix 7.0 > Ubuntu > 24.04 > Server > postgresql > nginx

I can't find anything online for this specific combination regarding zabbix7+timescaledb - Only RHEL-Based guides out there.
...

[Beetle]

We have a Zabbix 6 instance from that we have upgraded to Zabbix 7 one month ago. During the time we have found the DB size of v.7 is grown almost double the size as v.6. So Is there any known issues faced by anyone post upgrade to Zabbix 7.

Zabbix 6:
Database Type - Postgresql -...

[Min Tun]

Hi everyone,

I saw the official documentation of PostgreSQL by Zabbix Agent2 supports for Postgres Version 10-15. https://git.zabbix.com/projects/ZBX/...at=release/7.0
Is this template usable for PostgreSQL 16? If not support, how could...

[Dhadcock]

I upgraded from Zabbix 6.0LTS to 7.0 LTS. Now I can't login into the console, it says:

"The Zabbix database version does not match current requirements. Your database version: 7000000. Required version: 6000000. Please contact your system administrator."

I have postgres...

[SANDMAN]

I have a Zabbix 6.4.3 stack. It uses Postgres 15.3 database.

Trying to upgrade to zabbix 7.0 and Postgres 16.3 database.

Using other Postgres guides as Zabbix documentation doesn't seem to discuss Postgres upgrade procedures.
https://www.zabbix.com/documentation/curr...

[ruryx00]

hello everyone i have an installation of zabbix server in version 6.4 using postgresql+timescaledb as database.
I would like to perform an update of both the server and the database without losing my data.
more information about my setup:

• Postgres 14.2
• Timescaledb 2.12.2
• zabbix server

...

[whanklee]

Hi.

I tried to upgrade from 6.4 to 7.0, however, I got this error message.
Does anyone know what I should do to fix it? I have no idea.

Versions: Ubuntu 22.04, PostgreSQL 16.

140363:20240609:075628.856 VMware monitoring: YES
140363:20240609:075628.856

...

[justintaylor9]

I'm getting the following message:

Cannot read the response, check connection with the Zabbix server "az1-ufit-irs-prod-zabbix-01.server.ufl.edu".

This appears on the main page whenever the web UI is reloaded. Zabbix version 6.2.9.

I can share additional...

[sardylan]

Hi all,
I've a little problem monitoring PostgreSQL with Zabbix Agent 2 (both server and agent version 6.0 LTS).
Everything is working fine, the Agent auto-discover new databases and start to collect stats on new DBs also.

Since my application creates and drop databases during...

[Dan18]

We have an older system with

• Zabbix 4.x LTS
• PosgreSQL 11
• CentOS7

...and we want to migrate/upgrade/move to

• Zabbix 6.x LTS
• PostgreSQL 13
• Debian 12

as efficient as possible.
We do not need the history of the collected data from the agents.
However, it would be nice to have the hosts...

[alfie013]

Hi all, i'm planning to migrate our Zabbix server on-prem to Azure using the latest version. We are using PostgreSQL as our database. Does anyone know if Zabbix support postgresql paas?
If not, what would be the best way to migrate the database from on-prem (running in Cent7 with Zabbix server...