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@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.