On installing a fresh APM database, getting an error about an incompatible encoding with the template database.

Document ID : KB000003904
Last Modified Date : 14/02/2018
Show Technical Document Details

 When running a fresh installation of the 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.

All Supported APM Releases

   This error is typically caused by the LANG setting on the server.


  To change this setting, edit the LANG value 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. 


  Usually, this error will go away, if this is not the case, then open a Support case to resolve the issue.