Please note that the below information is given as is with no liability taken by PI or Patrix. Do not proceed to use the below information against your repository unless you are well aware of what you do. Also, before you proceed executing the audit log purging function, make sure you have a valid full backup of your DMS appliance.
General
Nuxeo maintains a full audit log of every user and/or system interaction with any document in the repository or it's associated metadata container. Over time, the audit log can grow to a very substantial size - potentially beyond the size of the repository data. The audit log is kept in the postgres database and thus, the database size can grow significantly. The audit log includes the history information for every document as can be accessed under then "History" tab for a document in the nuxeo console.
Starting with version 1.8 of the service container, it is possible to purge the nuxeo audit log up to a certain date by way of a purge script. In addition to this, the script performs a full vacuuming of the database incl. index rebuild.
Purging the audit log
In order to run the purge script, run the following commands:
Run a bash inside the service container:
docker exec -it service bash
- Inside the container, run the purge script as follows:
/opt/clean_nxlog.sh <date>
<date> is the cut-off date in the format yyyy-mm-dd
Note: It is advisable to run the above commands in a screen so as to avoid any negative effects in case the connection to the DMS shell breaks.