前往小程序，Get更优阅读体验！
立即前往
文档建议反馈控制台
首页
学习
活动
专区
工具
TVP
最新优惠活动
文章/答案/技术大牛
发布
首页
学习
活动
专区
工具
TVP最新优惠活动
返回腾讯云官网
社区首页 >专栏 >GreenPlum 6.23.0 安装部署高配版（启用standby master和segment mirror）

GreenPlum 6.23.0 安装部署高配版（启用standby master和segment mirror）

作者头像
AiDBA宝典
发布于 2023-04-27 13:27:18
2.3K0
发布于 2023-04-27 13:27:18
举报
文章被收录于专栏：小麦苗的DB宝专栏

下载

可以从 Greenplum 的 GitHub 页面（https://github.com/greenplum-db/gpdb/releases）下载RPM 包，或注册并登录到 Pivotal 公司官网（https://network.pivotal.io/products/vmware-tanzu-greenplum）进行下载。

安装包大约66MB，如下：

代码语言：javascript
复制
wget https://github.com/greenplum-db/gpdb/releases/download/6.23.0/open-source-greenplum-db-6.23.0-rhel7-x86_64.rpm

环境申请

本文以1个master+1个standby master，4个segment的集群示例，OS均为CentOS 7.6.1810，采用docker初始化环境。

每个segment主机上有4个Primary Segment Instance 和 4个Mirror Segment Instance共8个实例。

所以，该集群共有16个Primary实例和16个Mirror实例，再加1个master实例和1个standby master实例共34个数据库实例。

master对外服务的端口号为5432，其它segment的端口号为primary从6000-6003，对应的mirror为7000-7003

IP

主机名

端口

备注

172.72.6.50

mdw1

5432

Master host

172.72.6.51

mdw2

5432

Standby host

172.72.6.52

sdw1

主：6000-6003镜像：7000-7003

segment host1，配置4个主实例+4个镜像实例

172.72.6.53

sdw2

主：6000-6003镜像：7000-7003

segment host2，配置4个主实例+4个镜像实例

172.72.6.54

sdw3

主：6000-6003镜像：7000-7003

segment host3，配置4个主实例+4个镜像实例

172.72.6.55

sdw4

主：6000-6003镜像：7000-7003

segment host4，配置4个主实例+4个镜像实例

代码语言：javascript
复制
-- 网卡
docker network create --subnet=172.72.0.0/16 lhrnw


docker rm -f mdw1
docker run -itd --name mdw1 -h mdw1 \
  --net=lhrnw --ip 172.72.6.50 \
  -p 64350:5432 \
  -v /sys/fs/cgroup:/sys/fs/cgroup \
  --privileged=true \
  --add-host='mdw1:172.72.6.50' \
  --add-host='mdw2:172.72.6.51' \
  --add-host='sdw1:172.72.6.52' \
  --add-host='sdw2:172.72.6.53' \
  --add-host='sdw3:172.72.6.54' \
  --add-host='sdw4:172.72.6.55' \
  lhrbest/lhrcentos76:9.0 \
  /usr/sbin/init


docker rm -f mdw2
docker run -itd --name mdw2 -h mdw2 \
  --net=lhrnw --ip 172.72.6.51 \
  -p 64351:5432 \
  -v /sys/fs/cgroup:/sys/fs/cgroup \
  --privileged=true \
  --add-host='mdw1:172.72.6.50' \
  --add-host='mdw2:172.72.6.51' \
  --add-host='sdw1:172.72.6.52' \
  --add-host='sdw2:172.72.6.53' \
  --add-host='sdw3:172.72.6.54' \
  --add-host='sdw4:172.72.6.55' \
  lhrbest/lhrcentos76:9.0 \
  /usr/sbin/init


docker rm -f sdw1
docker run -itd --name sdw1 -h sdw1 \
  --net=lhrnw --ip 172.72.6.52 \
  -v /sys/fs/cgroup:/sys/fs/cgroup \
  --privileged=true \
  --add-host='mdw1:172.72.6.50' \
  --add-host='mdw2:172.72.6.51' \
  --add-host='sdw1:172.72.6.52' \
  --add-host='sdw2:172.72.6.53' \
  --add-host='sdw3:172.72.6.54' \
  --add-host='sdw4:172.72.6.55' \
  lhrbest/lhrcentos76:9.0 \
  /usr/sbin/init


docker rm -f sdw2
docker run -itd --name sdw2 -h sdw2 \
  --net=lhrnw --ip 172.72.6.53 \
  -v /sys/fs/cgroup:/sys/fs/cgroup \
  --privileged=true \
  --add-host='mdw1:172.72.6.50' \
  --add-host='mdw2:172.72.6.51' \
  --add-host='sdw1:172.72.6.52' \
  --add-host='sdw2:172.72.6.53' \
  --add-host='sdw3:172.72.6.54' \
  --add-host='sdw4:172.72.6.55' \
  lhrbest/lhrcentos76:9.0 \
  /usr/sbin/init


docker rm -f sdw3
docker run -itd --name sdw3 -h sdw3 \
  --net=lhrnw --ip 172.72.6.54 \
  -v /sys/fs/cgroup:/sys/fs/cgroup \
  --privileged=true \
  --add-host='mdw1:172.72.6.50' \
  --add-host='mdw2:172.72.6.51' \
  --add-host='sdw1:172.72.6.52' \
  --add-host='sdw2:172.72.6.53' \
  --add-host='sdw3:172.72.6.54' \
  --add-host='sdw4:172.72.6.55' \
  lhrbest/lhrcentos76:9.0 \
  /usr/sbin/init


docker rm -f sdw4
docker run -itd --name sdw4 -h sdw4 \
  --net=lhrnw --ip 172.72.6.55 \
  -v /sys/fs/cgroup:/sys/fs/cgroup \
  --privileged=true \
  --add-host='mdw1:172.72.6.50' \
  --add-host='mdw2:172.72.6.51' \
  --add-host='sdw1:172.72.6.52' \
  --add-host='sdw2:172.72.6.53' \
  --add-host='sdw3:172.72.6.54' \
  --add-host='sdw4:172.72.6.55' \
  lhrbest/lhrcentos76:9.0 \
  /usr/sbin/init



docker cp /soft/open-source-greenplum-db-6.23.0-rhel7-x86_64.rpm mdw1:/soft/
docker cp /soft/open-source-greenplum-db-6.23.0-rhel7-x86_64.rpm mdw2:/soft/
docker cp /soft/open-source-greenplum-db-6.23.0-rhel7-x86_64.rpm sdw1:/soft/
docker cp /soft/open-source-greenplum-db-6.23.0-rhel7-x86_64.rpm sdw2:/soft/
docker cp /soft/open-source-greenplum-db-6.23.0-rhel7-x86_64.rpm sdw3:/soft/
docker cp /soft/open-source-greenplum-db-6.23.0-rhel7-x86_64.rpm sdw4:/soft/

docker环境：

代码语言：javascript
复制
[root@lhrxxt ~]# docker ps
CONTAINER ID   IMAGE                     COMMAND            CREATED          STATUS          PORTS                                                           NAMES
0480b0933003   lhrbest/lhrcentos76:9.0   "/usr/sbin/init"   3 seconds ago    Up 2 seconds    22/tcp, 3389/tcp                                                sdw4
565d75621bae   lhrbest/lhrcentos76:9.0   "/usr/sbin/init"   5 seconds ago    Up 4 seconds    22/tcp, 3389/tcp                                                sdw3
5a3fcdb956ab   lhrbest/lhrcentos76:9.0   "/usr/sbin/init"   5 seconds ago    Up 4 seconds    22/tcp, 3389/tcp                                                sdw2
a514d478aa22   lhrbest/lhrcentos76:9.0   "/usr/sbin/init"   6 seconds ago    Up 5 seconds    22/tcp, 3389/tcp                                                sdw1
19b1d6b0ef9b   lhrbest/lhrcentos76:9.0   "/usr/sbin/init"   14 seconds ago   Up 13 seconds   22/tcp, 3389/tcp, 0.0.0.0:64351->5432/tcp, :::64351->5432/tcp   mdw2
6692b298d8cd   lhrbest/lhrcentos76:9.0   "/usr/sbin/init"   15 seconds ago   Up 14 seconds   22/tcp, 3389/tcp, 0.0.0.0:64350->5432/tcp, :::64350->5432/tcp   mdw1

修改/etc/hosts文件

在Greenplum中，习惯将Master机器叫做mdw，将Segment机器叫做sdw。dw的含义为Data Warehouse。

代码语言：javascript
复制
cat >> /etc/hosts <<"EOF"
172.72.6.50  mdw1
172.72.6.51  mdw2
172.72.6.52  sdw1
172.72.6.53  sdw2
172.72.6.54  sdw3
172.72.6.55  sdw4
EOF

mdw和sdw只是一个主机的别名，不影响程序去查找IP。

docker环境每次重启容器都会重置/etc/hosts文件的内容，但是这不会影响GreenPlum的正常运行。 也可以在创建容器的时候添加参数"--add-host='mdw1:172.72.6.50'"来规避这个问题。

创建用户和集群配置文件（所有节点）

为所有节点创建gpadmin用户：

