Re: Postgres Backup Questions

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(at)yourdomain(dot)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.