segunda-feira, março 07, 2011

Monitoramento de banco de dados

01 #! /bin/sh
02
03 while true
04 do
05
06 time=$(date +%d.%m.%y\ %H:%M\)
07
08 psql -U monitor -d monitor -c "select * from watch;"
09
10 if $? -eq;
11
12 then
13
14 echo "$time: Database is not accessible! **" >>
dba.log
15 /usr/local/etc/rc.d/002pgsql.sh start
16 sleep 15
17 psql -U monitor -d monitor -c "select * from watch;
18
19 if [ $? -eq 0 ];
20
21 then
22
23 echo "$time: Database online!+++++" >> dba.log
24
25 else
26
27 echo "$time: Database: serious error!
**********" >> dba.log
28 echo "$time:Unable to restart! ***********" >>
dba.log
29 while true
30 do
31 psql -U monitor -d monitor
32
33 if [ $? -eq 0 ];
34
35 then
36
37 time=$(date +%d.%m.%y\ %H:%M\)
38 echo "$time: Database online! +++++" >> dba.log
39 break
40
41 fi
42 sleep 15
43 done3
44
45 fi
46
47 fi
48 sleepd l5
49
50 done