Re: [SQL] check files .backup

2011-01-26 Thread Craig Ringer
On 01/25/2011 11:14 PM, manuel antonio ochoa wrote: I would like it complete and not truncated? That it hasn't been modified since being originally written? OK. First, check the exit code from pg_backup so you detect any failures. The exit code is reported by the shell on UNIX systems in the

Re: [SQL] check files .backup

2011-01-24 Thread Scott Marlowe
On Mon, Jan 24, 2011 at 5:18 PM, manuel antonio ochoa wrote: > Do you know if exist a  function to check my file.backup created by pgdump. I run backups like this in bash: if (pg_dump yadayada); then echo "backup succeeded." else echo "backup failed." fi; in a cronjob set to email me.

Re: [SQL] check files .backup

2011-01-24 Thread Craig Ringer
On 25/01/11 08:18, manuel antonio ochoa wrote: > Do you know if exist a function to check my file.backup created by > pgdump. ? What do you want to check? That it restores correctly? That it's complete and not truncated? That it hasn't been modified since being originally written? That it matches