Prepare a PostgreSQL Database for Event Reporting in Horizon Console

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

Prerequisites

• Create a PostgreSQL database for event reporting. See Add a Database and Database User for VMware Horizon 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 <IP address of Connection Server> with the actual IP address of the Connection Server):

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

3. Save the file.

What to do next

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