In-house, we use Microsoft Windows Defender, which is free and comes with any Microsoft OS that is Windows 7 or higher. Over the past 10 years, Windows Defender functionality and reputation had grown. Our position is to recommend you to use Windows Defender as your anti-virus solution. Windows Defender is an anti-virus solution that we can support since we use it in-house. If it should have issue with Elliott, we would know with our in-house environment. We should be able to duplicate the issue and work with Microsoft to come up with a solution to address the problem. The bottom line is we can support Windows Defender. On the other hand, it is almost impossible for us to support hundred of other third party anti-virus software and each one of them can come up with their own unique rules.  

If you do install anti-virus software on the database server, you should definitely do the following:

• White list the pervasive directories:
• PSQL 11 client will be installed in the following folders:

• 32-bit client: C:\Program Files (x86)\Pervasive Software\PSQL\bin
• 64-bit client: C:\Program Files\Pervasive Software\PSQL\bin

• PSQL 12 client will be installed in the following folders:

• 32-bit client: C:\Program Files (x86)\Actian\PSQL\bin
• 64-bit client: C:\Program Files\Actian\PSQL\bin

• White list the Elliott application executables and dlls in <ElliottRoot> and <ElliottRoot>\Bin folders.
  
• White list he Elliott data directories in <ElliottRoot>\DATA...etc.
  

Apply the same principle to your desktop and other servers where the anti-virus software is installed. After installing it, you should monitor it for the first couple weeks for any performance issue or errors, as you might need to white list additional directories/files.


EMK