Re: how to create backup copies

[Andreas Pflug <pgadmin(at)pse-consulting(dot)de>]

Andrus wrote:
> I created a bat file mybackup.bat
>
> set FAILINIMI=%DATE:~8,4%%DATE:~5,2%%DATE:~2,2%eevavarukoopia.backup
> "C:\Program Files\pgAdmin III\1.4\pg_dump.exe" -i -Z9 -b -v -f 
> "C:\mydir\%FAILINIMI%" -F c -h localhost -U postgres mydb
>
>
> and verified it using RUNAS that it runs OK under posgres account.
>
> I entered c:\mydir\mycackup.bat
>
> to a pgagent script window
>
>
> however, statitics window displays the following error each time I try to 
> run this job:
>
> Couldn't execute script C:DOCUME~1\postgres\LOCAL~1TemppgaD591.tmp1_1.bat

Try to run CMD explicitely.

Regards,
Andreas