Housekeeper problems - manual cleanup?

[cviper40]

Hi Julian.

I have the same problem that you reported. I got housekeeper enabled but it does not work.

Can you have any advise ?

PD: zabbix 1.8

[Colttt]

here an example to delete all items older than 180 days.. in postgreSQL

delete FROM history where age(to_timestamp(history.clock)) > interval '180 days'; 
delete FROM history_uint where age(to_timestamp(history_uint.clock)) > interval '180 days' ;
delete FROM history_str  where age(to_timestamp(history_str.clock)) > interval '180 days' ;
delete FROM history_text where age(to_timestamp(history_tex.clock)) > interval '180 days' ;
delete FROM history_log where age(to_timestamp(history_log.clock)) > interval '180 days' ;
delete FROM trends_uint where age(to_timestamp(trends_uint.clock)) > interval '180 days' ;
delete FROM trends where age(to_timestamp(trends.clock)) > interval '180 days';

[denaum]

doubt

do I need to stop the database to execute this commands?

tks

[mkhon]

I have created a script that does batched DELETE as history_uint and trends_uint tables could be quite big (I have about 1B records in history_uint):

https://gist.github.com/mkhon/7b840c4fbae23e7cf1acb1738657664e