how to detect the backup database every day - Mailing list pgsql-general

From son@raider.co.nz
Subject how to detect the backup database every day
Date
Msg-id 59398.202.78.240.7.1186466975.squirrel@www.raider.co.nz
Whole thread Raw
Responses Re: how to detect the backup database every day  (Richard Huxton <dev@archonet.com>)
Re: how to detect the backup database every day  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List 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



pgsql-general by date:

Previous
From: Naz Gassiep
Date:
Subject: Removing a schema
Next
From: cluster
Date:
Subject: tsearch2: plainto_tsquery() with OR?