Steps to Reproduce:

1. Upgrade PostgreSQL from 15 to 17 with TimescaleDB 2.19.3.
2. Deploy Zabbix 7.0.13 in a containerized environment.
3. Attempt to restore a database dump from PostgreSQL 15.

Result:

• SQL query fails:

  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",
    pg_catalog.array_to_string(d.datacl, E'\n') AS "Access privileges"
  FROM pg_catalog.pg_database d
  ORDER BY 1;

Expected:

• Successful database query execution.
• Full compatibility with PostgreSQL 17 and TimescaleDB 2.19.3 in containerized Zabbix 7.0.13.

Additional Info:

• Reference: ZBX-25616
• Possibly related GitHub issue: zabbix-docker#1572
• Error with Postgreqsl version 17 - ZABBIX Forums
   

Thank you,
Best Regards.