-
Problem report
-
Resolution: Won't fix
-
Trivial
-
None
-
7.0.6
-
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...
- related to
-
ZBXNEXT-9238 Support PostgreSQL 17
- Closed