From bfe63b61894a100bd3d83ac86593a8d767b94920 Mon Sep 17 00:00:00 2001 From: arno Date: Mon, 29 Nov 2010 13:20:21 +0100 Subject: [PATCH 1/1] crontab: database backup --- scripts/crontab.syj | 2 ++ 1 file changed, 2 insertions(+) diff --git a/scripts/crontab.syj b/scripts/crontab.syj index 0513a30..cf80bef 100644 --- a/scripts/crontab.syj +++ b/scripts/crontab.syj @@ -11,3 +11,5 @@ MAILTO=arno@renevier.net 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 -- 2.39.5