代码语言：javascript
复制
groupadd -g 530 gpadmin
useradd -g 530 -u 530 -m -d /home/gpadmin -s /bin/bash gpadmin
chown -R gpadmin:gpadmin /home/gpadmin
echo "gpadmin:lhr" | chpasswd

为所有节点创建一个all_hosts文件，包含所有节点主机名：

代码语言：javascript
复制
su - gpadmin

mkdir -p /home/gpadmin/conf/

cat > /home/gpadmin/conf/all_hosts <<"EOF"

mdw1
mdw2
sdw1
sdw2
sdw3
sdw4

EOF

为所有节点创建一个 seg_hosts文件 ，包含所有的Segment Host的主机名：

代码语言：javascript
复制
cat > /home/gpadmin/conf/seg_hosts <<"EOF"

sdw1
sdw2
sdw3
sdw4

EOF

配置互信

只在master节点（172.72.6.50）操作：

代码语言：javascript
复制
./sshUserSetup.sh -user root  -hosts "mdw1 mdw2 sdw1 sdw2 sdw3 sdw4" -advanced exverify –confirm
./sshUserSetup.sh -user gpadmin  -hosts "mdw1 mdw2 sdw1 sdw2 sdw3 sdw4" -advanced exverify –confirm
chmod 600 /home/gpadmin/.ssh/config

1、为了后续的维护方便，建议root和gpadmin用户都做互信的配置。 2、必须给600权限，否则会报错“.Bad owner or permissions on /home/gpadmin/.ssh/config”

安装GP软件（所有节点）

在所有节点以root用户操作：

代码语言：javascript
复制
yum install -y apr apr-util bash bzip2 curl krb5 libcurl libevent libxml2 libyaml zlib openldap openssh openssl openssl-libs perl readline rsync R sed tar zip krb5-devel

rpm -ivh /soft/open-source-greenplum-db-6.23.0-rhel7-x86_64.rpm

默认的安装路径是/usr/local，修改该路径gpadmin操作权限：

代码语言：javascript
复制
chown -R gpadmin:gpadmin /usr/local/greenplum-db
chown -R gpadmin:gpadmin /usr/local/greenplum-db-6.23.0

创建目录，用作集群数据的存储目录：

代码语言：javascript
复制
mkdir -p /opt/greenplum/data/
chown -R gpadmin:gpadmin /opt/greenplum

配置环境变量

代码语言：javascript
复制
-- 所有节点
echo ". /usr/local/greenplum-db/greenplum_path.sh" >> /home/gpadmin/.bashrc


-- master配置
echo "export MASTER_DATA_DIRECTORY=/opt/greenplum/data/master/gpseg-1" >> /home/gpadmin/.bashrc
echo "export PGDATABASE=postgres" >> /home/gpadmin/.bashrc

数据库初始化（重要）

该步为最核心最重要的命令过程！！！

Greenplum 配置文件模板都在/usr/local/greenplum-db/docs/cli_help/gpconfigs目录下，其中gpinitsystem_config是初始化 Greenplum 的模板。

在master节点操作：

代码语言：javascript
复制
[gpadmin@mdw1 ~]$ cd /usr/local/greenplum-db/docs/cli_help/gpconfigs
[gpadmin@mdw1 gpconfigs]$ ll
total 52
-rw-r--r-- 1 root root 2422 Feb 26 03:09 gpinitsystem_config
-rw-r--r-- 1 root root 4511 Feb 26 03:09 gpinitsystem_singlenode
-rw-r--r-- 1 root root 2321 Feb 26 03:09 gpinitsystem_test
-rw-r--r-- 1 root root  359 Feb 26 03:09 hostfile_exkeys
-rw-r--r-- 1 root root  119 Feb 26 03:09 hostfile_gpchecknet_ic1
-rw-r--r-- 1 root root  119 Feb 26 03:09 hostfile_gpchecknet_ic2
-rw-r--r-- 1 root root   87 Feb 26 03:09 hostfile_gpcheckperf
-rw-r--r-- 1 root root  255 Feb 26 03:09 hostfile_gpexpand
-rw-r--r-- 1 root root  237 Feb 26 03:09 hostfile_gpinitsystem
-rw-r--r-- 1 root root   96 Feb 26 03:09 hostfile_gpssh_allhosts
-rw-r--r-- 1 root root   87 Feb 26 03:09 hostfile_gpssh_segonly
-rw-r--r-- 1 root root   44 Feb 26 03:09 hostlist_singlenode

在master节点操作：创建一个初始化副本 initgp_config，根据前面的架构规划配置，修改参数：

代码语言：javascript
复制
-- 在所有节点操作（在master节点创建master目录，在segment节点分布创建primary目录和mirror目录） 或 3个目录创建都可以
su - gpadmin

-- master节点
mkdir -p /opt/greenplum/data/master


-- segment节点
mkdir -p /opt/greenplum/data/primary
mkdir -p /opt/greenplum/data/mirror



-- master节点配置
cat > /home/gpadmin/conf/initgp_config <<"EOF"
declare -a DATA_DIRECTORY=(/opt/greenplum/data/primary /opt/greenplum/data/primary /opt/greenplum/data/primary /opt/greenplum/data/primary)
declare -a MIRROR_DATA_DIRECTORY=(/opt/greenplum/data/mirror /opt/greenplum/data/mirror /opt/greenplum/data/mirror /opt/greenplum/data/mirror)
ARRAY_NAME="lhrgp"
SEG_PREFIX=gpseg
PORT_BASE=6000
MIRROR_PORT_BASE=7000
MASTER_PORT=5432
MASTER_HOSTNAME=mdw1
MASTER_DIRECTORY=/opt/greenplum/data/master
DATABASE_NAME=lhrgpdb
MACHINE_LIST_FILE=/home/gpadmin/conf/seg_hosts
EOF

在master节点操作：执行初始化命令：

代码语言：javascript
复制
su - gpadmin
gpinitsystem -c /home/gpadmin/conf/initgp_config -e=lhr -s mdw2 -P 5432 -S /opt/greenplum/data/master/gpseg-1 -m 500 -b 256MB

1、选项“-e”指定superuser用户的密码，默认密码为gparray 2、选项“-s” 指定standby host主机名，-P 指定standby host端口，-S 指定standby host数据文件路径，注意要多一层 3、-m指定最大连接数，默认250 4、-b指定shared_buffers，默认128000kB 5、初始化数据库时根据脚本的提示操作即可，如果配置有问题，gpinitsystem 命令就不能运行成功，错误日志存储在 /home/gpadmin/gpAdminLogs 中，需要认真查看日志报错信息，修改正确后再重新安装。

若初始化失败，需要删除/opt/greenplum/data下的数据资源目录重新初始化。

初始化过程：

