How do I make the built-in Postgres database record non-Latin text (such as Japanese, Chinese, Hebrew, etc) successfully?

Article ID: 333
Category: Database
Applies to: 3.0 and newer
Updated: 2018-11-07

Option A: If you have not completed the Configuration Assistant when installing EventSentry for the first time:
1A) Use the Microsoft documentation to locate the non-Latin text language you need to record, and then copy that language's Location column value from the documentation: https://msdn.microsoft.com/en-us/library/cc233982.aspx
2A) Execute this script in PgAdmin:
CREATE DATABASE databasename WITH ENCODING 'UTF8' LC_COLLATE='localevalue' LC_CTYPE='localevalue' TEMPLATE=template0;

Note: Replace "databasename" with the name that you would like to give your database. Replace "localevalue" with the value that you copied in step 1A

3A) Complete the Configuration Assistant to finish your EventSentry installation. Specify the database name that you chose in step 2A.


Option B: If you have already been using the database with your agents, and need to create a new database with the correct text options:
1B) Use the Microsoft documentation to locate the non-Latin text language you need to record, and then copy that language's Location column value from the documentation: https://msdn.microsoft.com/en-us/library/cc233982.aspx
2B) Execute this script in PgAdmin:
CREATE DATABASE databasename WITH ENCODING 'UTF8' LC_COLLATE='localevalue' LC_CTYPE='localevalue' TEMPLATE=template0;

Note: Replace "databasename" with the name that you would like to give your database. The database name must not already exist in PgAdmin. Replace "localevalue" with the value that you copied in step 1B.

3B) In the EventSentry console, select your existing database action on the left and view the database settings on the right. Click the X button (near the Create button) to remove the existing connection properites.
4B) Click the Initialize or Update Database button, making sure to specify the database name that you created in step 2B, and complete the database wizard
5B) Click the Test button to verify that the database can receive data
6B) Save your new settings, and then restart the functions on the EventSentry server by clicking Home > Services, and clicking all of the Restart buttons
7B) Deploy the new settings to your agents by clicking Groups > Push Configuration > Go, and then restart the agent services by clicking Groups > Other Actions > Restart > Go
8B) Either edit your existing web reports profile to view the new database, or if you need be able to view the original database and the new database you would need to make a second web reports profile for the new database
9B) In the selected web reports profile, review or fill in the new database settings and click Test Connection to ensure that the connection is successful. Scroll to the bottom and click Submit when you are finished.