Use > Database > Deploying the PostgreSQL Server Database > PostgreSQL Server Configuration > Always Exclude PostgreSQL Data Folder from Anti-Virus Scan

Always Exclude PostgreSQL Data Folder from Anti-Virus Scan

When a third-party Anti-Virus software scans the PostgreSQL server data folder, it could cause the PostgreSQL data tables to corrupt.

To resolve the issue, always make sure that the PostgreSQL install directory is added into the anti-virus software exclusion list. The exclusion of data files will not introduce any potential security risk.

If you need to run weekly-based scan, monitor the probeerror.log file, and if a database error shows up (for example, a database error related to the Discovery_result table), do the following:

  1. Clean the probe log folder.
  2. Run Clear Probe Results Cache from UCMDB UI > Data Flow Management > Universal Discovery > Discovery Modules/Jobs to clean the problematic table.

This should resolve the issue.