代码语言：javascript
复制
[gpadmin@mdw1 ~]$ gpinitsystem -c /home/gpadmin/conf/initgp_config -e=lhr -s mdw2 -P 5432 -S /opt/greenplum/data/master/gpseg-1 -m 500 -b 256MB
20230131:16:17:44:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Checking configuration parameters, please wait...
20230131:16:17:44:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Reading Greenplum configuration file /home/gpadmin/conf/initgp_config
20230131:16:17:44:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Locale has not been set in /home/gpadmin/conf/initgp_config, will set to default value
20230131:16:17:44:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Locale set to en_US.utf8
20230131:16:17:44:004521 gpinitsystem:mdw1:gpadmin-[WARN]:-CHECK_POINT_SEGMENTS variable not set, will set to default value
20230131:16:17:44:004521 gpinitsystem:mdw1:gpadmin-[WARN]:-ENCODING variable not set, will set to default UTF-8
20230131:16:17:44:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Checking configuration parameters, Completed
20230131:16:17:44:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Commencing multi-home checks, please wait...
....
20230131:16:17:45:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Configuring build for standard array
20230131:16:17:45:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Commencing multi-home checks, Completed
20230131:16:17:45:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Building primary segment instance array, please wait...
................
20230131:16:17:50:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Building group mirror array type , please wait...
................
20230131:16:17:55:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Checking Master host
20230131:16:17:55:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Checking new segment hosts, please wait...
................................
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Checking new segment hosts, Completed
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Greenplum Database Creation Parameters
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:---------------------------------------
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Master Configuration
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:---------------------------------------
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Master instance name       = lhrgp
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Master hostname            = mdw1
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Master port                = 5432
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Master instance dir        = /opt/greenplum/data/master/gpseg-1
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Master LOCALE              = en_US.utf8
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Greenplum segment prefix   = gpseg
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Master Database            = lhrgpdb
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Master connections         = 500
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Master buffers             = 256MB
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Segment connections        = 1500
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Segment buffers            = 256MB
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Checkpoint segments        = 8
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Encoding                   = UTF-8
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Postgres param file        = Off
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Initdb to be used          = /usr/local/greenplum-db-6.23.0/bin/initdb
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-GP_LIBRARY_PATH is         = /usr/local/greenplum-db-6.23.0/lib
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-HEAP_CHECKSUM is           = on
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-HBA_HOSTNAMES is           = 0
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Ulimit check               = Passed
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Array host connect type    = Single hostname per node
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Master IP address [1]      = 172.72.6.50
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Standby Master             = mdw2
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Number of primary segments = 4
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Standby IP address         = 172.72.6.51
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Total Database segments    = 16
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Trusted shell              = /bin/ssh
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Number segment hosts       = 4
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Mirror port base           = 7000
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Number of mirror segments  = 4
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Mirroring config           = ON
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Mirroring type             = Group
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:----------------------------------------
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Greenplum Primary Segment Configuration
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:----------------------------------------
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-sdw1         6000    sdw1    /opt/greenplum/data/primary/gpseg0      2
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-sdw1         6001    sdw1    /opt/greenplum/data/primary/gpseg1      3
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-sdw1         6002    sdw1    /opt/greenplum/data/primary/gpseg2      4
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-sdw1         6003    sdw1    /opt/greenplum/data/primary/gpseg3      5
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-sdw2         6000    sdw2    /opt/greenplum/data/primary/gpseg4      6
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-sdw2         6001    sdw2    /opt/greenplum/data/primary/gpseg5      7
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-sdw2         6002    sdw2    /opt/greenplum/data/primary/gpseg6      8
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-sdw2         6003    sdw2    /opt/greenplum/data/primary/gpseg7      9
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-sdw3         6000    sdw3    /opt/greenplum/data/primary/gpseg8      10
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-sdw3         6001    sdw3    /opt/greenplum/data/primary/gpseg9      11
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-sdw3         6002    sdw3    /opt/greenplum/data/primary/gpseg10     12
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-sdw3         6003    sdw3    /opt/greenplum/data/primary/gpseg11     13
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-sdw4         6000    sdw4    /opt/greenplum/data/primary/gpseg12     14
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-sdw4         6001    sdw4    /opt/greenplum/data/primary/gpseg13     15
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-sdw4         6002    sdw4    /opt/greenplum/data/primary/gpseg14     16
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-sdw4         6003    sdw4    /opt/greenplum/data/primary/gpseg15     17
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:---------------------------------------
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Greenplum Mirror Segment Configuration
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:---------------------------------------
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-sdw2         7000    sdw2    /opt/greenplum/data/mirror/gpseg0       18
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-sdw2         7001    sdw2    /opt/greenplum/data/mirror/gpseg1       19
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-sdw2         7002    sdw2    /opt/greenplum/data/mirror/gpseg2       20
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-sdw2         7003    sdw2    /opt/greenplum/data/mirror/gpseg3       21
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-sdw3         7000    sdw3    /opt/greenplum/data/mirror/gpseg4       22
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-sdw3         7001    sdw3    /opt/greenplum/data/mirror/gpseg5       23
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-sdw3         7002    sdw3    /opt/greenplum/data/mirror/gpseg6       24
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-sdw3         7003    sdw3    /opt/greenplum/data/mirror/gpseg7       25
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-sdw4         7000    sdw4    /opt/greenplum/data/mirror/gpseg8       26
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-sdw4         7001    sdw4    /opt/greenplum/data/mirror/gpseg9       27
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-sdw4         7002    sdw4    /opt/greenplum/data/mirror/gpseg10      28
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-sdw4         7003    sdw4    /opt/greenplum/data/mirror/gpseg11      29
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-sdw1         7000    sdw1    /opt/greenplum/data/mirror/gpseg12      30
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-sdw1         7001    sdw1    /opt/greenplum/data/mirror/gpseg13      31
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-sdw1         7002    sdw1    /opt/greenplum/data/mirror/gpseg14      32
20230131:16:18:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-sdw1         7003    sdw1    /opt/greenplum/data/mirror/gpseg15      33

Continue with Greenplum creation Yy|Nn (default=N):
> y
20230131:16:19:35:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Building the Master instance database, please wait...
20230131:16:19:42:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Starting the Master in admin mode
20230131:16:19:43:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Commencing parallel build of primary segment instances
20230131:16:19:43:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Spawning parallel processes    batch [1], please wait...
................
20230131:16:19:43:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Waiting for parallel processes batch [1], please wait...
............................
20230131:16:20:12:004521 gpinitsystem:mdw1:gpadmin-[INFO]:------------------------------------------------
20230131:16:20:12:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Parallel process exit status
20230131:16:20:12:004521 gpinitsystem:mdw1:gpadmin-[INFO]:------------------------------------------------
20230131:16:20:12:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Total processes marked as completed           = 16
20230131:16:20:12:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Total processes marked as killed              = 0
20230131:16:20:12:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Total processes marked as failed              = 0
20230131:16:20:12:004521 gpinitsystem:mdw1:gpadmin-[INFO]:------------------------------------------------
20230131:16:20:12:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Removing back out file
20230131:16:20:12:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-No errors generated from parallel processes
20230131:16:20:12:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Restarting the Greenplum instance in production mode
20230131:16:20:12:016455 gpstop:mdw1:gpadmin-[INFO]:-Starting gpstop with args: -a -l /home/gpadmin/gpAdminLogs -m -d /opt/greenplum/data/master/gpseg-1
20230131:16:20:12:016455 gpstop:mdw1:gpadmin-[INFO]:-Gathering information and validating the environment...
20230131:16:20:12:016455 gpstop:mdw1:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20230131:16:20:12:016455 gpstop:mdw1:gpadmin-[INFO]:-Obtaining Segment details from master...
20230131:16:20:12:016455 gpstop:mdw1:gpadmin-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 6.23.0 build commit:5b5e432f35f92a40c18dffe4e5bca94790aae83c Open Source'
20230131:16:20:12:016455 gpstop:mdw1:gpadmin-[INFO]:-Commencing Master instance shutdown with mode='smart'
20230131:16:20:12:016455 gpstop:mdw1:gpadmin-[INFO]:-Master segment instance directory=/opt/greenplum/data/master/gpseg-1
20230131:16:20:12:016455 gpstop:mdw1:gpadmin-[INFO]:-Stopping master segment and waiting for user connections to finish ...
server shutting down
20230131:16:20:13:016455 gpstop:mdw1:gpadmin-[INFO]:-Attempting forceful termination of any leftover master process
20230131:16:20:13:016455 gpstop:mdw1:gpadmin-[INFO]:-Terminating processes for segment /opt/greenplum/data/master/gpseg-1
20230131:16:20:13:016478 gpstart:mdw1:gpadmin-[INFO]:-Starting gpstart with args: -a -l /home/gpadmin/gpAdminLogs -d /opt/greenplum/data/master/gpseg-1
20230131:16:20:13:016478 gpstart:mdw1:gpadmin-[INFO]:-Gathering information and validating the environment...
20230131:16:20:13:016478 gpstart:mdw1:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 6.23.0 build commit:5b5e432f35f92a40c18dffe4e5bca94790aae83c Open Source'
20230131:16:20:13:016478 gpstart:mdw1:gpadmin-[INFO]:-Greenplum Catalog Version: '301908232'
20230131:16:20:13:016478 gpstart:mdw1:gpadmin-[INFO]:-Starting Master instance in admin mode
20230131:16:20:13:016478 gpstart:mdw1:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20230131:16:20:13:016478 gpstart:mdw1:gpadmin-[INFO]:-Obtaining Segment details from master...
20230131:16:20:13:016478 gpstart:mdw1:gpadmin-[INFO]:-Setting new master era
20230131:16:20:13:016478 gpstart:mdw1:gpadmin-[INFO]:-Master Started...
20230131:16:20:13:016478 gpstart:mdw1:gpadmin-[INFO]:-Shutting down master
20230131:16:20:13:016478 gpstart:mdw1:gpadmin-[INFO]:-Commencing parallel segment instance startup, please wait...
20230131:16:20:14:016478 gpstart:mdw1:gpadmin-[INFO]:-Process results...
20230131:16:20:14:016478 gpstart:mdw1:gpadmin-[INFO]:-----------------------------------------------------
20230131:16:20:14:016478 gpstart:mdw1:gpadmin-[INFO]:-   Successful segment starts                                            = 16
20230131:16:20:14:016478 gpstart:mdw1:gpadmin-[INFO]:-   Failed segment starts                                                = 0
20230131:16:20:14:016478 gpstart:mdw1:gpadmin-[INFO]:-   Skipped segment starts (segments are marked down in configuration)   = 0
20230131:16:20:14:016478 gpstart:mdw1:gpadmin-[INFO]:-----------------------------------------------------
20230131:16:20:14:016478 gpstart:mdw1:gpadmin-[INFO]:-Successfully started 16 of 16 segment instances 
20230131:16:20:14:016478 gpstart:mdw1:gpadmin-[INFO]:-----------------------------------------------------
20230131:16:20:14:016478 gpstart:mdw1:gpadmin-[INFO]:-Starting Master instance mdw1 directory /opt/greenplum/data/master/gpseg-1 
20230131:16:20:15:016478 gpstart:mdw1:gpadmin-[INFO]:-Command pg_ctl reports Master mdw1 instance active
20230131:16:20:15:016478 gpstart:mdw1:gpadmin-[INFO]:-Connecting to dbname='template1' connect_timeout=15
20230131:16:20:15:016478 gpstart:mdw1:gpadmin-[INFO]:-No standby master configured.  skipping...
20230131:16:20:15:016478 gpstart:mdw1:gpadmin-[INFO]:-Database successfully started
20230131:16:20:15:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Completed restart of Greenplum instance in production mode
20230131:16:20:21:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Commencing parallel build of mirror segment instances
20230131:16:20:21:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Spawning parallel processes    batch [1], please wait...
................
20230131:16:20:21:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Waiting for parallel processes batch [1], please wait...
.......................
20230131:16:20:45:004521 gpinitsystem:mdw1:gpadmin-[INFO]:------------------------------------------------
20230131:16:20:45:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Parallel process exit status
20230131:16:20:45:004521 gpinitsystem:mdw1:gpadmin-[INFO]:------------------------------------------------
20230131:16:20:45:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Total processes marked as completed           = 16
20230131:16:20:45:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Total processes marked as killed              = 0
20230131:16:20:45:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Total processes marked as failed              = 0
20230131:16:20:45:004521 gpinitsystem:mdw1:gpadmin-[INFO]:------------------------------------------------
20230131:16:20:45:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Starting initialization of standby master mdw2
20230131:16:20:45:020512 gpinitstandby:mdw1:gpadmin-[INFO]:-Validating environment and parameters for standby initialization...
20230131:16:20:45:020512 gpinitstandby:mdw1:gpadmin-[INFO]:-Checking for data directory /opt/greenplum/data/master/gpseg-1 on mdw2
20230131:16:20:45:020512 gpinitstandby:mdw1:gpadmin-[INFO]:------------------------------------------------------
20230131:16:20:45:020512 gpinitstandby:mdw1:gpadmin-[INFO]:-Greenplum standby master initialization parameters
20230131:16:20:45:020512 gpinitstandby:mdw1:gpadmin-[INFO]:------------------------------------------------------
20230131:16:20:45:020512 gpinitstandby:mdw1:gpadmin-[INFO]:-Greenplum master hostname               = mdw1
20230131:16:20:45:020512 gpinitstandby:mdw1:gpadmin-[INFO]:-Greenplum master data directory         = /opt/greenplum/data/master/gpseg-1
20230131:16:20:45:020512 gpinitstandby:mdw1:gpadmin-[INFO]:-Greenplum master port                   = 5432
20230131:16:20:45:020512 gpinitstandby:mdw1:gpadmin-[INFO]:-Greenplum standby master hostname       = mdw2
20230131:16:20:45:020512 gpinitstandby:mdw1:gpadmin-[INFO]:-Greenplum standby master port           = 5432
20230131:16:20:45:020512 gpinitstandby:mdw1:gpadmin-[INFO]:-Greenplum standby master data directory = /opt/greenplum/data/master/gpseg-1
20230131:16:20:45:020512 gpinitstandby:mdw1:gpadmin-[INFO]:-Greenplum update system catalog         = On
20230131:16:20:45:020512 gpinitstandby:mdw1:gpadmin-[INFO]:-Syncing Greenplum Database extensions to standby
20230131:16:20:45:020512 gpinitstandby:mdw1:gpadmin-[INFO]:-The packages on mdw2 are consistent.
20230131:16:20:45:020512 gpinitstandby:mdw1:gpadmin-[INFO]:-Adding standby master to catalog...
20230131:16:20:45:020512 gpinitstandby:mdw1:gpadmin-[INFO]:-Database catalog updated successfully.
20230131:16:20:45:020512 gpinitstandby:mdw1:gpadmin-[INFO]:-Updating pg_hba.conf file...
20230131:16:20:46:020512 gpinitstandby:mdw1:gpadmin-[INFO]:-pg_hba.conf files updated successfully.
20230131:16:20:52:020512 gpinitstandby:mdw1:gpadmin-[INFO]:-Starting standby master
20230131:16:20:52:020512 gpinitstandby:mdw1:gpadmin-[INFO]:-Checking if standby master is running on host: mdw2  in directory: /opt/greenplum/data/master/gpseg-1
20230131:16:20:53:020512 gpinitstandby:mdw1:gpadmin-[INFO]:-Cleaning up pg_hba.conf backup files...
20230131:16:20:53:020512 gpinitstandby:mdw1:gpadmin-[INFO]:-Backup files of pg_hba.conf cleaned up successfully.
20230131:16:20:53:020512 gpinitstandby:mdw1:gpadmin-[INFO]:-Successfully created standby master on mdw2
20230131:16:20:53:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Successfully completed standby master initialization
20230131:16:20:53:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Scanning utility log file for any warning messages
20230131:16:20:53:004521 gpinitsystem:mdw1:gpadmin-[WARN]:-*******************************************************
20230131:16:20:53:004521 gpinitsystem:mdw1:gpadmin-[WARN]:-Scan of log file indicates that some warnings or errors
20230131:16:20:53:004521 gpinitsystem:mdw1:gpadmin-[WARN]:-were generated during the array creation
20230131:16:20:53:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Please review contents of log file
20230131:16:20:53:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-/home/gpadmin/gpAdminLogs/gpinitsystem_20230131.log
20230131:16:20:53:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-To determine level of criticality
20230131:16:20:53:004521 gpinitsystem:mdw1:gpadmin-[WARN]:-*******************************************************
20230131:16:20:53:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Greenplum Database instance successfully created
20230131:16:20:53:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-------------------------------------------------------
20230131:16:20:53:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-To complete the environment configuration, please 
20230131:16:20:53:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-update gpadmin .bashrc file with the following
20230131:16:20:53:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-1. Ensure that the greenplum_path.sh file is sourced
20230131:16:20:53:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-2. Add "export MASTER_DATA_DIRECTORY=/opt/greenplum/data/master/gpseg-1"
20230131:16:20:53:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-   to access the Greenplum scripts for this instance:
20230131:16:20:53:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-   or, use -d /opt/greenplum/data/master/gpseg-1 option for the Greenplum scripts
20230131:16:20:53:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-   Example gpstate -d /opt/greenplum/data/master/gpseg-1
20230131:16:20:53:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Script log file = /home/gpadmin/gpAdminLogs/gpinitsystem_20230131.log
20230131:16:20:53:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-To remove instance, run gpdeletesystem utility
20230131:16:20:53:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Standby Master mdw2 has been configured
20230131:16:20:53:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-To activate the Standby Master Segment in the event of Master
20230131:16:20:53:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-failure review options for gpactivatestandby
20230131:16:20:53:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-------------------------------------------------------
20230131:16:20:53:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-The Master /opt/greenplum/data/master/gpseg-1/pg_hba.conf post gpinitsystem
20230131:16:20:53:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-has been configured to allow all hosts within this new
20230131:16:20:53:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-array to intercommunicate. Any hosts external to this
20230131:16:20:53:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-new array must be explicitly added to this file
20230131:16:20:53:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-Refer to the Greenplum Admin support guide which is
20230131:16:20:53:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-located in the /usr/local/greenplum-db-6.23.0/docs directory
20230131:16:20:53:004521 gpinitsystem:mdw1:gpadmin-[INFO]:-------------------------------------------------------

GP验证

若初始化成功，则GP自动启动，可以看到master节点上的5432已经在listen了，psql进入数据库，开始greenplum之旅。

代码语言：javascript
复制
[gpadmin@mdw1 ~]$ netstat -tulnp | grep 5432
tcp        0      0 0.0.0.0:5432            0.0.0.0:*               LISTEN      8362/postgres       
tcp6       0      0 :::5432                 :::*                    LISTEN      8362/postgres 

[gpadmin@mdw1 ~]$ psql postgres -c 'SELECT * FROM pg_stat_replication;'              
  pid  | usesysid | usename | application_name | client_addr | client_hostname | client_port |         backend_start         | backend_xmin |   state   | sent_location | write_location | flush_location | replay_location | sync_priority | sync_state 
-------+----------+---------+------------------+-------------+-----------------+-------------+-------------------------------+--------------+-----------+---------------+----------------+----------------+-----------------+---------------+------------
 23284 |       10 | gpadmin | gp_walreceiver   | 172.72.6.51 |                 |       45866 | 2023-01-31 16:49:33.064484+08 |              | streaming | 0/240000A8    | 0/240000A8     | 0/240000A8     | 0/240000A8      |             1 | sync
(1 row)

[gpadmin@mdw1 ~]$ 
[gpadmin@mdw1 ~]$ psql -d lhrgpdb
psql (9.4.26)
Type "help" for help.

lhrgpdb=# \l
                               List of databases
   Name    |  Owner  | Encoding |  Collate   |   Ctype    |  Access privileges  
-----------+---------+----------+------------+------------+---------------------
 lhrgpdb   | gpadmin | UTF8     | en_US.utf8 | en_US.utf8 | 
 postgres  | gpadmin | UTF8     | en_US.utf8 | en_US.utf8 | 
 template0 | gpadmin | UTF8     | en_US.utf8 | en_US.utf8 | =c/gpadmin         +
           |         |          |            |            | gpadmin=CTc/gpadmin
 template1 | gpadmin | UTF8     | en_US.utf8 | en_US.utf8 | =c/gpadmin         +
           |         |          |            |            | gpadmin=CTc/gpadmin
(4 rows)

lhrgpdb=# show port;
 port 
------
 5432
(1 row)

lhrgpdb=# show listen_addresses;
 listen_addresses
------------------
 *
(1 row)

lhrgpdb=# select * from gp_segment_configuration order by 1;
 dbid | content | role | preferred_role | mode | status | port | hostname | address |               datadir               
