Housekeeping for postgresql and zabbix. I'm still using this after zabbix 2.0, and still working.

zabbix.housekeeping.sh

#Setting atual date
echo $(date +%d/%m/%Y-%H:%M)

#One year and month ago in Unix Timestamp
ONE_YEAR_AGO=$(expr `date +%s`  - 31536000)
ONE_MONTH_AGO=$(expr `date +%s` -  2678400)

#Queries for one month ago
MONTH_TABLES="history history_uint history_str history_text history_log"
for table in $MONTH_TABLES 
	do
		DELETES=$( /usr/bin/psql --dbname zabbix -c "delete from $table where  clock < $ONE_MONTH_AGO ;" )
		echo " $DELETES from table $table "
	done



#Queries for one year ago
YEAR_TABLES="alerts trends trends_uint"
for table in $YEAR_TABLES 
	do
		DELETES=$(/usr/bin/psql --dbname zabbix -c "delete from $table where clock < $ONE_YEAR_AGO ;")
		echo " $DELETES from table $table "
	done