Changes between Version 1 and Version 2 of Documentation/Community/HowTo/ManuallyPurgeLogs

Show
Ignore:
Timestamp:
08/09/10 11:40:07 (3 years ago)
Author:
ejhernandez@… (IP: 87.222.135.133)
Comment:

Some minor fixes

Legend:

Unmodified
Added
Removed
Modified

  • Documentation/Community/HowTo/ManuallyPurgeLogs

    v1 v2  
    88chsh -s /bin/bash ebox # give shell to ebox use so we could use it to connect to the db 
    99su ebox -c'psql eboxlogs' # DB shell 
    10 chsh -s /bin/bash ebox # remove shell form ebox when we have finished 
     10chsh -s /bin/false ebox # remove shell form ebox when we have finished 
    1111 
    1212}}} 
    1313 
    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. 
     14In the postgres shell you could see the existent tables with the command `/dt` and you could use normally the DELETE SQL sentence to purge the data. 
    1515 
    16 DONT remove data from the tables 'consolidation' and 'report consolidation' they store the last date of consolidation and if they are empty the next consolidation will be done since the beginning. 
     16DON'T remove data from the tables 'consolidation' and 'report consolidation' as they store the last consolidation date and if they are empty the next consolidation will be done since the beginning. 
    1717 
    1818The 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.