-
Notifications
You must be signed in to change notification settings - Fork 1
/
setup_gpfo_rhel6.sh
executable file
·55 lines (47 loc) · 1.71 KB
/
setup_gpfo_rhel6.sh
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
#!/bin/bash
### confirm gpdb status
echo "Is current GPDB started?"
echo -n "vip_env.sh modified? "
read re
if [ $re = "y" ] || [ $re = "Y" ];then
### Copy Files - mdw
mkdir /usr/local/bin
cp *.sh /usr/local/bin/
chown gpadmin /usr/local/bin/*
cp vip /etc/rc.d/init.d/
chown gpadmin /etc/rc.d/init.d/vip
echo "1. Copy Files - mdw : OK"
### Copy Files - smdw
ssh root@smdw 'mkdir /usr/local/bin'
scp *.sh smdw:/usr/local/bin/
ssh root@smdw 'chown gpadmin /usr/local/bin/*'
scp vip smdw:/etc/rc.d/init.d/
ssh root@smdw 'chown gpadmin /etc/rc.d/init.d/vip'
scp S99gpfailover smdw:/etc/rc.d/rc3.d/
ssh root@smdw 'chown gpadmin /etc/rc.d/rc3.d/S99gpfailover'
scp gpfailover smdw:/etc/rc.d/init.d/
ssh root@smdw 'chown gpadmin /etc/rc.d/init.d/gpfailover'
echo "2. Copy Files - smdw : OK"
### smdw .bash_profile modify
a=$(ssh root@smdw 'cat /home/gpadmin/.bash_profile | grep "/usr/local/greenplum-db/greenplum_path.sh" | wc -l')
if [ "$a" == "0" ];then
ssh root@smdw 'echo ". /usr/local/greenplum-db/greenplum_path.sh" >> /home/gpadmin/.bash_profile'
fi
b=$(ssh root@smdw 'cat /home/gpadmin/.bash_profile | grep "export MASTER_DATA_DIRECTORY=/data/master/gpseg-1" | wc -l')
if [ "$b" == "0" ];then
ssh root@smdw 'echo "export MASTER_DATA_DIRECTORY=/data/master/gpseg-1" >> /home/gpadmin/.bash_profile'
fi
c=$(ssh root@smdw 'cat /home/gpadmin/.bash_profile | grep "export PGPORT=5432" | wc -l')
if [ "$c" == "0" ];then
ssh root@smdw 'echo "export PGPORT=5432" >> /home/gpadmin/.bash_profile'
fi
echo "3. smdw .bash_profile modify : OK"
### confirm gpdb status
### service daemon setup
./vip_start.sh
echo "4. mdw vip_start : OK"
ssh root@smdw 'service start gpfailover'
echo "5. smdw service : OK"
else
echo "Please, confirm gpdb, vip_env.sh!!!"
fi