Re: automating backups with windows scheduled tasks and pg_dumpall

Tom Hart wrote:
> SCassidy@overlandstorage.com wrote:
>> One other oddity I ran into recently on one system only, is that a
>> perl program (.pl extension) worked fine from the command-line,
>> double-clicked on, etc. but in the scheduled job, I had to put "perl
>> xxx.pl" for it to work.  Maybe if all else fails, try "cmd.exe
>> xxx.bat" or "command.com xxx.bat" or similar in the scheduled task?
> Thanks for your reply.
>
> I just got this running right before I read this email. A shame,
> because this tip precisely would have helped me. Turns out that on the
> command line you can just type foobar.bat, but in scheduled tasks, you
> must place a cmd.exe /c before it, instructing windows to spawn a
> shell first (why windows isn't intelligent enough to figure this out
> on it's own, I have no idea). Anyway if anybody else is curious I
> didn't change anything in the batch file I posted previously, but I
> changed the scheduled task command from "c:\foo\bar\pg_backup.bag" to
> "cmd.exe /c c:\foo\bar\pg_backup.bat".
>
> Hope this can help somebody else avoid the hours of confusion.
>
> On a side note, you seem to have a pretty strange email client setup,
> because your text came through extremely small (almost unreadable) to
> me, yet your signature came out just fine. Odd...
Side note 2: This could very easily have been an issue with my email
client as well. I did not intend to sound as if it were an issue with
your setup :-)
>> Susan Cassidy
>>
>> ----------------------------------------------------
>> Tiered Data Protection Made Simple
>> http://www.overlandstorage.com/
>> ----------------------------------------------------
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>               http://archives.postgresql.org/