------+---------+------+----------------+------+--------+------+----------+---------+-------------------------------------
    1 |      -1 | p    | p              | n    | u      | 5432 | mdw1     | mdw1    | /opt/greenplum/data/master/gpseg-1
    2 |       0 | p    | p              | s    | u      | 6000 | sdw1     | sdw1    | /opt/greenplum/data/primary/gpseg0
    3 |       1 | p    | p              | s    | u      | 6001 | sdw1     | sdw1    | /opt/greenplum/data/primary/gpseg1
    4 |       2 | p    | p              | s    | u      | 6002 | sdw1     | sdw1    | /opt/greenplum/data/primary/gpseg2
    5 |       3 | p    | p              | s    | u      | 6003 | sdw1     | sdw1    | /opt/greenplum/data/primary/gpseg3
    6 |       4 | p    | p              | s    | u      | 6000 | sdw2     | sdw2    | /opt/greenplum/data/primary/gpseg4
    7 |       5 | p    | p              | s    | u      | 6001 | sdw2     | sdw2    | /opt/greenplum/data/primary/gpseg5
    8 |       6 | p    | p              | s    | u      | 6002 | sdw2     | sdw2    | /opt/greenplum/data/primary/gpseg6
    9 |       7 | p    | p              | s    | u      | 6003 | sdw2     | sdw2    | /opt/greenplum/data/primary/gpseg7
   10 |       8 | p    | p              | s    | u      | 6000 | sdw3     | sdw3    | /opt/greenplum/data/primary/gpseg8
   11 |       9 | p    | p              | s    | u      | 6001 | sdw3     | sdw3    | /opt/greenplum/data/primary/gpseg9
   12 |      10 | p    | p              | s    | u      | 6002 | sdw3     | sdw3    | /opt/greenplum/data/primary/gpseg10
   13 |      11 | p    | p              | s    | u      | 6003 | sdw3     | sdw3    | /opt/greenplum/data/primary/gpseg11
   14 |      12 | p    | p              | s    | u      | 6000 | sdw4     | sdw4    | /opt/greenplum/data/primary/gpseg12
   15 |      13 | p    | p              | s    | u      | 6001 | sdw4     | sdw4    | /opt/greenplum/data/primary/gpseg13
   16 |      14 | p    | p              | s    | u      | 6002 | sdw4     | sdw4    | /opt/greenplum/data/primary/gpseg14
   17 |      15 | p    | p              | s    | u      | 6003 | sdw4     | sdw4    | /opt/greenplum/data/primary/gpseg15
   18 |       0 | m    | m              | s    | u      | 7000 | sdw2     | sdw2    | /opt/greenplum/data/mirror/gpseg0
   19 |       1 | m    | m              | s    | u      | 7001 | sdw2     | sdw2    | /opt/greenplum/data/mirror/gpseg1
   20 |       2 | m    | m              | s    | u      | 7002 | sdw2     | sdw2    | /opt/greenplum/data/mirror/gpseg2
   21 |       3 | m    | m              | s    | u      | 7003 | sdw2     | sdw2    | /opt/greenplum/data/mirror/gpseg3
   22 |       4 | m    | m              | s    | u      | 7000 | sdw3     | sdw3    | /opt/greenplum/data/mirror/gpseg4
   23 |       5 | m    | m              | s    | u      | 7001 | sdw3     | sdw3    | /opt/greenplum/data/mirror/gpseg5
   24 |       6 | m    | m              | s    | u      | 7002 | sdw3     | sdw3    | /opt/greenplum/data/mirror/gpseg6
   25 |       7 | m    | m              | s    | u      | 7003 | sdw3     | sdw3    | /opt/greenplum/data/mirror/gpseg7
   26 |       8 | m    | m              | s    | u      | 7000 | sdw4     | sdw4    | /opt/greenplum/data/mirror/gpseg8
   27 |       9 | m    | m              | s    | u      | 7001 | sdw4     | sdw4    | /opt/greenplum/data/mirror/gpseg9
   28 |      10 | m    | m              | s    | u      | 7002 | sdw4     | sdw4    | /opt/greenplum/data/mirror/gpseg10
   29 |      11 | m    | m              | s    | u      | 7003 | sdw4     | sdw4    | /opt/greenplum/data/mirror/gpseg11
   30 |      12 | m    | m              | s    | u      | 7000 | sdw1     | sdw1    | /opt/greenplum/data/mirror/gpseg12
   31 |      13 | m    | m              | s    | u      | 7001 | sdw1     | sdw1    | /opt/greenplum/data/mirror/gpseg13
   32 |      14 | m    | m              | s    | u      | 7002 | sdw1     | sdw1    | /opt/greenplum/data/mirror/gpseg14
   33 |      15 | m    | m              | s    | u      | 7003 | sdw1     | sdw1    | /opt/greenplum/data/mirror/gpseg15
   34 |      -1 | m    | m              | s    | u      | 5432 | mdw2     | mdw2    | /opt/greenplum/data/master/gpseg-1
(34 rows)

lhrgpdb=# select * from gp_segment_configuration order by hostname,port;     
 dbid | content | role | preferred_role | mode | status | port | hostname | address |               datadir               
------+---------+------+----------------+------+--------+------+----------+---------+-------------------------------------
    1 |      -1 | p    | p              | n    | u      | 5432 | mdw1     | mdw1    | /opt/greenplum/data/master/gpseg-1
   34 |      -1 | m    | m              | s    | u      | 5432 | mdw2     | mdw2    | /opt/greenplum/data/master/gpseg-1
    2 |       0 | p    | p              | s    | u      | 6000 | sdw1     | sdw1    | /opt/greenplum/data/primary/gpseg0
    3 |       1 | p    | p              | s    | u      | 6001 | sdw1     | sdw1    | /opt/greenplum/data/primary/gpseg1
    4 |       2 | p    | p              | s    | u      | 6002 | sdw1     | sdw1    | /opt/greenplum/data/primary/gpseg2
    5 |       3 | p    | p              | s    | u      | 6003 | sdw1     | sdw1    | /opt/greenplum/data/primary/gpseg3
   30 |      12 | m    | m              | s    | u      | 7000 | sdw1     | sdw1    | /opt/greenplum/data/mirror/gpseg12
   31 |      13 | m    | m              | s    | u      | 7001 | sdw1     | sdw1    | /opt/greenplum/data/mirror/gpseg13
   32 |      14 | m    | m              | s    | u      | 7002 | sdw1     | sdw1    | /opt/greenplum/data/mirror/gpseg14
   33 |      15 | m    | m              | s    | u      | 7003 | sdw1     | sdw1    | /opt/greenplum/data/mirror/gpseg15
    6 |       4 | p    | p              | s    | u      | 6000 | sdw2     | sdw2    | /opt/greenplum/data/primary/gpseg4
    7 |       5 | p    | p              | s    | u      | 6001 | sdw2     | sdw2    | /opt/greenplum/data/primary/gpseg5
    8 |       6 | p    | p              | s    | u      | 6002 | sdw2     | sdw2    | /opt/greenplum/data/primary/gpseg6
    9 |       7 | p    | p              | s    | u      | 6003 | sdw2     | sdw2    | /opt/greenplum/data/primary/gpseg7
   18 |       0 | m    | m              | s    | u      | 7000 | sdw2     | sdw2    | /opt/greenplum/data/mirror/gpseg0
   19 |       1 | m    | m              | s    | u      | 7001 | sdw2     | sdw2    | /opt/greenplum/data/mirror/gpseg1
   20 |       2 | m    | m              | s    | u      | 7002 | sdw2     | sdw2    | /opt/greenplum/data/mirror/gpseg2
   21 |       3 | m    | m              | s    | u      | 7003 | sdw2     | sdw2    | /opt/greenplum/data/mirror/gpseg3
   10 |       8 | p    | p              | s    | u      | 6000 | sdw3     | sdw3    | /opt/greenplum/data/primary/gpseg8
   11 |       9 | p    | p              | s    | u      | 6001 | sdw3     | sdw3    | /opt/greenplum/data/primary/gpseg9
   12 |      10 | p    | p              | s    | u      | 6002 | sdw3     | sdw3    | /opt/greenplum/data/primary/gpseg10
   13 |      11 | p    | p              | s    | u      | 6003 | sdw3     | sdw3    | /opt/greenplum/data/primary/gpseg11
   22 |       4 | m    | m              | s    | u      | 7000 | sdw3     | sdw3    | /opt/greenplum/data/mirror/gpseg4
   23 |       5 | m    | m              | s    | u      | 7001 | sdw3     | sdw3    | /opt/greenplum/data/mirror/gpseg5
   24 |       6 | m    | m              | s    | u      | 7002 | sdw3     | sdw3    | /opt/greenplum/data/mirror/gpseg6
   25 |       7 | m    | m              | s    | u      | 7003 | sdw3     | sdw3    | /opt/greenplum/data/mirror/gpseg7
   14 |      12 | p    | p              | s    | u      | 6000 | sdw4     | sdw4    | /opt/greenplum/data/primary/gpseg12
   15 |      13 | p    | p              | s    | u      | 6001 | sdw4     | sdw4    | /opt/greenplum/data/primary/gpseg13
   16 |      14 | p    | p              | s    | u      | 6002 | sdw4     | sdw4    | /opt/greenplum/data/primary/gpseg14
   17 |      15 | p    | p              | s    | u      | 6003 | sdw4     | sdw4    | /opt/greenplum/data/primary/gpseg15
   26 |       8 | m    | m              | s    | u      | 7000 | sdw4     | sdw4    | /opt/greenplum/data/mirror/gpseg8
   27 |       9 | m    | m              | s    | u      | 7001 | sdw4     | sdw4    | /opt/greenplum/data/mirror/gpseg9
   28 |      10 | m    | m              | s    | u      | 7002 | sdw4     | sdw4    | /opt/greenplum/data/mirror/gpseg10
   29 |      11 | m    | m              | s    | u      | 7003 | sdw4     | sdw4    | /opt/greenplum/data/mirror/gpseg11
