Document ID: TEC618785
Last Modified Date: 10/9/2014
Authored By: FrancisLee
- CA Application Performance Management
- CUSTOMER EXPERIENCE MANAGER
When running a fresh installation of 9.6 APM database (Postgres), the following error appears:
Additional Notes: ERROR - createdb: database
creation failed: ERROR: new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII)
HINT: Use the same encoding as in the template database, or use template0 as template.
(STDOUT: Creating user admin
Creating database cemdb with the admin user as the owner.
This error is most likely caused by the LANG setting on the server.
To change this setting, edit the LANG setting in the file /etc/sysconfig/i18n file.
This is the system file where the Postgres installer gets the locale settings used to create the database.
An example is the following:
After setting this value, then uninstall the existing Postgres, and reinstall the database.