how to create backup copies

From: "Andrus" <eetasoft(at)online(dot)ee>
To: pgadmin-support(at)postgresql(dot)org
Subject: how to create backup copies
Date: 2006-04-12 20:53:26
Message-ID: e1jpce$28s$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Andreas Pflug 2006-04-13 08:10:34 Re: how to create backup copies
Previous Message Andreas Pflug 2006-04-12 14:15:42 Re: 1.4.2 Bug-report