Re: Prelude database maintenance
Webmaster <[email protected]>
| Newsgroups | gmane.comp.security.ids.prelude.user |
|---|---|
| Message-ID | <[email protected]> |
Sorry Jaime, forgot something. The script in the previous mail deletes events. Substitute the preludedb-admin line with: preludedb-admin move alert "type=mysql name=prelude user=prelude pass=prelude" "host=pgsql.host type=pgsql name=prelude pass=prelude" --criteria "alert.create_time < $DATE" preludedb-admin move heartbeat "type=mysql name=prelude user=prelude pass=prelude" "host=pgsql.host type=pgsql name=prelude pass=prel7ude" --criteria "alert.create_time < $DATE" This will move the data to another db. Jaime Ventura wrote: > Hello, > the prelude DB on my system is getting really big, causing prewikka > to run very slow. > Is there any quick way to "archive" old records (say 6 month old)? > > Thanks. > Jaime > > -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. _______________________________________________ Prelude-user site list [email protected] http://lists.prelude-ids.org/mailman/listinfo/prelude-user