The anticipated database size depends on many factors not just the number of hosts that are being monitored. In order to predict the future database size you will need the following information: How many servers will be monitored What event log data will be consolidated For example will you be collecting Audit Success events How ...
The support utility was not able to connect to one of the configured database actions which usually indicates a connectivity problem between the host where the support utility was launched and the database server. Please try the following steps: Make sure that you have the required ODBC drivers installed. See Database ODBC Drivers for m...
When using Microsoft SQL Server with EventSentry we recommend setting up a Maintenance Plan to continually check integrity reduce index fragmentation and periodically shrink the database to free up unused disk space. The following instructions assume the SQL Server Agent is running and Agent XPs is set to enabled. For instructions to enabl...
It is not currently possible to migrate data from your existing Microsoft SQL Server MySQL or Oracle database to the builtin EventSentry PostgreSQL database. You can however switch to the builtin database going forward and retain old data in the existing MSSQL/MySQL/Oracle database. To do this follow the steps below. 1. Upgrade to Even...
The builtin EventSentry database ships with a basic configuration which is tuned for wide compatibility instead of speed. If you are collecting a lot of data it is likely that the default parameters are undersized for your system resulting in poor collector performance high outbound queue size or resulting in poor performance when searching...
If you are using the built in EventSentry database you can back it up using the pgdump.exe utility. This is located by default in the EventSentry\postgresql14\bin folder. You can create a batch file with the following contents: batch ECHO OFF SET PGPASSWORD=yourpostgresaccountpassword C:\Program Files\EventSentry\postgresql1...
If after purging data from your EventSentry database you still have enough disk space approximately 1.5x the database size is needed available on the drive you can open the PgADMIN software doubleclick EventSentry localhost:5432 to bring up the logon window and log on with the Postgres password and then follow these steps to shrink...
First we recommend you make a backup of the database in case you have any issues and need to reinstall: How do I back up the built in EventSentry database Once you39ve got a backup then you can proceed with moving the database by following these steps: Stop the EventSentry Database v14 Service Control Panel Administrative Too...
If you experience data corruption data loss or accidentally delete files from the internal Postgres database this guide will walk you through the steps to regenerate the internal Postgres database structure and recreate a fresh empty EventSentry database. Before proceeding with this guide ensure that you back up the data14 directory....
