Backup, was RE: [SL] While installing on SME etc, etc

[david <da...@ke...>]

On Tue, 2006-05-02 at 09:37 -0500, ATM Logic wrote:

> 
> Yes, I agree totally on the backup not found... At least I had one from a
> Month and a Half ago...  Now I have shown the wife how to backup our
> accounting system she has backed it up twice in the last hour  :)
> 

This sounds like a good time for a backup discussion. There is no way
that I can trust myself to run backup manually, so I have this running
as a daily cron job:


pg_dump -U sql-ledger -f /backup/postgresql/`date +%y%m%d%H%M`.SL SL
rdiff-backup /backup/ me@remote::/backup/ 1> /dev/null 2>> /backup/log
echo "`date +%y%m%d%H%M` backup complete" >> /backup/log

That should give me two daily copies of the database, one local, one
remote. Naturally, I never test my backup system. That would be much too
sensible, and by test, I mean restore and compare with what it really
should be.. I do know that this produces lots of files that LOOK ok! So
far I've not had any failures. If the above doesn't work I'm in trouble.

What do others do? My system is not "live" - I enter data after the
event, so once per day is reasonably sane. What would you do if you were
depending on live data being entered from lots of locations and the loss
of an hour's entries could be catastrophic?