X-Git-Url: https://dev.renevier.net/?a=blobdiff_plain;f=scripts%2Fcrontab.syj;h=cf80bef8bc5f9279d621b420049264a8d229e65e;hb=bfe63b61894a100bd3d83ac86593a8d767b94920;hp=4dfe865ee74a69faa5db4b1e40ecdbb35c719f82;hpb=03f49f88786c9eefcb850927958646266f11a86d;p=syj.git

diff --git a/scripts/crontab.syj b/scripts/crontab.syj
index 4dfe865..cf80bef 100644
--- a/scripts/crontab.syj
+++ b/scripts/crontab.syj
@@ -6,6 +6,10 @@ MAILTO=arno@renevier.net
 # every day, delete old sessions files
 47 4 * * * find /tmp/ -name "sess_*" -user syj  -ctime +45 -exec rm -f '{}' \;
 # every day, vacuum tables
-48 4 * * * psql syj syj -c "VACUUM ANALYZE users"
-48 4 * * * psql syj syj -c "VACUUM ANALYZE paths"
-48 4 * * * psql syj syj -c "VACUUM ANALYZE pending_actions"
+48 4 * * * psql syj syj -c "VACUUM ANALYZE users" > /dev/null
+48 4 * * * psql syj syj -c "VACUUM ANALYZE paths" > /dev/null
+48 4 * * * psql syj syj -c "VACUUM ANALYZE pending_actions" > /dev/null
+# every day, clear lighttpd compress cache
+12 5 * * * find /data/work/syj/lighttpd/lighttpd-cache -type f -mtime +2 | xargs -r rm
+# every day, database backup
+12 16 * * * pg_dump -t paths -t paths_id_seq -t pending_actions -t pending_actions_id_seq -t users -t users_id_seq  | gzip > /data/project/syj/backups/db_$(date +'\%Y-\%m-\%d').gz