# backup files tar --directory /opt/hu.dwim.number-toss --exclude "sb-posix/test-output" --exclude "sbcl/obj" --exclude "sbcl/output" -cjf /opt/hu.dwim.number-toss/backup/workspace-`date --rfc-3339 date`.tar.bz2 workspace/ rsync --recursive --links --times --omit-dir-times --progress --partial --delete lmeszaros@dwim.hu:/opt/hu.dwim.number-toss/backup/ /home/levy/workspace/hu.dwim.number-toss/backup # backup database (postgres version independent) pg_dump --clean --column-inserts --file=/opt/hu.dwim.number-toss/backup/database/hu.dwim.number-toss.`date --rfc-3339 date`.dump --host=localhost --username=hu.dwim.number-toss hu.dwim.number-toss # restore database sudo su - postgres dropdb hu.dwim.number-toss createdb hu.dwim.number-toss exit psql hu.dwim.number-toss --username hu.dwim.number-toss --password -f /home/levy/workspace/hu.dwim.number-toss/backup/database/hu.dwim.number-toss.2012-01-13.dump | less # pulling of files posing security risk darcs pull will complain about permission denied and leave the pulled changes as pending local edits sudo chmod g+w . cron.daily darcs rev sudo chmod g-w . cron.daily