Re: [GENERAL] how to detect the backup database every day

2007-08-07 Thread brian
Richard Huxton wrote: [EMAIL PROTECTED] wrote: Hello all I use a crontab job to backup and restore my database every midnight every day (using pg_dump and restore...) My cron job run well for a while. However, today I discovered that my database was not restored for one month. I also fix t

Re: [GENERAL] how to detect the backup database every day

2007-08-07 Thread Scott Marlowe
On 8/7/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hello all > > I use a crontab job to backup and restore my database every midnight every > day (using pg_dump and restore...) Backup from one machine, restore to another, right? > My cron job run well for a while. However, today I discover

Re: [GENERAL] how to detect the backup database every day

2007-08-07 Thread Richard Huxton
[EMAIL PROTECTED] wrote: Hello all I use a crontab job to backup and restore my database every midnight every day (using pg_dump and restore...) My cron job run well for a while. However, today I discovered that my database was not restored for one month. I also fix the problem as there is cor

[GENERAL] how to detect the backup database every day

2007-08-06 Thread son
Hello all I use a crontab job to backup and restore my database every midnight every day (using pg_dump and restore...) My cron job run well for a while. However, today I discovered that my database was not restored for one month. I also fix the problem as there is corruption in the script. My