Search: Advanced search
Please enter a keyword or ID
Surround SCM PostgreSQL Installation Fails on Linux
When you install PostgreSQL on Linux, the installation fails and the following error is returned:
'ERROR: encoding UTF8 does not match server's locale en_US'
Surround SCM 2009 and later supports UTF-8 metadata and requires a UTF-8 encoded database. Because PostgreSQL on Linux is restricted to using character sets that are compatible with the server’s LC_CTYPE setting, which is defined at the operating system’s installation, PostgreSQL may not allow the creation of a UTF-8 encoded database.
You need to change the locale LC_CTYPE settings of your Linux server installation. The server’s LC_CTYPE must be UTF8, C, or POSIX. Refer to your Linux distribution’s documentation for information on supported locales and how to modify the configuration. Also, see the PostgreSQL Character Set Support documentation for additional information about character encodings.