[EMAIL PROTECTED] wrote:
Hello all
I use a crontab job to backup and restore my database every midnight every
day (using pg_dump and restore...)
My cron job run well for a while. However, today I discovered that my
database was not restored for one month.
I also fix the problem as there is corruption in the script.
My question is how I can detect whether the backup or restore processes is
corrupted. I donot want that my backup database is one month old -:(
Well, if the script failed with an error, cron should have sent you an
email (or the user the script runs as, anyway).
If you didn't have an error, you could run a separate cron that checks
whether there are recent backup files and emails you if not (find ...
-mtime -1).
Or, if you want to make sure the restore has worked check the database
for a row with a recent timestamp.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
