-
Documentation task
-
Resolution: Duplicate
-
Trivial
-
None
-
3.4.11
-
None
-
Zabbix 3.4.11 Documentation
The www link https://www.zabbix.com/documentation/3.0/manual/appendix/install/db_scripts does not specify to create the PostgreSQL database as UTF8 encoding.
The command in the documentation is 'sudo -u postgres createdb -O zabbix zabbix' which ends up creating:
_postgres=# \l_ _List of databases_ _Name | Owner | Encoding | Collate | Ctype |_ _--------------+--------------+----------+------------+------------+_ _postgres | postgres | LATIN1 | en_AU | en_AU |_ _template0 | postgres | LATIN1 | en_AU | en_AU |_ _template1 | postgres | LATIN1 | en_AU | en_AU |_ _*zabbix | zabbix | LATIN1 | en_AU| en_AU|*_ _(4 rows)_
The command that should be used to enforce the UTF8 encoding 'sudo -u postgres createdb -O zabbix_proxy zabbix_proxy --encoding=UTF8 --lc-ctype=en_AU.UTF8 --lc-collate=en_AU.UTF8 --template=template0' which ends up creating:
_postgres=# \l_ _List of databases_ _Name | Owner | Encoding | Collate | Ctype |_ _--------------+--------------+----------+------------+------------+_ _postgres | postgres | LATIN1 | en_AU | en_AU |_ _template0 | postgres | LATIN1 | en_AU | en_AU |_ _template1 | postgres | LATIN1 | en_AU | en_AU |_ _*zabbix | zabbix | UTF8 | en_AU.UTF8 | en_AU.UTF8 |*_ _(4 rows)_
- duplicates
-
ZBX-14892 "ERROR: value too long" when saving "Events and alerts" Housekeeping parameters
-
- Closed
-