1. 停 GPDB&GPCC
2. 备份 DB
2.1 gpmaster backup db
cd /usr/local
tar -zcvf greenplum-db-6.11.2.tar.gz greenplum-db-6.11.2
3. 备份 GPCC
3.1 master baclup gpcc
cd /usr/local
tar -zcvf greenplum-cc-6.3.1.tar.gz greenplum-cc-6.3.1
3.2 存档
mkdir bak
mv *.tar.gz bak/
rpm -qa | grep greenplum
4 全局备份
4.1 全局备份 GPCC
gpssh -f /home/gpadmin/allhost -e 'tar -zcvf /usr/local/greenplum-cc-6.3.1.tar.gz /usr/local/greenplum-cc-6.3.1';
4.2 全局备份 GPDB
gpssh -f /home/gpadmin/allhost -e 'tar -zcvf /usr/local/greenplum-db-6.11.2.tar.gz /usr/local/greenplum-db-6.11.2';
4.3 查看备份结果
4.3.1
gpssh -f /home/gpadmin/allhost -e 'ls /usr/local | grep greenplum | grep tar.gz';
5. 安装升级包
su - root
yum upgrade greenplum-db-6.17.7-rhel7-x86_64.rpm
6. 更改权限
chown -R gpadmin:gpadmin /usr/local/greenplum-*
rm pg_isready
ln -s /usr/local/greenplum-db-6.17.7/bin/pg_isready pg_isready
rm psql
ln -s /usr/local/greenplum-db-6.17.7/bin/psql psql
7. 集群升级
su - root
source /usr/local/greenplum-db/greenplum_path.sh
gpscp -f /home/gpadmin/hostnomdw /home/gpadmin/gpupdate_software/greenplum-db-6.17.7-rhel7-x86_64.rpm =:
( 上面的命令是拷贝升级包，到 hostnomdw 里的 host 下得根目录 /root 中去 )
然后到每台host下，执行升级包。
[root@gz2rptdbs08 ~]# yum upgrade greenplum-db-6.17.7-rhel7-x86_64.rpm
8. 安装 gpcc
master:
unzip /home/gpadmin/gpupdate_software/greenplum-cc-web-6.7.1-gp6-rhel7-x86_64.zip
[gpadmin@gz1rptdbmst greenplum-cc-6.7.1]$ ./gpccinstall-6.7.1 -u
此处会报错如下：
进行赋权限
再执行
每台segment和standby创建目录
|
[gpadmin@XXXXdbmst greenplum-cc-6.7.1]$ ./gpccinstall-6.7.1 -u GPCC will install with existing configuration settings:
appname = gpccws listentcp4 = true runmode = prod session = true enablexsrf = true xsrfexpire = 2592000 xsrfkey = 61oETzKXQAGaYdkL5gEmGeJJFuYh7EQnp2XdTP1o rendertype = json printallsqls = false master_port = 5432 path = /usr/local display_name = gpcc enable_kerberos = false EnableHTTPS = false EnableHTTP = true httpport = 28080 rpc_port = 8899 language = Chinese log_level = INFO ws_perf_port = 6162 agent_perf_port = 6163 master_host = gz1rptdbmst enable_history = true
Would you like to continue? Yy/Nn (Default=Y) y
INSTALLATION IN PROGRESS...
******************************************************************************** * * * INSTALLATION IS ALMOST COMPLETED * * * * The last step is to update the metrics_collector extension, which needs to * * restart the Greenplum Database cluster. Please proceed to $GPCC_HOME and * * follow the instructions in this file: * * * * update-extension.txt * * * * Some new features may not be available before the update is done. * * * * To use GPCC with the old metrics_collector extension, source gpcc_path.sh * * and run 'gpcc start'. * * * ********************************************************************************
|
