Re: automating backups with windows scheduled tasks and pg_dumpall

From: Tom Hart <tomhart(at)coopfed(dot)org>
To: Postgres General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: automating backups with windows scheduled tasks and pg_dumpall
Date: 2007-11-15 23:18:30
Message-ID: 473CD3C6.1090106@coopfed.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Hart wrote:
> SCassidy(at)overlandstorage(dot)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/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Trevor Talbot 2007-11-15 23:18:50 Re: Postgresql and resource isolation
Previous Message Tom Hart 2007-11-15 23:17:25 Re: Tom thinks it's bad code was 8.3 vs 8.2 sql compatibility issue