Prepare a PostgreSQL Database for Event Reporting in Omnissa Horizon Console

Before you can use Horizon Console to configure an event database on PostgreSQL, you must edit a configuration file so that the Omnissa Horizon Connection Server can communicate with the PostgreSQL database.

Prerequisites

• Verify that you are running Omnissa Horizon 8 version 2103 or later. The ability to use a PostgreSQL database for event reporting is only supported in these Horizon 8 versions.
• Create a PostgreSQL database for event reporting. See Add a Database and Database User for Horizon 8 Events in Horizon Console.
• Verify that you have the required database privileges to configure the database.

Procedure

1. In the directory where PostgreSQL is installed, open the data/pg_hba file for editing.

2. Add the following row to the table under IPv4 local connections (replace with the actual IP address of the Horizon Connection Server):

   TYPE	DATABASE	USER	ADDRESS	METHOD
   host	all	all	<IP address of Horizon Connection Server>	md5

3. Save the file.

What to do next

Use Horizon Console to connect the database to Horizon Connection Server. Follow the instructions in Configure the Event Database in Horizon Console.