PostgreSql backup bat file not creating backup file -


i have created bat file take backup of postgresql database. following bat file like:

@echo off    /f "tokens=1-4 delims=/ " %%i in ("%date%") (      set dow=%%i      set month=%%j      set day=%%k      set year=%%l    )    set datestr=%month%_%day%_%year%    echo datestr %datestr%     set backup_file=backup_%datestr%.backup    echo backup file name %backup_file%    set pgpassword=password    echo on    bin\pg_dump -i -h localhost -p 5432 -u postgres -f c -b -v -f %backup_file% databasesample 

i created postgresqlbackup.bat , put inside c:\program files\postgresql\9.3\bin postgresql instalation directory.

before setting pgjob scheduler i tried double click on bat file checking whether working or not. no backup files got created inside particular folder. please guide me. looking on different location?


Comments