PostgreSQL database creation command needs to specify UTF8 in the options

XMLWordPrintable

    • Type: Documentation task
    • Resolution: Duplicate
    • Priority: Trivial
    • None
    • Affects Version/s: 3.4.11
    • Component/s: Documentation (D)
    • None
    • Environment:
      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)_

       

            Assignee:
            Zabbix Development Team
            Reporter:
            James Cook
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: