《GPDB学习笔记》版本升级

小版本手动升级与回退（6.0.0 <==> 6.1.0）

小版本升级

准备6.0和6.1版本包，如下：

[gpadmin@cgsl51 ~]$ ll
total 198512
drwxrwxr-x 2 gpadmin gpadmin      4096 12月 20 15:26 gpAdminLogs
drwxrwxr-x 2 gpadmin gpadmin       100 12月 20 15:23 gpconfigs
drwxr-xr-x 3 gpadmin gpadmin        20 12月 20 15:22 gpdata
drwxr-xr-x 4 gpadmin gpadmin        35 12月 20 15:22 gpdata1
drwxr-xr-x 4 gpadmin gpadmin        35 12月 20 15:22 gpdata2
lrwxrwxrwx 1 gpadmin gpadmin        18 12月 20 15:46 greenplum-db -> greenplum-db-6.0.0
drwxr-xr-x 9 gpadmin gpadmin       116 12月 20 15:46 greenplum-db-6.0.0
-rw-rw-r-- 1 gpadmin gpadmin  98586969 12月 20 15:58 greenplum-db-6.0.0.zip
-rwxrwxr-x 1 gpadmin gpadmin 104681175 12月 20 15:29 greenplum-db-6.1.0.zip
drwx------ 2 gpadmin gpadmin         6 12月 20 15:22 perl5
[gpadmin@cgsl51 ~]$ ls gpconfigs
all_hosts  all_segs_install  gpaddmirror_config  gpinitsystem_config
[gpadmin@cgsl51 ~]$ ls greenplum-db-6.0.0
bin  docs  etc  greenplum_path.sh  include  lib  sbin  share
[gpadmin@cgsl51 ~]$ ls greenplum-db-6.1.0
bin  docs  etc  greenplum_path.sh  include  lib  sbin  share

升级命令如下：

gpstop -aM fast
gpscp -f gpconfigs/all_hosts greenplum-db-6.1.0.zip =:/home/gpadmin
gpssh -f gpconfigs/all_hosts -e << END_OF_COMMAND
unzip -qo greenplum-db-6.1.0.zip;
rm -f greenplum-db && ln -s greenplum-db-6.1.0 greenplum-db;
cd $HOME/greenplum-db && sed '1c GPHOME=$HOME/greenplum-db-6.1.0' -i greenplum_path.sh;
cd $HOME/greenplum-db && cat greenplum_path.sh|grep -nw "^LD_LIBRARY_PATH"|cut -d: -f 1|xargs -i sed '{}c LD_LIBRARY_PATH=\$GPHOME/lib:\$GPHOME/ext/python/lib:\${LD_LIBRARY_PATH-}' -i greenplum_path.sh; source $HOME/greenplum-db/greenplum_path.sh
END_OF_COMMAND
gpstart -a

小版本回退

gpstop -aM fast
gpssh -f gpconfigs/all_hosts -e << END_OF_COMMAND
rm -f greenplum-db && ln -s greenplum-db-6.0.0 greenplum-db;
cd $HOME/greenplum-db && sed '1c GPHOME=$HOME/greenplum-db-6.0.0' -i greenplum_path.sh;
cd $HOME/greenplum-db && cat greenplum_path.sh|grep -nw "^LD_LIBRARY_PATH"|cut -d: -f 1|xargs -i sed '{}c LD_LIBRARY_PATH=\$GPHOME/lib:\$GPHOME/ext/python/lib:\${LD_LIBRARY_PATH-}' -i greenplum_path.sh; source $HOME/greenplum-db/greenplum_path.sh
END_OF_COMMAND
gpstart -a

gpupgrade升级GPDB

小版本升级（6.0.0 <==> 6.1.0）

[gpadmin@cgsl51 ~]$ ll
total 198512
drwxrwxr-x 2 gpadmin gpadmin      4096 12月 20 15:26 gpAdminLogs
drwxrwxr-x 2 gpadmin gpadmin       100 12月 20 15:23 gpconfigs
drwxr-xr-x 3 gpadmin gpadmin        20 12月 20 15:22 gpdata
drwxr-xr-x 4 gpadmin gpadmin        35 12月 20 15:22 gpdata1
drwxr-xr-x 4 gpadmin gpadmin        35 12月 20 15:22 gpdata2
lrwxrwxrwx 1 gpadmin gpadmin        18 12月 20 15:46 greenplum-db -> greenplum-db-6.0.0
drwxr-xr-x 9 gpadmin gpadmin       116 12月 20 15:46 greenplum-db-6.0.0
-rw-rw-r-- 1 gpadmin gpadmin  98586969 12月 20 15:58 greenplum-db-6.0.0.zip
-rwxrwxr-x 1 gpadmin gpadmin 104681175 12月 20 15:29 greenplum-db-6.1.0.zip
drwx------ 2 gpadmin gpadmin         6 12月 20 15:22 perl5
[gpadmin@cgsl51 ~]$ ls gpconfigs
all_hosts  all_segs_install  gpaddmirror_config  gpinitsystem_config

gpscp -f gpconfigs/all_hosts greenplum-db-6.1.0.zip =:

gpssh -f gpconfigs/all_hosts -e << END_OF_COMMAND
unzip -qo greenplum-db-6.1.0.zip;
cd $HOME/greenplum-db-6.1.0 && sed '1c GPHOME=$HOME/greenplum-db-6.1.0' -i greenplum_path.sh;
echo "source $HOME/greenplum-db-6.1.0/greenplum_path.sh" >> $HOME/.bashrc;
source $HOME/.bashrc;
END_OF_COMMAND

gpupgrade initialize --old-bindir $HOME/greenplum-db-6.0.0/bin/ --new-bindir $HOME/greenplum-db-6.1.0/bin/ --old-port 7777

gpupgrade execute -v

gpupgrade finalize