Database Maintenance | MetaDefender Core 4.19.0 or above

PostgreSQL database could be more bulky over time with high scanning traffic. Even manually removing scan history or leaving it to data retention to clean up old records, it will not immediately remove actual data in the PostgreSQL database which is fully controlled by PostgreSQL.

The tool which is bundled with MetaDefender Core installation is to analyze database and vacuum database effectively, and simplify IT administration.

• Windows: <MetaDefender Core installation folder>\ometascan-vacuum-db.exe
• Linux: /usr/sbin/ometascan-vacuum-db

How-to run instructions

Windows

1. Open cmd as Administrator
2. Navigate to MetaDefender Core installation folder (e.g. C:\Program Files\OPSWAT\MetaDefender Core )
3. Call: ometascan-vacuum-db.exe with no arguments.
4. Upon done, expected to have a new database analysis and vacuum outcome package auto generated in the same folder with format: analyze_and``_cleanup_database``<timestamp>.zip

Linux

1. Run as superuser privileges: sudo export LD_LIBRARY_PATH=/usr/lib/ometascan
2. Run as superuser privileges: sudo /usr/sbin/ometascan-vacuum-db
3. Upon done, expected to have a new database analysis and vacuum outcome package auto generated in /usr/lib/ometascan/ with format: /usr/lib/ometascan/analyze_and_cleanup_database_<timestamp>.tar.gz

What’s inside the generated package?

Including database object size analysis before and after running vacuum, the vacuum result and log, the new database size after vacuum. That helps us analyze and determine how effective the vacuum performs against that database, and investigate if any issue occurs.