Document ID: TEC618785
Last Modified Date: 10/9/2014
Authored By: FrancisLee
- Products
- CA Application Performance Management
- Components
- CUSTOMER EXPERIENCE MANAGER
Description:
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
CREATE ROLE
Creating database cemdb with the admin user as the owner.
)
Solution:
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:
LANG="en_US.UTF-8"
After setting this value, then uninstall the existing Postgres, and reinstall the database.
Search the Entire CA APM Knowledge Base