How do I reconfigure EventSentry and store all future data in the new v9.6 PostgreSQL database instance?

Follow the steps below to reconfigure EventSentry to store all future data in the new PostgreSQL v9.6 database and retain all existing data inside the legacy PostgreSQL v9.1 instance.

Instructions

1. Open the EventSentry Management Console


2. Note down the eventsentry_svc password from the database action's connection string


3. Note down the eventsentry_web password from the C:\Program Files (x86)\EventSentry\WebReports\conf\configuration.xml file (<dbPassword>)


4. If using collector, stop all local EventSentry services (under Services). If not using the collector then also stop all remote agents.


5. Stop the EventSentry Database service


6. Stop the EventSentry Database v9.6 service


7. Open regedit.exe


8. Navigate to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\eventsentrydatabase


9. In the ImagePath value, change 5432 to 5433


10. Navigate to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\eventsentrydatabase96


11. In the ImagePath value, change 5433 to 5432


12. Start the EventSentry Database v9.6 service


13. Start the EventSentry Database service


14. Select the Primary Database action and click the Initialize or Update Database button


15. When prompted, specify the passwords for the eventsentry_web and eventsentry_svc


16. The configuration assistant should process the database without errors


17. Click the Test button in the action to verify that connectivity to the database is successful


18. Select Services and start all local services that were previously running. If not using the collector then also start all remote agents


19. Stop the EventSentry Web Reports services


20. Open a text editor like notepad as administrator


21. Open the file C:\Program Files (x86)\EventSentry\WebReports\conf\configuration.xml


22. Copy the <webprofiles id="1"> ... </webprofiles> section into the clipboard and paste it between </webprofiles> and </configuration>


23. In the newly pasted section, make the following changes:


24. Replace <webprofiles id="1"> with <webprofiles id="2">


25. Replace <dbPort>5432</dbPort> with <dbPort>5433</dbPort>


26. Replace <title>EventSentry</title> with <title>EventSentry Archive</title>


27. Replace <name>DEFAULT</name> with <name>EventSentry Archive</name>


28. Start the EventSentry Web Reports services


29. Navigate to the EventSentry Web Reports to ensure that both the DEFAULT and the EventSentry Archive profiles are accessible