(34 rows)



[gpadmin@mdw1 ~]$ gpstate
20230131:16:37:05:021525 gpstate:mdw1:gpadmin-[INFO]:-Starting gpstate with args: 
20230131:16:37:05:021525 gpstate:mdw1:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 6.23.0 build commit:5b5e432f35f92a40c18dffe4e5bca94790aae83c Open Source'
20230131:16:37:05:021525 gpstate:mdw1:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 9.4.26 (Greenplum Database 6.23.0 build commit:5b5e432f35f92a40c18dffe4e5bca94790aae83c Open Source) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Dec 20 2022 08:02:23'
20230131:16:37:05:021525 gpstate:mdw1:gpadmin-[INFO]:-Obtaining Segment details from master...
20230131:16:37:05:021525 gpstate:mdw1:gpadmin-[INFO]:-Gathering data from segments...
20230131:16:37:05:021525 gpstate:mdw1:gpadmin-[INFO]:-Greenplum instance status summary
20230131:16:37:05:021525 gpstate:mdw1:gpadmin-[INFO]:-----------------------------------------------------
20230131:16:37:05:021525 gpstate:mdw1:gpadmin-[INFO]:-   Master instance                                           = Active
20230131:16:37:05:021525 gpstate:mdw1:gpadmin-[INFO]:-   Master standby                                            = mdw2
20230131:16:37:05:021525 gpstate:mdw1:gpadmin-[INFO]:-   Standby master state                                      = Standby host passive
20230131:16:37:05:021525 gpstate:mdw1:gpadmin-[INFO]:-   Total segment instance count from metadata                = 32
20230131:16:37:05:021525 gpstate:mdw1:gpadmin-[INFO]:-----------------------------------------------------
20230131:16:37:05:021525 gpstate:mdw1:gpadmin-[INFO]:-   Primary Segment Status
20230131:16:37:05:021525 gpstate:mdw1:gpadmin-[INFO]:-----------------------------------------------------
20230131:16:37:05:021525 gpstate:mdw1:gpadmin-[INFO]:-   Total primary segments                                    = 16
20230131:16:37:05:021525 gpstate:mdw1:gpadmin-[INFO]:-   Total primary segment valid (at master)                   = 16
20230131:16:37:05:021525 gpstate:mdw1:gpadmin-[INFO]:-   Total primary segment failures (at master)                = 0
20230131:16:37:05:021525 gpstate:mdw1:gpadmin-[INFO]:-   Total number of postmaster.pid files missing              = 0
20230131:16:37:05:021525 gpstate:mdw1:gpadmin-[INFO]:-   Total number of postmaster.pid files found                = 16
20230131:16:37:05:021525 gpstate:mdw1:gpadmin-[INFO]:-   Total number of postmaster.pid PIDs missing               = 0
20230131:16:37:05:021525 gpstate:mdw1:gpadmin-[INFO]:-   Total number of postmaster.pid PIDs found                 = 16
20230131:16:37:05:021525 gpstate:mdw1:gpadmin-[INFO]:-   Total number of /tmp lock files missing                   = 0
20230131:16:37:05:021525 gpstate:mdw1:gpadmin-[INFO]:-   Total number of /tmp lock files found                     = 16
20230131:16:37:05:021525 gpstate:mdw1:gpadmin-[INFO]:-   Total number postmaster processes missing                 = 0
20230131:16:37:05:021525 gpstate:mdw1:gpadmin-[INFO]:-   Total number postmaster processes found                   = 16
20230131:16:37:05:021525 gpstate:mdw1:gpadmin-[INFO]:-----------------------------------------------------
20230131:16:37:05:021525 gpstate:mdw1:gpadmin-[INFO]:-   Mirror Segment Status
20230131:16:37:05:021525 gpstate:mdw1:gpadmin-[INFO]:-----------------------------------------------------
20230131:16:37:05:021525 gpstate:mdw1:gpadmin-[INFO]:-   Total mirror segments                                     = 16
20230131:16:37:05:021525 gpstate:mdw1:gpadmin-[INFO]:-   Total mirror segment valid (at master)                    = 16
20230131:16:37:05:021525 gpstate:mdw1:gpadmin-[INFO]:-   Total mirror segment failures (at master)                 = 0
20230131:16:37:05:021525 gpstate:mdw1:gpadmin-[INFO]:-   Total number of postmaster.pid files missing              = 0
20230131:16:37:05:021525 gpstate:mdw1:gpadmin-[INFO]:-   Total number of postmaster.pid files found                = 16
20230131:16:37:05:021525 gpstate:mdw1:gpadmin-[INFO]:-   Total number of postmaster.pid PIDs missing               = 0
20230131:16:37:05:021525 gpstate:mdw1:gpadmin-[INFO]:-   Total number of postmaster.pid PIDs found                 = 16
20230131:16:37:05:021525 gpstate:mdw1:gpadmin-[INFO]:-   Total number of /tmp lock files missing                   = 0
20230131:16:37:05:021525 gpstate:mdw1:gpadmin-[INFO]:-   Total number of /tmp lock files found                     = 16
20230131:16:37:05:021525 gpstate:mdw1:gpadmin-[INFO]:-   Total number postmaster processes missing                 = 0
20230131:16:37:05:021525 gpstate:mdw1:gpadmin-[INFO]:-   Total number postmaster processes found                   = 16
20230131:16:37:05:021525 gpstate:mdw1:gpadmin-[INFO]:-   Total number mirror segments acting as primary segments   = 0
20230131:16:37:05:021525 gpstate:mdw1:gpadmin-[INFO]:-   Total number mirror segments acting as mirror segments    = 16
20230131:16:37:05:021525 gpstate:mdw1:gpadmin-[INFO]:-----------------------------------------------------
[gpadmin@mdw1 ~]$ gpstate -s
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-Starting gpstate with args: -s
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 6.23.0 build commit:5b5e432f35f92a40c18dffe4e5bca94790aae83c Open Source'
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 9.4.26 (Greenplum Database 6.23.0 build commit:5b5e432f35f92a40c18dffe4e5bca94790aae83c Open Source) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Dec 20 2022 08:02:23'
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-Obtaining Segment details from master...
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-Gathering data from segments...
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-----------------------------------------------------
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:--Master Configuration & Status
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-----------------------------------------------------
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Master host                    = mdw1
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Master postgres process ID     = 16532
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Master data directory          = /opt/greenplum/data/master/gpseg-1
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Master port                    = 5432
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Master current role            = dispatch
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Greenplum initsystem version   = 6.23.0 build commit:5b5e432f35f92a40c18dffe4e5bca94790aae83c Open Source
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Greenplum current version      = PostgreSQL 9.4.26 (Greenplum Database 6.23.0 build commit:5b5e432f35f92a40c18dffe4e5bca94790aae83c Open Source) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Dec 20 2022 08:02:23
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Postgres version               = 9.4.26
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Master standby                 = mdw2
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Standby master state           = Standby host passive
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-----------------------------------------------------
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-Segment Instance Status Report
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-----------------------------------------------------
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Segment Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Hostname                              = sdw1
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Address                               = sdw1
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Datadir                               = /opt/greenplum/data/primary/gpseg0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Port                                  = 6000
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Mirroring Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Current role                          = Primary
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Preferred role                        = Primary
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Mirror status                         = Synchronized
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Replication Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Current write location                = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Bytes remaining to send to mirror     = 0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Status
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      PID                                   = 1193
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Configuration reports status as       = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Database status                       = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-----------------------------------------------------
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Segment Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Hostname                              = sdw2
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Address                               = sdw2
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Datadir                               = /opt/greenplum/data/mirror/gpseg0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Port                                  = 7000
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Mirroring Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Current role                          = Mirror
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Preferred role                        = Mirror
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Mirror status                         = Streaming
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Replication Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      WAL Sent Location                     = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      WAL Flush Location                    = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      WAL Replay Location                   = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Bytes received but remain to flush    = 0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Bytes received but remain to replay   = 0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Status
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      PID                                   = 1616
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Configuration reports status as       = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Segment status                        = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-----------------------------------------------------
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Segment Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Hostname                              = sdw1
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Address                               = sdw1
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Datadir                               = /opt/greenplum/data/primary/gpseg1
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Port                                  = 6001
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Mirroring Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Current role                          = Primary
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Preferred role                        = Primary
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Mirror status                         = Synchronized
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Replication Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Current write location                = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Bytes remaining to send to mirror     = 0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Status
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      PID                                   = 1192
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Configuration reports status as       = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Database status                       = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-----------------------------------------------------
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Segment Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Hostname                              = sdw2
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Address                               = sdw2
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Datadir                               = /opt/greenplum/data/mirror/gpseg1
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Port                                  = 7001
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Mirroring Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Current role                          = Mirror
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Preferred role                        = Mirror
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Mirror status                         = Streaming
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Replication Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      WAL Sent Location                     = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      WAL Flush Location                    = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      WAL Replay Location                   = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Bytes received but remain to flush    = 0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Bytes received but remain to replay   = 0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Status
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      PID                                   = 1595
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Configuration reports status as       = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Segment status                        = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-----------------------------------------------------
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Segment Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Hostname                              = sdw1
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Address                               = sdw1
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Datadir                               = /opt/greenplum/data/primary/gpseg2
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Port                                  = 6002
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Mirroring Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Current role                          = Primary
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Preferred role                        = Primary
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Mirror status                         = Synchronized
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Replication Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Current write location                = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Bytes remaining to send to mirror     = 0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Status
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      PID                                   = 1195
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Configuration reports status as       = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Database status                       = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-----------------------------------------------------
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Segment Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Hostname                              = sdw2
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Address                               = sdw2
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Datadir                               = /opt/greenplum/data/mirror/gpseg2
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Port                                  = 7002
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Mirroring Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Current role                          = Mirror
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Preferred role                        = Mirror
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Mirror status                         = Streaming
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Replication Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      WAL Sent Location                     = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      WAL Flush Location                    = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      WAL Replay Location                   = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Bytes received but remain to flush    = 0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Bytes received but remain to replay   = 0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Status
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      PID                                   = 1617
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Configuration reports status as       = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Segment status                        = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-----------------------------------------------------
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Segment Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Hostname                              = sdw1
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Address                               = sdw1
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Datadir                               = /opt/greenplum/data/primary/gpseg3
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Port                                  = 6003
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Mirroring Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Current role                          = Primary
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Preferred role                        = Primary
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Mirror status                         = Synchronized
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Replication Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Current write location                = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Bytes remaining to send to mirror     = 0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Status
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      PID                                   = 1194
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Configuration reports status as       = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Database status                       = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-----------------------------------------------------
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Segment Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Hostname                              = sdw2
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Address                               = sdw2
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Datadir                               = /opt/greenplum/data/mirror/gpseg3
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Port                                  = 7003
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Mirroring Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Current role                          = Mirror
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Preferred role                        = Mirror
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Mirror status                         = Streaming
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Replication Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      WAL Sent Location                     = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      WAL Flush Location                    = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      WAL Replay Location                   = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Bytes received but remain to flush    = 0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Bytes received but remain to replay   = 0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Status
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      PID                                   = 1575
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Configuration reports status as       = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Segment status                        = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-----------------------------------------------------
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Segment Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Hostname                              = sdw2
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Address                               = sdw2
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Datadir                               = /opt/greenplum/data/primary/gpseg4
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Port                                  = 6000
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Mirroring Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Current role                          = Primary
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Preferred role                        = Primary
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Mirror status                         = Synchronized
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Replication Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Current write location                = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Bytes remaining to send to mirror     = 0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Status
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      PID                                   = 893
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Configuration reports status as       = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Database status                       = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-----------------------------------------------------
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Segment Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Hostname                              = sdw3
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Address                               = sdw3
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Datadir                               = /opt/greenplum/data/mirror/gpseg4
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Port                                  = 7000
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Mirroring Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Current role                          = Mirror
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Preferred role                        = Mirror
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Mirror status                         = Streaming
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Replication Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      WAL Sent Location                     = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      WAL Flush Location                    = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      WAL Replay Location                   = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Bytes received but remain to flush    = 0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Bytes received but remain to replay   = 0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Status
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      PID                                   = 1576
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Configuration reports status as       = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Segment status                        = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-----------------------------------------------------
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Segment Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Hostname                              = sdw2
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Address                               = sdw2
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Datadir                               = /opt/greenplum/data/primary/gpseg5
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Port                                  = 6001
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Mirroring Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Current role                          = Primary
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Preferred role                        = Primary
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Mirror status                         = Synchronized
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Replication Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Current write location                = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Bytes remaining to send to mirror     = 0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Status
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      PID                                   = 892
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Configuration reports status as       = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Database status                       = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-----------------------------------------------------
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Segment Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Hostname                              = sdw3
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Address                               = sdw3
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Datadir                               = /opt/greenplum/data/mirror/gpseg5
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Port                                  = 7001
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Mirroring Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Current role                          = Mirror
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Preferred role                        = Mirror
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Mirror status                         = Streaming
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Replication Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      WAL Sent Location                     = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      WAL Flush Location                    = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      WAL Replay Location                   = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Bytes received but remain to flush    = 0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Bytes received but remain to replay   = 0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Status
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      PID                                   = 1603
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Configuration reports status as       = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Segment status                        = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-----------------------------------------------------
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Segment Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Hostname                              = sdw2
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Address                               = sdw2
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Datadir                               = /opt/greenplum/data/primary/gpseg6
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Port                                  = 6002
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Mirroring Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Current role                          = Primary
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Preferred role                        = Primary
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Mirror status                         = Synchronized
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Replication Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Current write location                = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Bytes remaining to send to mirror     = 0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Status
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      PID                                   = 895
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Configuration reports status as       = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Database status                       = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-----------------------------------------------------
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Segment Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Hostname                              = sdw3
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Address                               = sdw3
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Datadir                               = /opt/greenplum/data/mirror/gpseg6
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Port                                  = 7002
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Mirroring Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Current role                          = Mirror
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Preferred role                        = Mirror
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Mirror status                         = Streaming
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Replication Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      WAL Sent Location                     = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      WAL Flush Location                    = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      WAL Replay Location                   = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Bytes received but remain to flush    = 0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Bytes received but remain to replay   = 0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Status
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      PID                                   = 1584
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Configuration reports status as       = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Segment status                        = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-----------------------------------------------------
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Segment Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Hostname                              = sdw2
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Address                               = sdw2
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Datadir                               = /opt/greenplum/data/primary/gpseg7
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Port                                  = 6003
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Mirroring Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Current role                          = Primary
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Preferred role                        = Primary
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Mirror status                         = Synchronized
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Replication Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Current write location                = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Bytes remaining to send to mirror     = 0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Status
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      PID                                   = 894
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Configuration reports status as       = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Database status                       = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-----------------------------------------------------
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Segment Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Hostname                              = sdw3
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Address                               = sdw3
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Datadir                               = /opt/greenplum/data/mirror/gpseg7
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Port                                  = 7003
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Mirroring Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Current role                          = Mirror
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Preferred role                        = Mirror
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Mirror status                         = Streaming
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Replication Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      WAL Sent Location                     = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      WAL Flush Location                    = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      WAL Replay Location                   = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Bytes received but remain to flush    = 0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Bytes received but remain to replay   = 0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Status
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      PID                                   = 1589
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Configuration reports status as       = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Segment status                        = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-----------------------------------------------------
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Segment Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Hostname                              = sdw3
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Address                               = sdw3
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Datadir                               = /opt/greenplum/data/primary/gpseg8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Port                                  = 6000
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Mirroring Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Current role                          = Primary
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Preferred role                        = Primary
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Mirror status                         = Synchronized
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Replication Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Current write location                = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Bytes remaining to send to mirror     = 0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Status
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      PID                                   = 880
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Configuration reports status as       = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Database status                       = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-----------------------------------------------------
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Segment Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Hostname                              = sdw4
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Address                               = sdw4
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Datadir                               = /opt/greenplum/data/mirror/gpseg8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Port                                  = 7000
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Mirroring Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Current role                          = Mirror
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Preferred role                        = Mirror
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Mirror status                         = Streaming
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Replication Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      WAL Sent Location                     = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      WAL Flush Location                    = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      WAL Replay Location                   = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Bytes received but remain to flush    = 0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Bytes received but remain to replay   = 0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Status
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      PID                                   = 1549
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Configuration reports status as       = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Segment status                        = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-----------------------------------------------------
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Segment Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Hostname                              = sdw3
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Address                               = sdw3
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Datadir                               = /opt/greenplum/data/primary/gpseg9
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Port                                  = 6001
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Mirroring Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Current role                          = Primary
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Preferred role                        = Primary
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Mirror status                         = Synchronized
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Replication Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Current write location                = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Bytes remaining to send to mirror     = 0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Status
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      PID                                   = 879
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Configuration reports status as       = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Database status                       = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-----------------------------------------------------
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Segment Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Hostname                              = sdw4
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Address                               = sdw4
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Datadir                               = /opt/greenplum/data/mirror/gpseg9
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Port                                  = 7001
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Mirroring Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Current role                          = Mirror
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Preferred role                        = Mirror
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Mirror status                         = Streaming
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Replication Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      WAL Sent Location                     = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      WAL Flush Location                    = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      WAL Replay Location                   = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Bytes received but remain to flush    = 0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Bytes received but remain to replay   = 0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Status
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      PID                                   = 1550
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Configuration reports status as       = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Segment status                        = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-----------------------------------------------------
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Segment Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Hostname                              = sdw3
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Address                               = sdw3
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Datadir                               = /opt/greenplum/data/primary/gpseg10
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Port                                  = 6002
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Mirroring Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Current role                          = Primary
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Preferred role                        = Primary
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Mirror status                         = Synchronized
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Replication Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Current write location                = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Bytes remaining to send to mirror     = 0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Status
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      PID                                   = 878
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Configuration reports status as       = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Database status                       = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-----------------------------------------------------
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Segment Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Hostname                              = sdw4
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Address                               = sdw4
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Datadir                               = /opt/greenplum/data/mirror/gpseg10
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Port                                  = 7002
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Mirroring Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Current role                          = Mirror
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Preferred role                        = Mirror
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Mirror status                         = Streaming
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Replication Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      WAL Sent Location                     = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      WAL Flush Location                    = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      WAL Replay Location                   = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Bytes received but remain to flush    = 0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Bytes received but remain to replay   = 0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Status
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      PID                                   = 1590
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Configuration reports status as       = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Segment status                        = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-----------------------------------------------------
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Segment Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Hostname                              = sdw3
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Address                               = sdw3
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Datadir                               = /opt/greenplum/data/primary/gpseg11
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Port                                  = 6003
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Mirroring Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Current role                          = Primary
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Preferred role                        = Primary
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Mirror status                         = Synchronized
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Replication Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Current write location                = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Bytes remaining to send to mirror     = 0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Status
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      PID                                   = 877
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Configuration reports status as       = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Database status                       = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-----------------------------------------------------
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Segment Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Hostname                              = sdw4
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Address                               = sdw4
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Datadir                               = /opt/greenplum/data/mirror/gpseg11
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Port                                  = 7003
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Mirroring Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Current role                          = Mirror
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Preferred role                        = Mirror
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Mirror status                         = Streaming
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Replication Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      WAL Sent Location                     = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      WAL Flush Location                    = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      WAL Replay Location                   = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Bytes received but remain to flush    = 0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Bytes received but remain to replay   = 0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Status
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      PID                                   = 1591
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Configuration reports status as       = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Segment status                        = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-----------------------------------------------------
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Segment Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Hostname                              = sdw4
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Address                               = sdw4
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Datadir                               = /opt/greenplum/data/primary/gpseg12
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Port                                  = 6000
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Mirroring Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Current role                          = Primary
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Preferred role                        = Primary
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Mirror status                         = Synchronized
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Replication Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Current write location                = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Bytes remaining to send to mirror     = 0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Status
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      PID                                   = 866
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Configuration reports status as       = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Database status                       = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-----------------------------------------------------
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Segment Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Hostname                              = sdw1
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Address                               = sdw1
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Datadir                               = /opt/greenplum/data/mirror/gpseg12
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Port                                  = 7000
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Mirroring Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Current role                          = Mirror
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Preferred role                        = Mirror
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Mirror status                         = Streaming
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Replication Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      WAL Sent Location                     = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      WAL Flush Location                    = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      WAL Replay Location                   = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Bytes received but remain to flush    = 0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Bytes received but remain to replay   = 0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Status
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      PID                                   = 1915
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Configuration reports status as       = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Segment status                        = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-----------------------------------------------------
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Segment Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Hostname                              = sdw4
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Address                               = sdw4
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Datadir                               = /opt/greenplum/data/primary/gpseg13
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Port                                  = 6001
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Mirroring Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Current role                          = Primary
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Preferred role                        = Primary
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Mirror status                         = Synchronized
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Replication Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Current write location                = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Bytes remaining to send to mirror     = 0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Status
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      PID                                   = 867
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Configuration reports status as       = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Database status                       = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-----------------------------------------------------
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Segment Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Hostname                              = sdw1
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Address                               = sdw1
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Datadir                               = /opt/greenplum/data/mirror/gpseg13
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Port                                  = 7001
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Mirroring Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Current role                          = Mirror
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Preferred role                        = Mirror
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Mirror status                         = Streaming
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Replication Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      WAL Sent Location                     = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      WAL Flush Location                    = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      WAL Replay Location                   = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Bytes received but remain to flush    = 0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Bytes received but remain to replay   = 0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Status
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      PID                                   = 1876
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Configuration reports status as       = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Segment status                        = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-----------------------------------------------------
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Segment Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Hostname                              = sdw4
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Address                               = sdw4
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Datadir                               = /opt/greenplum/data/primary/gpseg14
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Port                                  = 6002
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Mirroring Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Current role                          = Primary
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Preferred role                        = Primary
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Mirror status                         = Synchronized
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Replication Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Current write location                = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Bytes remaining to send to mirror     = 0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Status
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      PID                                   = 869
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Configuration reports status as       = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Database status                       = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-----------------------------------------------------
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Segment Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Hostname                              = sdw1
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Address                               = sdw1
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Datadir                               = /opt/greenplum/data/mirror/gpseg14
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Port                                  = 7002
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Mirroring Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Current role                          = Mirror
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Preferred role                        = Mirror
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Mirror status                         = Streaming
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Replication Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      WAL Sent Location                     = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      WAL Flush Location                    = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      WAL Replay Location                   = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Bytes received but remain to flush    = 0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Bytes received but remain to replay   = 0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Status
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      PID                                   = 1918
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Configuration reports status as       = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Segment status                        = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-----------------------------------------------------
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Segment Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Hostname                              = sdw4
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Address                               = sdw4
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Datadir                               = /opt/greenplum/data/primary/gpseg15
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Port                                  = 6003
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Mirroring Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Current role                          = Primary
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Preferred role                        = Primary
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Mirror status                         = Synchronized
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Replication Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Current write location                = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Bytes remaining to send to mirror     = 0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Status
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      PID                                   = 868
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Configuration reports status as       = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Database status                       = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-----------------------------------------------------
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Segment Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Hostname                              = sdw1
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Address                               = sdw1
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Datadir                               = /opt/greenplum/data/mirror/gpseg15
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Port                                  = 7003
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Mirroring Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Current role                          = Mirror
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Preferred role                        = Mirror
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Mirror status                         = Streaming
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Replication Info
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      WAL Sent Location                     = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      WAL Flush Location                    = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      WAL Replay Location                   = 0/C0000A8
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Bytes received but remain to flush    = 0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Bytes received but remain to replay   = 0
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-   Status
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      PID                                   = 1912
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Configuration reports status as       = Up
20230131:16:37:12:021604 gpstate:mdw1:gpadmin-[INFO]:-      Segment status                        = Up
[gpadmin@mdw1 ~]$

