Changes between Version 1 and Version 2 of Documentation/Community/HowTo/ManuallyPurgeLogs
- 08/09/10 11:40:07 (3 years ago)
v1 v2 8 8 chsh -s /bin/bash ebox # give shell to ebox use so we could use it to connect to the db 9 9 su ebox -c'psql eboxlogs' # DB shell 10 chsh -s /bin/ bashebox # remove shell form ebox when we have finished 10 chsh -s /bin/ ebox # remove shell form ebox when we have finished 11 11 12 12 }}} 13 13 14 In the postgre shell you could see the existent tables with the command '/dt'and you could use normally the DELETE SQL sentence to purge the data. 14 In the postgre and you could use normally the DELETE SQL sentence to purge the data. 15 15 16 DON T remove data from the tables 'consolidation' and 'report consolidation' they store the last date of consolidationand if they are empty the next consolidation will be done since the beginning. 16 DON and if they are empty the next consolidation will be done since the beginning. 17 17 18 18 The tables that end in '_daily', '_hourly', '_weekyl', '_monthly' or _report' are tables with report and summary consolidation data and they should not be very big so you could ignore them.