[ZBXNEXT-9238] Support PostgreSQL 17 Created: 2024 Jun 10  Updated: 2024 Dec 05  Resolved: 2024 Nov 07

Status: Closed
Project: ZABBIX FEATURE REQUESTS
Component/s: Documentation (D), Frontend (F), Server (S)
Affects Version/s: 6.0.30, 6.4.15, 7.0.0, 7.2.0alpha1
Fix Version/s: 5.0.45rc1, 6.0.36rc1, 6.4.20rc1, 7.0.6rc1, 7.2.0beta1

Type: Change Request Priority: Major
Reporter: Edgar Akhmetshin Assignee: Mihails Prihodko
Resolution: Fixed Votes: 6
Labels: None
Remaining Estimate: Not Specified
Time Spent: 2h
Original Estimate: Not Specified

Issue Links:
Related
related to ZBX-25616 PostgreSQL 17 is still not supported ... Closed
Team: Team B
Sprint: Prev.Sprint, S24-W40/41, S24-W42/43
Story Points: 0.25

 Description   

PostgreSQL 17 already released in Beta 1.

https://www.postgresql.org/about/news/postgresql-17-beta-1-released-2865/

Images:
https://hub.docker.com/_/postgres



 Comments   
Comment by Mihails Prihodko [ 2024 Oct 15 ]

Available in versions:

Comment by Marianna Zvaigzne [ 2024 Oct 29 ]

Documentation updated:

Comment by Diego Henrique Stammerjohann [ 2024 Nov 24 ]

PostgreSQL 17 is still not supported on 7.0.6

2024-11-24 08:17:56 2024-11-24 11:17:56.937 UTC [497] STATEMENT: SELECT
2024-11-24 08:17:56 d.datname as "Name",
2024-11-24 08:17:56 pg_catalog.pg_get_userbyid(d.datdba) as "Owner",
2024-11-24 08:17:56 pg_catalog.pg_encoding_to_char(d.encoding) as "Encoding",
2024-11-24 08:17:56 CASE d.datlocprovider WHEN 'c' THEN 'libc' WHEN 'i' THEN 'icu' END AS "Locale Provider",
2024-11-24 08:17:56 d.datcollate as "Collate",
2024-11-24 08:17:56 d.datctype as "Ctype",
2024-11-24 08:17:56 d.daticulocale as "ICU Locale",
2024-11-24 08:17:56 d.daticurules as "ICU Rules",
2024-11-24 08:17:56 pg_catalog.array_to_string(d.datacl, E'\n') AS "Access privileges"
2024-11-24 08:17:56 FROM pg_catalog.pg_database d
2024-11-24 08:17:56 ORDER BY 1;
2024-11-24 08:17:57 2024-11-24 11:17:57.041 UTC [498] ERROR: column d.daticulocale does not exist at character 289
2024-11-24 08:17:57 2024-11-24 11:17:57.041 UTC [498] HINT: Perhaps you meant to reference the column "d.datlocale".

2024-11-24 07:59:18 ** Preparing Zabbix server
2024-11-24 07:59:18 ** Preparing database
2024-11-24 07:59:18 ** Using POSTGRES_USER variable from ENV
2024-11-24 07:59:18 ** Using POSTGRES_PASSWORD variable from ENV
2024-11-24 07:59:18 ********************
2024-11-24 07:59:18 * DB_SERVER_HOST: zabbix-server-database
2024-11-24 07:59:18 * DB_SERVER_PORT: 5432
2024-11-24 07:59:18 * DB_SERVER_DBNAME: zabbix
2024-11-24 07:59:18 * DB_SERVER_SCHEMA: zabbix
2024-11-24 07:59:18 ********************
2024-11-24 07:59:18 **** PostgreSQL server is not available. Waiting 5 seconds...

I am using docker images postgres:latest and zabbix/zabbix-server-pgsql:latest

Comment by Peter Szabo [ 2024 Nov 28 ]

Hello All,

 

first of first: thanks for this awesome sowftware and for the transparent communication regarding the project!

I experience the same as the previous poster: creating a brand-new 7.0.6 stack with pg17, server for postgres and the web interface, from containers, results in the same error message. With pg16 all is fine.

The container images i used are the following and just checked on dockerhub, the digests match:

REPOSITORY                               TAG                IMAGE ID      CREATED     SIZE
docker.io/library/postgres               17-bullseye        12904aba17e0  6 days ago  435 MB
docker.io/zabbix/zabbix-web-nginx-pgsql  alpine-7.0-latest  652c938cc0d3  8 days ago  230 MB
docker.io/zabbix/zabbix-server-pgsql     alpine-7.0-latest  fd706132bfb3  8 days ago  63.8 MB

Checked with Ubuntu image, the result is the same.
What could be wrong ?

Generated at Mon Mar 10 15:10:46 EET 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.