When the size of the PostgreSQL database becomes too large, the cron jobs may not work efficiently.
To resolve this issue, delete the old entries to reduce the database size:
- Log in to the InterScan Web Security Suite (IWSS) or InterScan Web Security Virtual Appliance (IWSVA) shell.
- Go to the applicable location:
- For IWSS: .../etc/iscan/PostgreSQL/bin
- For IWSVA: .../var/iwss/PostgreSQL/bin
- Execute the following command:
./psql –U sa –d iwssThe "sa" password will be required. This is usually set by customer to "sa" or "trend". If this is not the case, the passowrd is stored in the /etc/iscan/.pgpass file or /etc/iscan/odbc.ini file, which you can see using the "# cat /etc/iscan/.pgpassu" command.
Giving the correct password, the PostgreSQL interactive terminal displays the following:
iwss => TRUNCATE TABLE [table name];
Where the table names are:
- tb_performance_value: This contains performance information when performance logging is enabled.
- tb_url_usage: This contains access logs when access logging is enabled.
- tb_violation: This contains caught viruses, blocked URLs, and other violations.
- After truncating each tables, execute this command:
iwss => VACUUM;
The vacuum task is done daily at 3:58 AM.
- Type "\q" to exit the interactive terminal.
- Chek if the database has been shrunk successfully by verifying the database size:
# /usr/iwss/bin/admin_checksize.sh localhost 5432 sa iwss