Re: PgAgent Installation ERROR

Registering file is done and then defined the bat file and created a job. the backup file is getting generated but its of 0kb

plz check the following for the bat file content

--------------
@echo off
REM - backup directory can be a file server share that the PgAgent windows service account has access to
set BACKUPDIR="E:/POSTGRESJOBS/DAILYBACKUPS/"
set PGHOST="localhost"
set PGPORT="5433"
set PGUSER="postgres"
set PGBIN="C:/Program Files/PostgreSQL/8.3/bin/"
for /f "tokens=1-4 delims=/ " %%i in ("%date%") do (
 set dow=%%i
 set month=%%j
 set day=%%k
 set year=%%l
)

for /f "tokens=1-3 delims=: " %%i in ("%time%") do (
 set hh=%%i
 set nn=%%j
)

REM - It would be nice to use gzip in the pg_dumpall call (or if pg_dumpall supported compression as does the pg_dump)
REM here as we do on the linux/unix script
REM - but gzip is not prepackaged with windows so requires a separate install/download.
REM Our favorite all purpose compression/uncompression util for Windows is 7Zip which does have a command-line
%PGBIN%pg_dump -i -h %PGHOST% -p %PGPORT% -U %PGUSER% -F c -b -v -f "%BACKUPDIR%DATABASENAME-%year%%month%%day%%hh%.backup" DATABASENAME

--------------------------





--
Kranti K K Parisa
M: +91 - 9391 - 438 - 738
O: +91 - 4023 - 844 - 738
------------------------------------------------------------------
" world will be different, if...... "
------------------------------------------------------------------