Q - We are thinking of installing McAfee End Point on the Elliott ERP server. Do you have any opinion about this anti-virus software?
A - Generally speaking, we don't recommend installing anti-virus software on the Elliott database server. Anti-virus software accounts for many support incidents involving Elliott Business Software not running. If you don't use your Elliott database (PSQL) server as a terminal server (which we don't recommend for security reasons), then the drawbacks of anti-virus software outweigh the benefits when it comes to the database server. There are actually many discussions on the Internet regarding why anti-virus software should not be installed on a database server.
On the other hand, we do recognize that anti-virus software is a necessary evil. It is necessary for regular desktops or any terminal servers. Any desktop that accesses email or is used to browse the Internet should be protected with anti-virus software. Unfortunately, there’s no way for us to tell which anti-virus software is more compatible than any other. Therefore, we can’t give a recommendation for one software vs. another. In-house, we simply use Microsoft Windows Defender, which is free and comes with any Microsoft OS that is Windows 7 or higher.
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.