On Thu, 2006-06-01 at 10:15, John R. Allgood wrote:
> Hello
>
> I have a question regarding backups on Postgresql 7.4.7-2. We are
> currently using a Progress database and will be moving over to Postgres
> this month. In Progress there is a way to verify your backups does
> Postgres have anything similiar or is there other ways to accompplish
> this. I am currently writing backup and other utility scripts and would
> like to incorporate this into my program.
I wrapped my backup in a bash script, and that seems to catch errors.
something like:
if !(
/data01/pg/bin/pg_dump dbname > dbname.sql
);
then
cat "backup failed"|mail -s "backup failed" yourname@yourdomain.com;
fi
To test this, I corrupted a table in a test database to force a hard
failure, and it sent an email. Don't know if it's a comprehensive test,
but it seems to work for us.