Deleting Old Database Log Files

AtScale includes a modified PostgreSQL database that logs all operations that are performed in the Design Center and against published virtual cubes. Log files are rotated by the AtScale engine every 24 hours automatically. Over time, a large number of log files can accumulate. It is recommended that you periodically reclaim disk space by deleting old log files.

The log files are stored in the folder /opt/atscale/log/database.

The size of each file depends on the amount of activity that the database logs. To understand how large log files become in your system environment before they are rotated, monitor their growth during periods of normal activity in AtScale and normal rates of queries on virtual cubes. Then, you can configure batch jobs to delete old files at intervals that you estimate to be appropriate. It is recommended that you retain several days' worth.