Hi chaps, I was just wondering if anyone has any clever way of testing their backups taken with pg_dump on a daily basis? On a slightly separate note, I've setup a daily restore onto a staging server that I intend to also use to test the dumps, at the moment I've just set up a cron job. I'm sure capturing the output would be sufficient, however I'm having problems getting it into by logfile. su - $PGUSER -c "pg_restore -h localhost -U postgres --disable-triggers -c -d $database $backup_dir/$server-$database-data.gz" >> $logfile or su - $PGUSER -c "pg_restore -h localhost -U postgres --disable-triggers -c -d $database $backup_dir/$server-$database-data.gz >> $logfile" won't let me capture it. How dumb am I? __________________________________________________________ Sent from Yahoo! Mail. A Smarter Email http://uk.docs.yahoo.com/nowyoucan.html