Whipe clean all logs and events for all modules?

[Mathiau]

Since it seems i have some huge event logs in my system...and it takes literally minuted to view events as it "compiles." and i get excessively high CPU usage from 4-7 on a quad core...

is it possible to emtpy all of the event logs for all modules on all racks and almost 'start' over as if it were a fresh install?

[dmorris]

/etc/init.d/untangle-vm stop && psql -U postgres -c "drop schema reports cascade;" uvm && /etc/init.d/untangle-vm start

edit Disclaimer to others reading this thread: my posting of this is not in any way an endorsement or suggestion to do this. I am not saying this is a good idea. I am simply answering his question.

[Mathiau]

Appreciated!

should this be quick or will it kill the FW while it does it

[dmorris]

I guess that depends on your definition of quick. My guess would be no.

[Mathiau]

ahahaa, off it goes!

[Mathiau]

good to go, less than a minute

~ # /etc/init.d/untangle-vm stop && psql -U postgres -c "drop schema reports cascade;" uvm &&
cmdand cmdand> /etc/init.d/untangle-vm start
 * Stopping Untangle VM                                                                                                                                           [...............ungraceful exit......]

NOTICE:  drop cascades to table reports.merged_address_map
NOTICE:  drop cascades to default for table reports.merged_address_map column id
NOTICE:  drop cascades to sequence reports.n_openvpn_stats_event_id_seq
NOTICE:  drop cascades to default for table reports.n_openvpn_stats column event_id
NOTICE:  drop cascades to sequence reports.n_bandwidth_quotas_event_id_seq
NOTICE:  drop cascades to default for table reports.n_bandwidth_quotas column event_id
NOTICE:  drop cascades to sequence reports.n_bandwidth_penalties_event_id_seq
NOTICE:  drop cascades to default for table reports.n_bandwidth_penalties column event_id
NOTICE:  drop cascades to sequence reports.n_webcache_stats_event_id_seq
NOTICE:  drop cascades to default for table reports.n_webcache_stats column event_id
NOTICE:  drop cascades to sequence reports.n_mail_addrs_event_id_seq
NOTICE:  drop cascades to default for table reports.n_mail_addrs column event_id
NOTICE:  drop cascades to sequence reports.n_mail_msgs_event_id_seq
NOTICE:  drop cascades to default for table reports.n_mail_msgs column event_id
NOTICE:  drop cascades to sequence reports.n_http_events_event_id_seq
NOTICE:  drop cascades to default for table reports.n_http_events column event_id
NOTICE:  drop cascades to sequence reports.sessions_event_id_seq
NOTICE:  drop cascades to default for table reports.sessions column event_id
NOTICE:  drop cascades to table reports.n_webcache_stats
NOTICE:  drop cascades to table reports.n_openvpn_connect_totals
NOTICE:  drop cascades to table reports.n_openvpn_stats
NOTICE:  drop cascades to table reports.n_bandwidth_quotas
NOTICE:  drop cascades to table reports.n_bandwidth_penalties
NOTICE:  drop cascades to table reports.n_adlogin_events
NOTICE:  drop cascades to table reports.n_adlogin_totals
NOTICE:  drop cascades to table reports.reports_state
NOTICE:  drop cascades to table reports.email
NOTICE:  drop cascades to table reports.users
NOTICE:  drop cascades to table reports.hnames
NOTICE:  drop cascades to table reports.n_mail_msg_totals
NOTICE:  drop cascades to table reports.n_shield_totals
NOTICE:  drop cascades to table reports.n_virus_http_totals
NOTICE:  drop cascades to table reports.n_virus_mail_totals
NOTICE:  drop cascades to table reports.n_shield_rejection_totals
NOTICE:  drop cascades to table reports.session_totals
NOTICE:  drop cascades to table reports.n_http_totals
NOTICE:  drop cascades to table reports.n_server_totals
NOTICE:  drop cascades to table reports.n_mail_addr_totals
NOTICE:  drop cascades to table reports.n_server_events
NOTICE:  drop cascades to table reports.n_mail_addrs
NOTICE:  drop cascades to table reports.n_mail_msgs
NOTICE:  drop cascades to table reports.n_http_events
NOTICE:  drop cascades to table reports.session_counts
NOTICE:  drop cascades to table reports.sessions
NOTICE:  drop cascades to table reports.n_admin_logins
NOTICE:  drop cascades to table reports.table_updates
NOTICE:  drop cascades to table reports.report_data_days
DROP SCHEMA
 * Starting Untangle VM                                                                                                                                           [...........................|.............................]

root@def2#

[Mathiau]

guess i had a hella-lotta logs which were slowing the system down, the system is so much more responsive and tolerable, the GUI is just cruising!