PostgreSQL 17 support for zabbix-server-pgsql (all flavors)

[neothematrix]

hello!
I've just updated zabbix-server-pgsql container to zabbix 7.0.6 and I tried upgrading my postgresql from 16 to 17 (it's actually a postgres with timescaledb extension provided by timescaledb, but it shouldn't be too different).

After upgrading to Postgres 17, I'm not able to start zabbix-server-pgsql container anymore, with this error repeated in the container logs:

**** PostgreSQL server is not available. Waiting 5 seconds...

upon inspecting a little bit more, this is a message generated by the docker-entrypoint.sh when trying to test database availability:

psql --host ${DB_SERVER_HOST} --port ${DB_SERVER_PORT} --username ${DB_SERVER_ROOT_USER} --list

I tried manually executing that command and this is the output:

psql: ERROR: column d.daticulocale does not exist LINE 8: d.daticulocale as "ICU Locale", ^ HINT: Perhaps you meant to reference the column "d.datlocale".

I think the issue here is that all zabbix-server-pgsql images are still using "postgresql 16" client and possibly the "--list" command doesn't work properly with different DB versions.

I checked all the flavors (alpine, ubuntu and redhat) and they all show the same issue.

[fibbs]

Same here. Problem is that the postgresql CLIENT inside the image is still version 16.

[dotneft]

Sorry, how is it related to Zabbix Docker? The issue caused by PostgreSQL client. Please wait when fix will be available in OS distributions.

[TriDvaRas]

The error occurs when using old psql client with v17 server
So the issue(?) is that official zabbix images are using psql 16

Manually bumping psql to match the version 17 fixes this

[~]$ psql -V
psql (PostgreSQL) 16.6
[~]$ psql -h  dbhostname  -p 5432 -U zabbix -d zabbix --list
Password for user zabbix: 
psql: ERROR:  column d.daticulocale does not exist
LINE 8:   d.daticulocale as "ICU Locale",
          ^
HINT:  Perhaps you meant to reference the column "d.datlocale".

[~]$ psql -V
psql (PostgreSQL) 17.2
[~]$ psql -h  dbhostname  -p 5432 -U zabbix -d zabbix --list
Password for user zabbix: 
                                                 List of databases
   Name    |  Owner   | Encoding | Locale Provider | Collate |  Ctype  | Locale | ICU Rules |   Access privileges   
-----------+----------+----------+-----------------+---------+---------+--------+-----------+-----------------------
 postgres  | postgres | UTF8     | libc            | C.UTF-8 | C.UTF-8 |        |           | 
 template0 | postgres | UTF8     | libc            | C.UTF-8 | C.UTF-8 |        |           | =c/postgres          +
           |          |          |                 |         |         |        |           | postgres=CTc/postgres
 template1 | postgres | UTF8     | libc            | C.UTF-8 | C.UTF-8 |        |           | =c/postgres          +
           |          |          |                 |         |         |        |           | postgres=CTc/postgres
 zabbix    | zabbix   | UTF8     | libc            | C.UTF-8 | C.UTF-8 |        |           | 
(4 rows)

[neothematrix]

@dotneft maybe it's worth using the native "pg_isready" command to check database availability instead of psql --list?
it should work for all postgres versions: https://www.postgresql.org/docs/current/app-pg-isready.html

the same change should also be done for "web-nginx-pgsql" and "web-apache-pgsql"

[dotneft]

pgsql is used on server / proxy containers not only for checking availability.

[dotneft]

Added PostgreSQL 17 client to all images based on Alpine. Waiting for other OS distributions.

[neothematrix]

great news @dotneft thank you very much! has the new image been pushed to dockerhub already?

[dotneft]

Is in progress of building.

[ryanjphillips]

Reporting the same issue here. @dotneft If I'm not missing anything here there still isn't a updated image for this yet?

Edit: Specifically for the version 7.0.6 image?

[dotneft]

7.0.6 already released. So the tag is not changed, you can try to use "latest" tag till new version will be released.