how to create backup copies - Mailing list pgadmin-support

From Andrus
Subject how to create backup copies
Date
Msg-id e1jpce$28s$1@news.hub.org
Whole thread Raw
Responses Re: how to create backup copies
List pgadmin-support
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


any idea how to create backups automatically every night ?

Environment:


Postgres 8.1.3
PgAdmin 1.4.2
Windows 2000 server

Andrus. 




pgadmin-support by date:

Previous
From: Andreas Pflug
Date:
Subject: Re: 1.4.2 Bug-report
Next
From: Andreas Pflug
Date:
Subject: Re: how to create backup copies