Embedded repositories such as PostgreSQL Infobright database used by SQL PI as the database repository and MySQL and PostgreSQL Foglight Management Server (FMS) databases may encounter performance issues or crash due to the presence of running antivirus applications scanning the repository.
The steps detailed here can be used to help identify if an Antivirus application is installed and whether the required exclusions have been set.
In some circumstances, conflicts between the embedded databases and the Antivirus or Anti-malware product may require disabling the other product.
The following products have been found to compete for CPU resources with the Infobright component of SQL PI. It is recommended that the services / processes be disabled on the server running the SQL PI repository.
Users may be able to use the following steps to review the Antivirus configuration on a Windows server.
You can also manually check for antivirus software on desktops (Windows 7, Windows 10) using this wmi query.
(From DOS) wmic /NAMESPACE:\\root\SecurityCenter2 PATH AntiVirusProduct Get displayname /Format:List
Windows desktops have these SecurityCenter2 WMI objects, but the namespace doesn’t exist on servers
(from PowerShell) Get-WmiObject -Namespace "root\SecurityCenter2" -Query "SELECT * FROM AntiVirusProduct"
Our deployment guide and product requirements indicate that the entire Infobright folder should be excluded due to know corruption issues that can result when postgresql database files are scanned by AV processes.
"Note: Exclude the SQL PI repository directory (named InfoBright) from real-time scanning (e.g.: Antivirus software)"
Some these actively used extensions include
along with several others, but most of the postgresql data files have no extension.
This lack of extension is because postgresql for Windows was originally ported from Linux and requires a wildcard (*).
For this reason, the request to have the entire Infobright folder is necessary.
This external Wiki article details why it is important to exclude the postgresql folder with all of the files from AV scanning.