8.2 Setting the Default Locale for the Database

Does not apply if you used the ./install-single-node-post.sh installation script, which automatically performed this configuration.

For Identity Intelligence to function properly, when database is running in the same cluster as Recon, the locale needs to be en_US@colstrength=secondary (case-insensitive). However, using this local might reduce the search performance of Recon.

You can either use the /opt/<Identity_Intelligence_Installer>/postinstall_identityintelligence_database_set_locale_timeout.sh script automatically or you can set the default locale manually:

  1. Log in to database as a database administrator.

  2. To set the locale, execute the following command:

    alter database Investigate set DefaultSessionLocale = <locale>;

    For example:

    alter database Investigate set DefaultSessionLocale = 'en_US@colstrength=secondary';

    For more information, see the Implement Locales for International Data Sets section in the Vertica Documentation.