Difference between revisions of "How to shrink the database"
From Tech-Wiki
(Created page with "Category:Tufin If the partition is full delete some old log files to make some space. Change the number of days Configure > Administration > Maintenance") |
|||
| Line 5: | Line 5: | ||
Change the number of days | Change the number of days | ||
Configure > Administration > Maintenance | Configure > Administration > Maintenance | ||
| + | Reduce the number of days in the Cleanup Historical Data table | ||
| + | |||
| + | Start the database | ||
| + | start db | ||
| + | |||
| + | Start the deletion of the old data | ||
| + | /usr/local/st/st_monitor | ||
| + | tail -F /var/log/st/st_monitor | ||
| + | |||
| + | Reclaim the database space (vacuum the DB) | ||
| + | psql securetrack -Upostgres -c "VACUUM FULL" | ||
Latest revision as of 02:19, 21 September 2011
If the partition is full delete some old log files to make some space.
Change the number of days
Configure > Administration > Maintenance Reduce the number of days in the Cleanup Historical Data table
Start the database
start db
Start the deletion of the old data
/usr/local/st/st_monitor tail -F /var/log/st/st_monitor
Reclaim the database space (vacuum the DB)
psql securetrack -Upostgres -c "VACUUM FULL"