Postgresql dump windows

Quelques paramètre sont spécifiques pour une remontée du dump dans la supervision

---------- SCRIPT DUMP ---------

@ECHO OFF

SET Server=localhost
SET Port=5433
SET User=postgres
SET Base_name=xxx --> a modifier
SET rep_old=D:\\PostgreSQL_backup\\8.4\\OLD
SET rep_sav=D:\\PostgreSQL_backup\\8.4\\CURRENT
SET PGPASSWORD=xxx --> a modifier
SET fic=%Base_name%_%date:~6,4%%date:~3,2%%date:~0,2%_%time:~0,2%%time:~3,2%%time:~6,2%.dump


D:\\PostgreSQL\\8.4\\bin\\pg_dump.exe -i -h %Server% -p %Port% -U %User% -F c -b -v -f %rep_sav%\\%fic% %Base_name%


# remplacer pg_dump.exe par pg_dumpall.exe pour un dump de toutes les bases


----------- SUP (couple avec un MSSQL) -------------

@echo off

set VC=C:\Agarik
set BINPATH=D:\Work\Tools\usr\local\wbin
set PATH=%PATH%;%BINPATH%
set TEMP=d:\work\Temp
set FULLNAME=xxx --> a modifier
set LIFETIME=31
set SERVICE=backup
set SUPERVISION=10.252.15.235
set COLOR=green

rem # MSSQL
cscript c:\windows\system32\eventquery.vbs /l application /fi "source eq SQLISPackage" | grep SQLISPackage > %TEMP%\output1.log
head -5 %TEMP%\output1.log > %TEMP%\output.log
gecho -n "set Error=" > %TEMP%\setvar.bat
cscript c:\windows\system32\eventquery.vbs /l application /fi "source eq SQLISPackage" | grep SQLISPackage > %TEMP%\warning.log
head -1 %TEMP%\warning.log | grep -c Error >> %TEMP%\setvar.bat

rem # PGSQL
gecho -n "set Error=" > %TEMP%\pgsql.bat
cat C:\Agarik\logdump_pgsql.txt | grep -c FATAL >> %TEMP%\pgsql.bat

call %TEMP%\setvar.bat
if %Error%==0 goto PGSQL

:MSSQLRED
set COLOR=red

:PGSQL
call %TEMP%\pgsql.bat
if %Error%==0 goto EOS

:PGSQLRED
set COLOR=red



:EOS
echo Dumps MSSQL : > %TEMP%\output_final.log
cat %TEMP%\output.log >> %TEMP%\output_final.log
echo ------------------------------------- >> %TEMP%\output_final.log
echo Dumps PGSQL : >> %TEMP%\output_final.log
gecho -n " " >> %TEMP%\output_final.log
cat C:\Agarik\logdump_pgsql.txt >> %TEMP%\output_final.log
%VC%\visionsvc.exe /file %SUPERVISION% 1984 status+%LIFETIME% %FULLNAME%.%SERVICE% %COLOR% %TEMP%\output_final.log