zabbix/zabbix-server-pgsql:ol-7.0-latest container can't connect to postgresql 18 server

XMLWordPrintable

    • Type: Problem report
    • Resolution: Unresolved
    • Priority: Major
    • None
    • Affects Version/s: 7.0.25
    • Component/s: Packages (C), Server (S)
    • None
    • Environment:
      Hyper-V virtual machine, running oracle linux 9.7, postgresql database server version 18.3, zabbix-server running from podman image zabbix/zabbix-server-pgsql:ol-7.0-latest, version 7.0.25.
    • Support backlog
    • 1

      Steps to reproduce:

       
      1. Install postgresql server 18 from official postgresql repository
      2. Run the podman container, using these settings:

      podman run \
        -p 10051:10051 \
        -e DB_SERVER_HOST="192.168.100.100" \
        -e POSTGRES_USER="zabbix" \
        -e POSTGRES_PASSWORD="postgres_password" \
        -e ZBX_HANODENAME="zabbix-node-2" \
        -e ZBX_NODEADDRESS="192.168.100.11" \
        -e ZBX_NODEADDRESSPORT="10051" \
        -e DB_SERVER_SCHEMA="zabbix_server" \
        -v /var/lib/zabbix/server2:/var/lib/zabbix:Z,U \
        --cap-add=net_raw \
        --restart always \
        -d zabbix/zabbix-server-pgsql:ol-7.0-latest
      

      3. After you running the server container, viewing zabbix/zabbix_server.log file. shows an error:

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

      4. Postgresql server logs also show this SQL error:

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

      5. But if we are using a different linux distro container, like alpine ( zabbix/zabbix-server-pgsql:alpine-7.0-latest ), there are no such errors present.

      Possible cause: Oracle Linux in it's official repository is using an old postgresql 16 library, which is not fully compatible with the latest postgresql server version.

            Assignee:
            Zabbix Development Team
            Reporter:
            Alberts Kamisans
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated: