8.3 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 Vertica is running in the same cluster as Investigate, the locale needs to be en_US@colstrength=secondary (case-insensitive). However, using this local might reduce the search performance of Investigate.

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

  1. Log in to Vertica 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.