how to detect the backup database every day

From: son(at)raider(dot)co(dot)nz
To: pgsql-general(at)postgresql(dot)org
Subject: how to detect the backup database every day
Date: 2007-08-07 06:09:35
Message-ID: 59398.202.78.240.7.1186466975.squirrel@www.raider.co.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 -:(

Is there a solution around this.

If you have any experience about this please help...

Regards

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sergei Shelukhin 2007-08-07 08:17:56 Re: finding out vacuum completion %, and vacuum VS vacuum full
Previous Message Naz Gassiep 2007-08-07 05:22:03 Removing a schema