kevin’s blog

@echo off
 
set PG_BIN_PATH=C:\Programme\PostgreSQL\8.3\bin
set PG_BACKUP_PATH=C:\backup\pg
 
set PGHOST=localhost
set PGUSER=postgres
set PGPASSWORD=postgres
set PGPORT=5432
set PGDATABASE=database
set PGCODING=UTF8
 
 
if not exist "%PG_BIN_PATH%" goto exit
if not exist "%PG_BACKUP_PATH%" goto create_pg_backup_path
 
goto run
 
:create_pg_backup_path
mkdir "%PG_BACKUP_PATH%"
 
:run
set PG_BACKUP_TIME=%TIME:~1,1%_%TIME:~3,2%_%TIME:~6,2%
set PG_BACKUP_DATE=%DATE:~6,4%_%DATE:~3,2%_%DATE:~0,2%
 
%PG_BIN_PATH%\pg_dump.exe -i --format c --verbose --file=%PG_BACKUP_PATH%\%PGDATABASE%-%PG_BACKUP_DATE%-%PG_BACKUP_TIME%.backup
 
:exit
exit