升级简介
greenplum 升级分两种：
大版本升级：跨越主版本的升级，比如 4.3 or 5 to 6，6升级到7
小版本升级：主版本内的升级，比如6.x to 6.newer
大版本升级
Greenplum 从5.28版本开始可以直接使用
gpupgrade
工具升级到6.9及以后的版本，工具开源：https://github.com/greenplum-db/gpupgrade。gpupgrade 是一个用于 Greenplum 数据库版本升级的工具，它提供了一种简单的方法来将 Greenplum 数据库集群从一个主要版本升级到另一个主要版本。对于GP4.3版本的数据库，如果升级到6，需要通过备份恢复的方式，可以使用gpbackup、gprestore或gpcopy 工具来实现，这种方式同样适用于GP5 to GP6
以gpcopy命令，以4.3 升级到 6 为例，升级流程如下：
对原集群做好备份，并保证备份可用，如果升级失败需要原集群继续提供服务
准备GP6集群，保证集群状态可用
确保有足够的磁盘空间可以保留备份文件，建议数据库的5倍大小
如果磁盘不够，使用gpcopy（4.3.26及以上版本 or 5.9及以上版本）命令，不建议使用–truncate-source-after参数
对于GP6不兼容的扩展模块，需要在备份之前或者在restore的时候需要排除相关的表
GP6 的系统表、系统视图及函数变化比较大，留好操作日志，便于修复
gpupgrade 的升级流程大致如下：
确认环境：在开始升级之前，需要确认源和目标 Greenplum 数据库版本的兼容性，并确保升级环境满足一些先决条件，如空间和内存等资源。
预升级检查：运行 gpupgrade 工具的
pre-upgrade
子命令，它会检查是否满足升级所需的各种条件，例如必备软件版本、配置文件设置、备份等。备份源数据库：在升级之前，需要对源数据库进行完整备份，以便在升级过程中发生意外情况时进行还原。
执行升级：运行 gpupgrade 工具的
upgrade
子命令，它会执行升级过程，包括关闭源数据库、备份源数据库、替换二进制文件、启动目标数据库等。后升级检查：在升级完成后，运行 gpupgrade 工具的
post-upgrade
子命令，它会检查目标数据库是否成功启动，升级是否完成，并验证新版本的 Greenplum 数据库是否工作正常。完成升级：在确认升级成功后，删除源数据库备份，清理 gpupgrade 工具的工作目录以及其他不必要的文件。
需要注意的是，gpupgrade 可以进行滚动升级，即升级过程不需要在整个集群中同时执行，而是逐个段进行升级。此外，如果在升级过程中出现任何问题，请参阅 gpupgrade 文档中提供的解决方案，或者向 Greenplum 社区寻求支持。
小版本升级
小版本升级步骤很简单，如下：
1、各个主机下载最新版本的安装包
2、master执行gpcheckcat -A
检查所有库
3、master停库gpstop -a -M fast
4、直接安装新版本软件包：rpm -U open-source-greenplum-db-XXXXXX-rhel7-x86_64.rpm --nodeps
5、启库gpstart -a
6、检查：gpstate -i
小版本6.13.0 升级到 6.23.1升级示例
快速部署6.13.0版本
1wget https://ghproxy.com/https://github.com/greenplum-db/gpdb/releases/download/6.13.0/greenplum-db-6.13.0-rhel7-x86_64.rpm
2
3-- 网卡
4docker network create --subnet=172.72.0.0/16 lhrnw
5
6
7docker rm -f lhrgp40
8docker run -d --name lhrgp40 -h lhrgp40 \
9 --net=lhrnw --ip 172.72.6.40 \
10 -p 64340:5432 \
11 -v /sys/fs/cgroup:/sys/fs/cgroup \
12 --privileged=true lhrbest/lhrcentos76:9.0 \
13 /usr/sbin/init
14
15
16docker rm -f lhrgp41
17docker run -d --name lhrgp41 -h lhrgp41 \
18 --net=lhrnw --ip 172.72.6.41 \
19 -p 64341:5432 \
20 -v /sys/fs/cgroup:/sys/fs/cgroup \
21 --privileged=true lhrbest/lhrcentos76:9.0 \
22 /usr/sbin/init
23
24
25docker rm -f lhrgp42
26docker run -d --name lhrgp42 -h lhrgp42 \
27 --net=lhrnw --ip 172.72.6.42 \
28 -p 64342:5432 \
29 -v /sys/fs/cgroup:/sys/fs/cgroup \
30 --privileged=true lhrbest/lhrcentos76:9.0 \
31 /usr/sbin/init
32
33
34docker cp ./greenplum-db-6.13.0-rhel7-x86_64.rpm lhrgp40:/soft/
35docker cp ./greenplum-db-6.13.0-rhel7-x86_64.rpm lhrgp41:/soft/
36docker cp ./greenplum-db-6.13.0-rhel7-x86_64.rpm lhrgp42:/soft/
37
38
39
40groupadd -g 530 gpadmin
41useradd -g 530 -u 530 -m -d /home/gpadmin -s /bin/bash gpadmin
42chown -R gpadmin:gpadmin /home/gpadmin
43echo "gpadmin:lhr" | chpasswd
44
45
46groupadd -g 530 gpadmin
47useradd -g 530 -u 530 -m -d /home/gpadmin -s /bin/bash gpadmin
48chown -R gpadmin:gpadmin /home/gpadmin
49echo "gpadmin:lhr" | chpasswd
50
51
52
53su - gpadmin
54
55mkdir -p /home/gpadmin/conf/
56cat > /home/gpadmin/conf/all_hosts <<"EOF"
57
58lhrgp40
59lhrgp41
60lhrgp42
61
62EOF
63
64cat > /home/gpadmin/conf/seg_hosts <<"EOF"
65
66lhrgp41
67lhrgp42
68
69EOF
70
71
72./sshUserSetup.sh -user gpadmin -hosts "lhrgp40 lhrgp41 lhrgp42" -advanced exverify –confirm
73chmod 600 /home/gpadmin/.ssh/config
74
75rpm -ivh open-source-greenplum-db-6.19.3-rhel7-x86_64.rpm
76
77chown -R gpadmin:gpadmin /usr/local/greenplum-db
78mkdir -p /opt/greenplum/data/
79chown -R gpadmin:gpadmin /opt/greenplum
80
81
82
83echo ". /usr/local/greenplum-db/greenplum_path.sh" >> /home/gpadmin/.bashrc
84
85echo "export MASTER_DATA_DIRECTORY=/opt/greenplum/data/master/gpseg-1" >> /home/gpadmin/.bashrc
86
87
88
89su - gpadmin
90mkdir -p /opt/greenplum/data/master
91mkdir -p /opt/greenplum/data/primary
92mkdir -p /opt/greenplum/data/mirror
93
94
95cat > /home/gpadmin/conf/initgp_config <<"EOF"
96declare -a DATA_DIRECTORY=(/opt/greenplum/data/primary)
97declare -a MIRROR_DATA_DIRECTORY=(/opt/greenplum/data/mirror)
98ARRAY_NAME="lhrgp"
99SEG_PREFIX=gpseg
100PORT_BASE=6000
101MASTER_PORT=5432
102MASTER_HOSTNAME=lhrgp40
103MASTER_DIRECTORY=/opt/greenplum/data/master
104DATABASE_NAME=lhrgpdb
105MACHINE_LIST_FILE=/home/gpadmin/conf/seg_hosts
106EOF
107
108su - gpadmin
109gpinitsystem -c /home/gpadmin/conf/initgp_config -h /home/gpadmin/conf/seg_hosts
110
111echo "host all all all md5" >> /opt/greenplum/data/master/gpseg-1/pg_hba.conf
112
113gpstop -u
114
115
116
117
118docker cp ./open-source-greenplum-db-6.23.1-rhel7-x86_64.rpm lhrgp40:/soft/
119docker cp ./open-source-greenplum-db-6.23.1-rhel7-x86_64.rpm lhrgp41:/soft/
120docker cp ./open-source-greenplum-db-6.23.1-rhel7-x86_64.rpm lhrgp42:/soft/
提交镜像
1docker commit lhrgp40 gpdb_mdw:6.13.0
2docker commit lhrgp41 gpdb_sdw1:6.13.0
3docker commit lhrgp42 gpdb_sdw2:6.13.0
创建新容器
1docker rm -f lhrgp40
2docker run -d --name lhrgp40 -h lhrgp40 \
3 --net=lhrnw --ip 172.72.6.40 \
4 -p 64340:5432 \
5 -v /sys/fs/cgroup:/sys/fs/cgroup \
6 --privileged=true gpdb_mdw:6.13.0 \
7 /usr/sbin/init
8
9
10docker rm -f lhrgp41
11docker run -d --name lhrgp41 -h lhrgp41 \
12 --net=lhrnw --ip 172.72.6.41 \
13 -p 64341:5432 \
14 -v /sys/fs/cgroup:/sys/fs/cgroup \
15 --privileged=true gpdb_sdw1:6.13.0 \
16 /usr/sbin/init
17
18
19docker rm -f lhrgp42
20docker run -d --name lhrgp42 -h lhrgp42 \
21 --net=lhrnw --ip 172.72.6.42 \
22 -p 64342:5432 \
23 -v /sys/fs/cgroup:/sys/fs/cgroup \
24 --privileged=true gpdb_sdw2:6.13.0 \
25 /usr/sbin/init
启动并检查
1gpstart -a
2gpcheckcat -p5432 -A
日志：
1[gpadmin@lhrgp40 ~]$ gpstart -a
220230223:13:29:16:000301 gpstart:lhrgp40:gpadmin-[INFO]:-Starting gpstart with args: -a
320230223:13:29:16:000301 gpstart:lhrgp40:gpadmin-[INFO]:-Gathering information and validating the environment...
420230223:13:29:16:000301 gpstart:lhrgp40:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 6.13.0 build commit:4f1adf8e247a9685c19ea02bcaddfdc200937ecd Open Source'
520230223:13:29:16:000301 gpstart:lhrgp40:gpadmin-[INFO]:-Greenplum Catalog Version: '301908232'
620230223:13:29:16:000301 gpstart:lhrgp40:gpadmin-[INFO]:-Starting Master instance in admin mode
720230223:13:29:17:000301 gpstart:lhrgp40:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
820230223:13:29:17:000301 gpstart:lhrgp40:gpadmin-[INFO]:-Obtaining Segment details from master...
920230223:13:29:17:000301 gpstart:lhrgp40:gpadmin-[INFO]:-Setting new master era
1020230223:13:29:17:000301 gpstart:lhrgp40:gpadmin-[INFO]:-Master Started...
1120230223:13:29:17:000301 gpstart:lhrgp40:gpadmin-[INFO]:-Shutting down master
1220230223:13:29:18:000301 gpstart:lhrgp40:gpadmin-[INFO]:-Commencing parallel segment instance startup, please wait...
13..
1420230223:13:29:21:000301 gpstart:lhrgp40:gpadmin-[INFO]:-Process results...
1520230223:13:29:21:000301 gpstart:lhrgp40:gpadmin-[INFO]:-----------------------------------------------------
1620230223:13:29:21:000301 gpstart:lhrgp40:gpadmin-[INFO]:- Successful segment starts = 2
1720230223:13:29:21:000301 gpstart:lhrgp40:gpadmin-[INFO]:- Failed segment starts = 0
1820230223:13:29:21:000301 gpstart:lhrgp40:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 0
1920230223:13:29:21:000301 gpstart:lhrgp40:gpadmin-[INFO]:-----------------------------------------------------
2020230223:13:29:21:000301 gpstart:lhrgp40:gpadmin-[INFO]:-Successfully started 2 of 2 segment instances
2120230223:13:29:21:000301 gpstart:lhrgp40:gpadmin-[INFO]:-----------------------------------------------------
2220230223:13:29:21:000301 gpstart:lhrgp40:gpadmin-[INFO]:-Starting Master instance lhrgp40 directory /opt/greenplum/data/master/gpseg-1
2320230223:13:29:21:000301 gpstart:lhrgp40:gpadmin-[INFO]:-Command pg_ctl reports Master lhrgp40 instance active
2420230223:13:29:21:000301 gpstart:lhrgp40:gpadmin-[INFO]:-Connecting to dbname='template1' connect_timeout=15
2520230223:13:29:22:000301 gpstart:lhrgp40:gpadmin-[INFO]:-No standby master configured. skipping...
2620230223:13:29:22:000301 gpstart:lhrgp40:gpadmin-[INFO]:-Database successfully started
27[gpadmin@lhrgp40 ~]$ gpcheckcat -A
28
29Usage: gpcheckcat [<option>] [dbname]
30
31 -?
32 -B parallel: number of worker threads
33 -g dir : generate SQL to rectify catalog corruption, put it in dir
34 -p port : DB port number
35 -P passwd : DB password
36 -U uname : DB User Name
37 -v : verbose
38 -A : all databases
39 -S option : shared table options (none, only)
40 -O : Online
41 -l : list all tests
42 -R test : run this particular test
43 -C catname : run cross consistency, FK and ACL tests for this catalog table
44
45
46Please specify -p port
47[gpadmin@lhrgp40 ~]$ gpcheckcat -p5432 -A
48Truncated batch size to number of primaries: 3
49
50Connected as user 'gpadmin' to database 'lhrgpdb', port '5432', gpdb version '6.13'
51-------------------------------------------------------------------
52Batch size: 3
53Performing test 'unique_index_violation'
54Total runtime for test 'unique_index_violation': 0:00:01.59
55Performing test 'duplicate'
56Total runtime for test 'duplicate': 0:00:01.73
57Performing test 'missing_extraneous'
58Total runtime for test 'missing_extraneous': 0:00:00.51
59Performing test 'inconsistent'
60Total runtime for test 'inconsistent': 0:00:01.67
61Performing test 'foreign_key'
62Total runtime for test 'foreign_key': 0:00:01.15
63Performing test 'acl'
64Total runtime for test 'acl': 0:00:00.07
65Performing test 'pgclass'
66Total runtime for test 'pgclass': 0:00:00.04
67Performing test 'namespace'
68Total runtime for test 'namespace': 0:00:00.00
69Performing test 'distribution_policy'
70Total runtime for test 'distribution_policy': 0:00:00.00
71Performing test 'dependency'
72Total runtime for test 'dependency': 0:00:00.61
73Performing test 'owner'
74Total runtime for test 'owner': 0:00:00.03
75Performing test 'part_integrity'
76Total runtime for test 'part_integrity': 0:00:00.03
77Performing test 'part_constraint'
78Total runtime for test 'part_constraint': 0:00:00.12
79Performing test 'orphaned_toast_tables'
80Total runtime for test 'orphaned_toast_tables': 0:00:00.04
81Performing test 'aoseg_table'
82Total runtime for test 'aoseg_table': 0:00:00.00
83
84SUMMARY REPORT
85===================================================================
86Completed 15 test(s) on database 'lhrgpdb' at 2023-02-23 13:29:51 with elapsed time 0:00:07
87Found no catalog issue
88
89
90Connected as user 'gpadmin' to database 'postgres', port '5432', gpdb version '6.13'
91-------------------------------------------------------------------
92Batch size: 3
93Performing test 'unique_index_violation'
94Total runtime for test 'unique_index_violation': 0:00:01.61
95Performing test 'duplicate'
96Total runtime for test 'duplicate': 0:00:01.29
97Performing test 'missing_extraneous'
98Total runtime for test 'missing_extraneous': 0:00:00.33
99Performing test 'inconsistent'
100Total runtime for test 'inconsistent': 0:00:01.36
101Performing test 'foreign_key'
102Total runtime for test 'foreign_key': 0:00:01.01
103Performing test 'acl'
104Total runtime for test 'acl': 0:00:00.05
105Performing test 'pgclass'
106Total runtime for test 'pgclass': 0:00:00.01
107Performing test 'namespace'
108Total runtime for test 'namespace': 0:00:00.00
109Performing test 'distribution_policy'
110Total runtime for test 'distribution_policy': 0:00:00.00
111Performing test 'dependency'
112Total runtime for test 'dependency': 0:00:00.48
113Performing test 'owner'
114Total runtime for test 'owner': 0:00:00.04
115Performing test 'part_integrity'
116Total runtime for test 'part_integrity': 0:00:00.04
117Performing test 'part_constraint'
118Total runtime for test 'part_constraint': 0:00:00.12
119Performing test 'orphaned_toast_tables'
120Total runtime for test 'orphaned_toast_tables': 0:00:00.04
121Performing test 'aoseg_table'
122Total runtime for test 'aoseg_table': 0:00:00.00
123
124SUMMARY REPORT
125===================================================================
126Completed 15 test(s) on database 'postgres' at 2023-02-23 13:29:57 with elapsed time 0:00:06
127Found no catalog issue
128
129
130Connected as user 'gpadmin' to database 'template1', port '5432', gpdb version '6.13'
131-------------------------------------------------------------------
132Batch size: 3
133Performing test 'unique_index_violation'
134Total runtime for test 'unique_index_violation': 0:00:01.32
135Performing test 'duplicate'
136Total runtime for test 'duplicate': 0:00:01.63
137Performing test 'missing_extraneous'
138Total runtime for test 'missing_extraneous': 0:00:00.34
139Performing test 'inconsistent'
140Total runtime for test 'inconsistent': 0:00:02.32
141Performing test 'foreign_key'
142Total runtime for test 'foreign_key': 0:00:01.28
143Performing test 'acl'
144Total runtime for test 'acl': 0:00:00.11
145Performing test 'pgclass'
146Total runtime for test 'pgclass': 0:00:00.05
147Performing test 'namespace'
148Total runtime for test 'namespace': 0:00:00.00
149Performing test 'distribution_policy'
150Total runtime for test 'distribution_policy': 0:00:00.01
151Performing test 'dependency'
152Total runtime for test 'dependency': 0:00:00.72
153Performing test 'owner'
154Total runtime for test 'owner': 0:00:00.05
155Performing test 'part_integrity'
156Total runtime for test 'part_integrity': 0:00:00.04
157Performing test 'part_constraint'
158Total runtime for test 'part_constraint': 0:00:00.14
159Performing test 'orphaned_toast_tables'
160Total runtime for test 'orphaned_toast_tables': 0:00:00.07
161Performing test 'aoseg_table'
162Total runtime for test 'aoseg_table': 0:00:00.01
163
164SUMMARY REPORT
165===================================================================
166Completed 15 test(s) on database 'template1' at 2023-02-23 13:30:05 with elapsed time 0:00:08
167Found no catalog issue
168
所有节点软件升级
1[root@lhrgp40 /]# cd /soft
2[root@lhrgp40 soft]# rpm -U open-source-greenplum-db-6.23.1-rhel7-x86_64.rpm
3error: Failed dependencies:
4 greenplum-db-6 conflicts with open-source-greenplum-db-6-6.23.1-1.el7.x86_64
5[root@lhrgp40 soft]# rpm -U open-source-greenplum-db-6.23.1-rhel7-x86_64.rpm --nodeps
6[root@lhrgp40 soft]# cd /usr/local/
7[root@lhrgp40 local]# ll
8total 0
9drwxr-xr-x 1 root root 58 May 27 2022 bin
10drwxr-xr-x 2 root root 6 Apr 11 2018 etc
11drwxr-xr-x 2 root root 6 Apr 11 2018 games
12lrwxrwxrwx 1 root root 30 Feb 23 13:31 greenplum-db -> /usr/local/greenplum-db-6.23.1
13drwxr-xr-x 11 root root 238 Feb 23 13:06 greenplum-db-6.13.0
14drwxr-xr-x 11 root root 238 Feb 23 13:31 greenplum-db-6.23.1
15drwxr-xr-x 2 root root 6 Apr 11 2018 include
16drwxr-xr-x 1 root root 25 May 27 2022 lib
17drwxr-xr-x 2 root root 6 Apr 11 2018 lib64
18drwxr-xr-x 2 root root 6 Apr 11 2018 libexec
19drwxr-xr-x 2 root root 6 Apr 11 2018 sbin
20drwxr-xr-x 1 root root 53 May 27 2022 share
21drwxr-xr-x 2 root root 6 Apr 11 2018 src
22[root@lhrgp40 local]#
启动新版本
1[gpadmin@lhrgp40 ~]$ gpstart -a
220230223:13:34:35:001099 gpstart:lhrgp40:gpadmin-[INFO]:-Starting gpstart with args: -a
320230223:13:34:35:001099 gpstart:lhrgp40:gpadmin-[INFO]:-Gathering information and validating the environment...
420230223:13:34:35:001099 gpstart:lhrgp40:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 6.23.1 build commit:2731a45ecb364317207c560730cf9e2cbf17d7e4 Open Source'
520230223:13:34:35:001099 gpstart:lhrgp40:gpadmin-[INFO]:-Greenplum Catalog Version: '301908232'
620230223:13:34:36:001099 gpstart:lhrgp40:gpadmin-[INFO]:-Starting Master instance in admin mode
720230223:13:34:36:001099 gpstart:lhrgp40:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
820230223:13:34:36:001099 gpstart:lhrgp40:gpadmin-[INFO]:-Obtaining Segment details from master...
920230223:13:34:36:001099 gpstart:lhrgp40:gpadmin-[INFO]:-Setting new master era
1020230223:13:34:36:001099 gpstart:lhrgp40:gpadmin-[INFO]:-Master Started...
1120230223:13:34:36:001099 gpstart:lhrgp40:gpadmin-[INFO]:-Shutting down master
1220230223:13:34:38:001099 gpstart:lhrgp40:gpadmin-[INFO]:-Commencing parallel segment instance startup, please wait...
1320230223:13:34:39:001099 gpstart:lhrgp40:gpadmin-[INFO]:-Process results...
1420230223:13:34:39:001099 gpstart:lhrgp40:gpadmin-[INFO]:-----------------------------------------------------
1520230223:13:34:39:001099 gpstart:lhrgp40:gpadmin-[INFO]:- Successful segment starts = 2
1620230223:13:34:39:001099 gpstart:lhrgp40:gpadmin-[INFO]:- Failed segment starts = 0
1720230223:13:34:39:001099 gpstart:lhrgp40:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 0
1820230223:13:34:39:001099 gpstart:lhrgp40:gpadmin-[INFO]:-----------------------------------------------------
1920230223:13:34:39:001099 gpstart:lhrgp40:gpadmin-[INFO]:-Successfully started 2 of 2 segment instances
2020230223:13:34:39:001099 gpstart:lhrgp40:gpadmin-[INFO]:-----------------------------------------------------
2120230223:13:34:39:001099 gpstart:lhrgp40:gpadmin-[INFO]:-Starting Master instance lhrgp40 directory /opt/greenplum/data/master/gpseg-1
2220230223:13:34:40:001099 gpstart:lhrgp40:gpadmin-[INFO]:-Command pg_ctl reports Master lhrgp40 instance active
2320230223:13:34:40:001099 gpstart:lhrgp40:gpadmin-[INFO]:-Connecting to dbname='template1' connect_timeout=15
2420230223:13:34:40:001099 gpstart:lhrgp40:gpadmin-[INFO]:-No standby master configured. skipping...
2520230223:13:34:40:001099 gpstart:lhrgp40:gpadmin-[INFO]:-Database successfully started
26[gpadmin@lhrgp40 ~]$ gpstate -i
2720230223:13:34:46:001170 gpstate:lhrgp40:gpadmin-[INFO]:-Starting gpstate with args: -i
2820230223:13:34:46:001170 gpstate:lhrgp40:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 6.23.1 build commit:2731a45ecb364317207c560730cf9e2cbf17d7e4 Open Source'
2920230223:13:34:46:001170 gpstate:lhrgp40:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 9.4.26 (Greenplum Database 6.23.1 build commit:2731a45ecb364317207c560730cf9e2cbf17d7e4 Open Source) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Feb 7 2023 22:54:40'
3020230223:13:34:46:001170 gpstate:lhrgp40:gpadmin-[INFO]:-Obtaining Segment details from master...
3120230223:13:34:46:001170 gpstate:lhrgp40:gpadmin-[INFO]:-Loading version information
3220230223:13:34:46:001170 gpstate:lhrgp40:gpadmin-[INFO]:- Host Datadir Port Version
3320230223:13:34:46:001170 gpstate:lhrgp40:gpadmin-[INFO]:- lhrgp40 /opt/greenplum/data/master/gpseg-1 5432 PostgreSQL 9.4.26 (Greenplum Database 6.23.1 build commit:2731a45ecb364317207c560730cf9e2cbf17d7e4 Open Source) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Feb 7 2023 22:54:40
3420230223:13:34:46:001170 gpstate:lhrgp40:gpadmin-[INFO]:- lhrgp41 /opt/greenplum/data/primary/gpseg0 6000 PostgreSQL 9.4.26 (Greenplum Database 6.23.1 build commit:2731a45ecb364317207c560730cf9e2cbf17d7e4 Open Source) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Feb 7 2023 22:54:40
3520230223:13:34:46:001170 gpstate:lhrgp40:gpadmin-[INFO]:- lhrgp42 /opt/greenplum/data/primary/gpseg1 6000 PostgreSQL 9.4.26 (Greenplum Database 6.23.1 build commit:2731a45ecb364317207c560730cf9e2cbf17d7e4 Open Source) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Feb 7 2023 22:54:40
3620230223:13:34:46:001170 gpstate:lhrgp40:gpadmin-[INFO]:-All segments are running the same software version
37[gpadmin@lhrgp40 ~]$
38[gpadmin@lhrgp40 ~]$ psql
39psql (9.4.26)
40Type "help" for help.
41
42postgres=# select version();
43 version
44-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
45 PostgreSQL 9.4.26 (Greenplum Database 6.23.1 build commit:2731a45ecb364317207c560730cf9e2cbf17d7e4 Open Source) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Feb 7 2023 22:54:40
46(1 row)
47
48postgres=#
49
到这里，我们的GP6的小版本已经升级完成了。
参考
https://docs.vmware.com/en/VMware-Tanzu-Greenplum/6/greenplum-database/GUID-install_guide-upgrade_intro.html
https://docs.vmware.com/en/VMware-Tanzu-Greenplum-Upgrade/index.html
https://docs.vmware.com/en/VMware-Tanzu-Greenplum-Upgrade/1.5/greenplum-upgrade/GUID-index.html
https://www.modb.pro/db/488857
文章转载自DB宝，如果涉嫌侵权，请发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
