[OPEN-ILS-DEV] Deleting the data in the auditor schema

Galen Charlton gmc at esilibrary.com
Mon Oct 31 13:27:40 EDT 2011


Hi,

On 10/31/2011 01:27 PM, Mike Rylander wrote:
> Just a lack of troubleshooting information that can be handy.  Though,
> auditor tables are rarely used, and the logs are usually enough.

And in the case of doubt (or external requirements that the the data be 
retained), you can always use pg_dump to back up the auditor schema to a 
file before clearing out the auditor.*_history tables.  You can also 
consider keeping just the past few months of auditor rows.

Regards,

Galen
-- 
Galen Charlton
Director of Support and Implementation
Equinox Software, Inc. / The Open Source Experts
email:  gmc at esilibrary.com
direct: +1 770-709-5581
cell:   +1 404-984-4366
skype:  gmcharlt
web:    http://www.esilibrary.com/
Supporting Koha and Evergreen: http://koha-community.org & 
http://evergreen-ils.org


More information about the Open-ils-dev mailing list