Re: how to create backup copies

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