其它命令

删除集群数据库

若要删除集群数据库，则可以使用如下命令：

代码语言：javascript
复制
gpdeletesystem -d /opt/greenplum/data/master/gpseg-1

请参考：https://www.xmmup.com/greenplumshujukuchushihuaminglinggpinitsystemheshanchushujukuminglinggpdeletesystem.html#gpdeletesystem

添加和删除standby master库

命令gpstate -f可以查看standby master库的详情。

添加：

代码语言：javascript
复制
gpinitstandby -s mdw2 -S /opt/greenplum/data/master/gpseg-1   -P 5432

删除：

代码语言：javascript
复制
gpinitstandby -r

注意：master和standby master可以在同一台主机上，请注意端口号和data目录不能一样。

参考：https://www.xmmup.com/zaigreenplumshujukuzhongqiyongmasterhesegmentjingxiangmirrors.html#shi_li2

总结

1、使用docker可以快速搭建模拟环境，用于测试各种过程

2、安装的核心命令为：gpinitsystem ，若该命令不能运行成功，则可以查看错误日志在 /home/gpadmin/gpAdminLogs 中

参考

https://www.xmmup.com/greenplumanzhuangpeizhi.html

本文参与 腾讯云自媒体同步曝光计划，分享自微信公众号。
原始发表：2023-02-01，如有侵权请联系 cloudcommunity@tencent.com 删除
data
greenplum
status
部署
配置

