How to compact an Overseer 4.1 database

Posted on September 23rd, 2011

Overseer generally maintains its own database and doesn’t bloat significantly larger than it needs to be to hold your data. However, in some limited situations, it may be beneficial to compact the database if it gets quite large for some reason. This function should be built into Overseer at a future time, but for now it can be done with this manual process:

  1. Download the Windows command line shell tool from¬†http://www.sqlite.org/download.html¬† (currently labeled ‘sqlite-shell-win32-x86-3070800.zip’, but that will change as new versions are released)
  2. Extract the contents of the above zip file to your c:\Program Files\Overseer 4\Data\ directory(assuming default paths)
  3. Make sure Overseer is closed
  4. Launch a command shell by going to Start->Run and typing ‘cmd’ and pressing enter.
  5. Type the following commands:
    cd "\program files\overseer 4\data"
    net stop overseersvc
    sqlite3 overseer4config.db vacuum
    sqlite3 overseer4data.db vacuum
  6. Now, you can close the command window and re-start Overseer, which will automatically prompt to restart the service.

If you have any questions or anything doesn’t go as described here, please contact support using the support link above.

Thanks.