Hello guys,
after upgrade my Zabbix instance from verstion 3.4 to 4.0 i have trouble with postgreSQL database. In zabbix_server.log i found:
In Zabbix Dashbbard I also have error (in attachment)
Please help,
Greetings
after upgrade my Zabbix instance from verstion 3.4 to 4.0 i have trouble with postgreSQL database. In zabbix_server.log i found:
8834:20220713:133426.906 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERRPR: "pg_collation" relation not exist
LINE 1: ..._class as c on c.relfilenode=a.attrelid left join pg_collati...
^
[select count(*) from pg_attribute as a left join pg_class as c on c.relfilenode=a.attrelid left join pg_collation as l on l.oid=a.attcollation where atttypid in (25,1043) and c.relnamespace=2200 and c.relam=0 and l.collname<>'default']
8834:20220713:133426.906 cannot get character set of database "zabbix" fields
LINE 1: ..._class as c on c.relfilenode=a.attrelid left join pg_collati...
^
[select count(*) from pg_attribute as a left join pg_class as c on c.relfilenode=a.attrelid left join pg_collation as l on l.oid=a.attcollation where atttypid in (25,1043) and c.relnamespace=2200 and c.relam=0 and l.collname<>'default']
8834:20220713:133426.906 cannot get character set of database "zabbix" fields
Please help,
Greetings
Attached Files