Skip to main content

Posts

Showing posts with the label batch script in windows

Database Avilability Check In Windows

Hi, Here is the script in windows for refference and will the PostgreSQL DB availability. If configure mail_send command in windows, we can send e-mails as well. @ECHO OFF set PSQL="C:\Program Files\PostgreSQL\9.1\bin" set DBNAME="template1" set USER="postgres" set PORT="5432" set RES="Not Pinging" %PSQL%\psql -Atq -c "SELECT 'ping'" -p %PORT% -U %USER% %DBNAME% > _Res.txt set /p RES= echo %RES% IF %RES% EQU ping (echo "No need to send any exceptional e-mail") else (echo "PostgreSQL seems not pinging.. Need to send an e-mail to RDBA") Hope this helps you a lot ... --Dinesh