Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-25616

PostgreSQL 17 is still not supported for the Zabbix database

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Won't fix
    • Icon: Trivial Trivial
    • None
    • 7.0.6
    • Server (S)
    • None

      I use docker images postgres:latest (17.2) and zabbix/zabbix-server-pgsql:latest (7.0.6).

      Error raises when starting up the server.


      postgres log:

      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".


      Zabbix Sever log:

      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...

            zabbix.dev Zabbix Development Team
            stammer Diego Henrique Stammerjohann
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: