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

2023-04-27 13:27:18 浏览数 (1)

下载

可以从 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

data greenplum status 部署 配置

0 人点赞