本文分享自 DB宝 微信公众号，前往查看

如有侵权，请联系 cloudcommunity@tencent.com 删除。

本文参与 腾讯云自媒体同步曝光计划  ，欢迎热爱写作的你一起参与！

data
greenplum
status
部署
配置
评论
登录后参与评论
0 条评论
热度
最新
登录 后参与评论
推荐阅读
LV.
文章
0
获赞
0
目录
  • 下载
  • 环境申请
  • 修改/etc/hosts文件
  • 创建用户和集群配置文件（所有节点）
  • 配置互信
  • 安装GP软件（所有节点）
  • 配置环境变量
  • 数据库初始化（重要）
  • GP验证
  • 其它命令
    • 删除集群数据库
      • 添加和删除standby master库
      • 总结
      • 参考
      相关产品与服务
      容器服务
      腾讯云容器服务（Tencent Kubernetes Engine, TKE）基于原生 kubernetes 提供以容器为核心的、高度可扩展的高性能容器管理服务，覆盖 Serverless、边缘计算、分布式云等多种业务部署场景，业内首创单个集群兼容多种计算节点的容器资源管理模式。同时产品作为云原生 Finops 领先布道者，主导开源项目Crane，全面助力客户实现资源优化、成本控制。
      产品介绍产品文档
      11.11 上云拼团GO
      领券

      腾讯云开发者

      扫码关注腾讯云开发者

      扫码关注腾讯云开发者

      领取腾讯云代金券

      热门产品

      热门推荐

      更多推荐

      Copyright © 2013 - 2024 Tencent Cloud. All Rights Reserved. 腾讯云 版权所有 

      深圳市腾讯计算机系统有限公司 ICP备案/许可证号：粤B2-20090059 深公网安备号 44030502008569

      腾讯云计算（北京）有限责任公司 京ICP证150476号 |  京ICP备11018762号 | 京公网安备号11010802020287

      问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档

      Copyright © 2013 - 2024 Tencent Cloud.

      All Rights Reserved. 腾讯云 版权所有

      登录 后参与评论