MPP架构之Greenplum的安装配置高级版（企业配置）

由小麦苗 · 发布日期 2023年1月31日 · 已更新 2023年3月18日

👉 本文共约5452个字，系统预计阅读时间或需21分钟。

简介

硬件要求：https://docs.vmware.com/en/VMware-Tanzu-Greenplum/6/greenplum-database/GUID-install_guide-platform-requirements-overview.html

操作系统要求

Greenplum Database 6 runs on the following operating system platforms:

Red Hat Enterprise Linux 64-bit 8.7 or later (As of Greenplum Database version 6.20. See the following Note)
Red Hat Enterprise Linux 64-bit 7.x (See the following Note.)
Red Hat Enterprise Linux 64-bit 6.x
CentOS 64-bit 7.x
CentOS 64-bit 6.x
Ubuntu 18.04 LTS
Oracle Linux 64-bit 7, using the Red Hat Compatible Kernel (RHCK)

特别注意：
1、华为的openEuler 22.03 LTS是不支持GP6的（麦老师已花时间测试）

软件下载

可以从以下2个地方下载：

1、从 Greenplum 的 GitHub 页面（https://github.com/greenplum-db/gpdb/releases）下载RPM 包

2、需要注册并登录到 Pivotal 公司官网（https://network.pivotal.io/products/vmware-tanzu-greenplum）进行下载

安装包大约66MB，如下：

wget https://github.com/greenplum-db/gpdb/releases/download/6.23.1/open-source-greenplum-db-6.23.1-rhel7-x86_64.rpm

-- 加速
wget  https://ghproxy.com/https://github.com/greenplum-db/gpdb/releases/download/6.23.1/open-source-greenplum-db-6.23.1-rhel7-x86_64.rpm

wget https://github.com/greenplum-db/gpdb/releases/download/6.23.1/open-source-greenplum-db-6.23.1-rhel7-x86_64.rpm

-- 加速

wget https://ghproxy.com/https://github.com/greenplum-db/gpdb/releases/download/6.23.1/open-source-greenplum-db-6.23.1-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	主机名	内存	CPU	硬盘	操作系统	数据目录	端口	备注
172.72.6.50	mdw	64G	32	200G	CentOS 7.6	/opt/greenplum/data/master	5432，28080	Master host
172.72.6.51	smdw	64G	32	200G	CentOS 7.6	/opt/greenplum/data/master	5432，28080	Standby host
172.72.6.52	sdw1	64G	32	4T	CentOS 7.6	/opt/greenplum/data/primary /opt/greenplum/data/mirror	主：6000-6003 镜像：7000-7003	segment host1，配置4个主实例+4个镜像实例
172.72.6.53	sdw2	64G	32	4T	CentOS 7.6	/opt/greenplum/data/primary /opt/greenplum/data/mirror	主：6000-6003 镜像：7000-7003	segment host2，配置4个主实例+4个镜像实例
172.72.6.54	sdw3	64G	32	4T	CentOS 7.6	/opt/greenplum/data/primary /opt/greenplum/data/mirror	主：6000-6003 镜像：7000-7003	segment host3，配置4个主实例+4个镜像实例
172.72.6.55	sdw4	64G	32	4T	CentOS 7.6	/opt/greenplum/data/primary /opt/greenplum/data/mirror	主：6000-6003 镜像：7000-7003	segment host4，配置4个主实例+4个镜像实例
172.72.6.59								VIP，在mdw和smdw上进行漂移

-- 网卡
docker network create --subnet=172.72.0.0/16 lhrnw

docker rm -f mdw
docker run -itd --name mdw -h mdw \
  --net=lhrnw --ip 172.72.6.50 \
  -p 64350:5432 -p 28080:28080  \
  -v /sys/fs/cgroup:/sys/fs/cgroup \
  --privileged=true \
  --add-host='mdw:172.72.6.50' \
  --add-host='smdw: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 smdw
docker run -itd --name smdw -h smdw \
  --net=lhrnw --ip 172.72.6.51 \
  -p 64351:5432 -p 28081:28080 \
  -v /sys/fs/cgroup:/sys/fs/cgroup \
  --privileged=true \
  --add-host='mdw:172.72.6.50' \
  --add-host='smdw: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='mdw:172.72.6.50' \
  --add-host='smdw: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='mdw:172.72.6.50' \
  --add-host='smdw: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='mdw:172.72.6.50' \
  --add-host='smdw: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='mdw:172.72.6.50' \
  --add-host='smdw: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.1-rhel7-x86_64.rpm mdw:/soft/
docker cp /soft/open-source-greenplum-db-6.23.1-rhel7-x86_64.rpm smdw:/soft/
docker cp /soft/open-source-greenplum-db-6.23.1-rhel7-x86_64.rpm sdw1:/soft/
docker cp /soft/open-source-greenplum-db-6.23.1-rhel7-x86_64.rpm sdw2:/soft/
docker cp /soft/open-source-greenplum-db-6.23.1-rhel7-x86_64.rpm sdw3:/soft/
docker cp /soft/open-source-greenplum-db-6.23.1-rhel7-x86_64.rpm sdw4:/soft/

-- 网卡

docker network create --subnet=172.72.0.0/16 lhrnw

docker rm -f mdw

docker run -itd --name mdw -h mdw \

--net=lhrnw --ip 172.72.6.50 \

-p 64350:5432 -p 28080:28080 \

-v /sys/fs/cgroup:/sys/fs/cgroup \

--privileged=true \

--add-host='mdw:172.72.6.50' \

--add-host='smdw: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 smdw

docker run -itd --name smdw -h smdw \

--net=lhrnw --ip 172.72.6.51 \

-p 64351:5432 -p 28081:28080 \

-v /sys/fs/cgroup:/sys/fs/cgroup \

--privileged=true \

--add-host='mdw:172.72.6.50' \

--add-host='smdw: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='mdw:172.72.6.50' \

--add-host='smdw: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='mdw:172.72.6.50' \

--add-host='smdw: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='mdw:172.72.6.50' \

--add-host='smdw: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='mdw:172.72.6.50' \

--add-host='smdw: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.1-rhel7-x86_64.rpm mdw:/soft/

docker cp /soft/open-source-greenplum-db-6.23.1-rhel7-x86_64.rpm smdw:/soft/

docker cp /soft/open-source-greenplum-db-6.23.1-rhel7-x86_64.rpm sdw1:/soft/

docker cp /soft/open-source-greenplum-db-6.23.1-rhel7-x86_64.rpm sdw2:/soft/

docker cp /soft/open-source-greenplum-db-6.23.1-rhel7-x86_64.rpm sdw3:/soft/

docker cp /soft/open-source-greenplum-db-6.23.1-rhel7-x86_64.rpm sdw4:/soft/

docker环境：

[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   smdw
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   mdw

[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 smdw

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 mdw

修改主机名

hostnamectl  set-hostname mdw
hostnamectl  set-hostname smdw
hostnamectl  set-hostname sdw1
hostnamectl  set-hostname sdw2
hostnamectl  set-hostname sdw3
hostnamectl  set-hostname sdw4

hostnamectl set-hostname mdw

hostnamectl set-hostname smdw

hostnamectl set-hostname sdw1

hostnamectl set-hostname sdw2

hostnamectl set-hostname sdw3

hostnamectl set-hostname sdw4

修改内核参数

若是docker环境，则以下配置需要在宿主机运行。

sed -i s/SELINUX=enforcing/SELINUX=disabled/g /etc/selinux/config
setenforce 0

cat >> /etc/security/limits.conf <<"EOF"

* soft nofile 65535 
* hard nofile 65535 

EOF

ulimit -HSn 65535

cat >> /etc/sysctl.conf <<"EOF"
kernel.shmmax = 4398046511104
kernel.shmmni = 4096
kernel.shmall = 4000000000
kernel.sem = 32000 1024000000 500 32000

vm.overcommit_memory=2
vm.overcommit_ratio=95

EOF

sysctl -p

docker restart mdw smdw sdw1 sdw2 sdw3 sdw4

sed -i s/SELINUX=enforcing/SELINUX=disabled/g /etc/selinux/config

setenforce 0

cat >> /etc/security/limits.conf <<"EOF"

* soft nofile 65535

* hard nofile 65535

EOF

ulimit -HSn 65535

cat >> /etc/sysctl.conf <<"EOF"

kernel.shmmax = 4398046511104

kernel.shmmni = 4096

kernel.shmall = 4000000000

kernel.sem = 32000 1024000000 500 32000

vm.overcommit_memory=2

vm.overcommit_ratio=95

EOF

sysctl -p

docker restart mdw smdw sdw1 sdw2 sdw3 sdw4

修改/etc/hosts文件

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

cat >> /etc/hosts <<"EOF"
172.72.6.50  mdw
172.72.6.51  smdw
172.72.6.52  sdw1
172.72.6.53  sdw2
172.72.6.54  sdw3
172.72.6.55  sdw4
EOF

cat >> /etc/hosts <<"EOF"

172.72.6.50 mdw

172.72.6.51 smdw

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='mdw:172.72.6.50'"来规避这个问题。

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

为所有节点创建gpadmin用户：

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

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文件，包含所有节点主机名：

su - gpadmin

mkdir -p /home/gpadmin/conf/

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

mdw
smdw
sdw1
sdw2
sdw3
sdw4

EOF

su - gpadmin

mkdir -p /home/gpadmin/conf/

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

mdw

smdw

sdw1

sdw2

sdw3

sdw4

EOF

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

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

sdw1
sdw2
sdw3
sdw4

EOF

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

sdw1

sdw2

sdw3

sdw4

EOF

配置互信

只在master节点（172.72.6.50）操作：

./sshUserSetup.sh -user root  -hosts "mdw smdw sdw1 sdw2 sdw3 sdw4" -advanced exverify –confirm
./sshUserSetup.sh -user gpadmin  -hosts "mdw smdw sdw1 sdw2 sdw3 sdw4" -advanced exverify –confirm
chmod 600 /home/gpadmin/.ssh/config

./sshUserSetup.sh -user root -hosts "mdw smdw sdw1 sdw2 sdw3 sdw4" -advanced exverify –confirm

./sshUserSetup.sh -user gpadmin -hosts "mdw smdw 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用户操作：

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

-- 主要安装包
yum install -y apr apr-util  bzip2  krb5-devel libyaml perl  rsync zip  libevent  --downloadonly --downloaddir=/soft

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

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

-- 主要安装包

yum install -y apr apr-util bzip2 krb5-devel libyaml perl rsync zip libevent --downloadonly --downloaddir=/soft

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

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

chown -R gpadmin:gpadmin /usr/local/greenplum-db
chown -R gpadmin:gpadmin /usr/local/greenplum-db-6.23.1

1 2	chown -R gpadmin:gpadmin /usr/local/greenplum-db chown -R gpadmin:gpadmin /usr/local/greenplum-db-6.23.1

mkdir -p /opt/greenplum/data/
chown -R gpadmin:gpadmin /opt/greenplum

1 2	mkdir -p /opt/greenplum/data/ chown -R gpadmin:gpadmin /opt/greenplum

配置环境变量

-- 所有节点
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
echo "export PGPORT=5432" >> /home/gpadmin/.bashrc

source /home/gpadmin/.bashrc

-- 所有节点

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

echo "export PGPORT=5432" >> /home/gpadmin/.bashrc

source /home/gpadmin/.bashrc

数据库初始化（重要）

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

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

在master节点操作：

[gpadmin@mdw ~]$ cd /usr/local/greenplum-db/docs/cli_help/gpconfigs
[gpadmin@mdw 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

[gpadmin@mdw ~]$ cd /usr/local/greenplum-db/docs/cli_help/gpconfigs

[gpadmin@mdw 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，根据前面的架构规划配置，修改参数：

-- 在所有节点操作（在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节点配置(此处配置每个segment节点上包括4个primary节点和4个mirror节点)
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=mdw
MASTER_DIRECTORY=/opt/greenplum/data/master
DATABASE_NAME=lhrgpdb
MACHINE_LIST_FILE=/home/gpadmin/conf/seg_hosts
EOF

-- 在所有节点操作（在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节点配置(此处配置每个segment节点上包括4个primary节点和4个mirror节点)

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=mdw

MASTER_DIRECTORY=/opt/greenplum/data/master

DATABASE_NAME=lhrgpdb

MACHINE_LIST_FILE=/home/gpadmin/conf/seg_hosts

EOF

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

su - gpadmin
gpinitsystem -c /home/gpadmin/conf/initgp_config -e=lhr -s smdw -P 5432 -S /opt/greenplum/data/master/gpseg-1 -m 500 -b 256MB

1 2	su - gpadmin gpinitsystem -c /home/gpadmin/conf/initgp_config -e=lhr -s smdw -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下的数据资源目录重新初始化。

初始化过程：

[gpadmin@mdw ~]$ gpinitsystem -c /home/gpadmin/conf/initgp_config -e=lhr -s smdw -P 5432 -S /opt/greenplum/data/master/gpseg-1 -m 500 -b 256MB
20230131:16:17:44:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Checking configuration parameters, please wait...
20230131:16:17:44:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Reading Greenplum configuration file /home/gpadmin/conf/initgp_config
20230131:16:17:44:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Locale has not been set in /home/gpadmin/conf/initgp_config, will set to default value
20230131:16:17:44:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Locale set to en_US.utf8
20230131:16:17:44:004521 gpinitsystem:mdw:gpadmin-[WARN]:-CHECK_POINT_SEGMENTS variable not set, will set to default value
20230131:16:17:44:004521 gpinitsystem:mdw:gpadmin-[WARN]:-ENCODING variable not set, will set to default UTF-8
20230131:16:17:44:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Checking configuration parameters, Completed
20230131:16:17:44:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Commencing multi-home checks, please wait...
....
20230131:16:17:45:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Configuring build for standard array
20230131:16:17:45:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Commencing multi-home checks, Completed
20230131:16:17:45:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Building primary segment instance array, please wait...
................
20230131:16:17:50:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Building group mirror array type , please wait...
................
20230131:16:17:55:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Checking Master host
20230131:16:17:55:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Checking new segment hosts, please wait...
................................
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Checking new segment hosts, Completed
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Greenplum Database Creation Parameters
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:---------------------------------------
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Master Configuration
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:---------------------------------------
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Master instance name       = lhrgp
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Master hostname            = mdw
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Master port                = 5432
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Master instance dir        = /opt/greenplum/data/master/gpseg-1
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Master LOCALE              = en_US.utf8
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Greenplum segment prefix   = gpseg
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Master Database            = lhrgpdb
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Master connections         = 500
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Master buffers             = 256MB
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Segment connections        = 1500
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Segment buffers            = 256MB
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Checkpoint segments        = 8
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Encoding                   = UTF-8
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Postgres param file        = Off
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Initdb to be used          = /usr/local/greenplum-db-6.23.1/bin/initdb
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-GP_LIBRARY_PATH is         = /usr/local/greenplum-db-6.23.1/lib
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-HEAP_CHECKSUM is           = on
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-HBA_HOSTNAMES is           = 0
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Ulimit check               = Passed
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Array host connect type    = Single hostname per node
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Master IP address [1]      = 172.72.6.50
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Standby Master             = smdw
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Number of primary segments = 4
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Standby IP address         = 172.72.6.51
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Total Database segments    = 16
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Trusted shell              = /bin/ssh
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Number segment hosts       = 4
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Mirror port base           = 7000
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Number of mirror segments  = 4
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Mirroring config           = ON
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Mirroring type             = Group
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:----------------------------------------
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Greenplum Primary Segment Configuration
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:----------------------------------------
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw1         6000    sdw1    /opt/greenplum/data/primary/gpseg0      2
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw1         6001    sdw1    /opt/greenplum/data/primary/gpseg1      3
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw1         6002    sdw1    /opt/greenplum/data/primary/gpseg2      4
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw1         6003    sdw1    /opt/greenplum/data/primary/gpseg3      5
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw2         6000    sdw2    /opt/greenplum/data/primary/gpseg4      6
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw2         6001    sdw2    /opt/greenplum/data/primary/gpseg5      7
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw2         6002    sdw2    /opt/greenplum/data/primary/gpseg6      8
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw2         6003    sdw2    /opt/greenplum/data/primary/gpseg7      9
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw3         6000    sdw3    /opt/greenplum/data/primary/gpseg8      10
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw3         6001    sdw3    /opt/greenplum/data/primary/gpseg9      11
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw3         6002    sdw3    /opt/greenplum/data/primary/gpseg10     12
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw3         6003    sdw3    /opt/greenplum/data/primary/gpseg11     13
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw4         6000    sdw4    /opt/greenplum/data/primary/gpseg12     14
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw4         6001    sdw4    /opt/greenplum/data/primary/gpseg13     15
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw4         6002    sdw4    /opt/greenplum/data/primary/gpseg14     16
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw4         6003    sdw4    /opt/greenplum/data/primary/gpseg15     17
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:---------------------------------------
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Greenplum Mirror Segment Configuration
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:---------------------------------------
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw2         7000    sdw2    /opt/greenplum/data/mirror/gpseg0       18
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw2         7001    sdw2    /opt/greenplum/data/mirror/gpseg1       19
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw2         7002    sdw2    /opt/greenplum/data/mirror/gpseg2       20
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw2         7003    sdw2    /opt/greenplum/data/mirror/gpseg3       21
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw3         7000    sdw3    /opt/greenplum/data/mirror/gpseg4       22
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw3         7001    sdw3    /opt/greenplum/data/mirror/gpseg5       23
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw3         7002    sdw3    /opt/greenplum/data/mirror/gpseg6       24
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw3         7003    sdw3    /opt/greenplum/data/mirror/gpseg7       25
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw4         7000    sdw4    /opt/greenplum/data/mirror/gpseg8       26
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw4         7001    sdw4    /opt/greenplum/data/mirror/gpseg9       27
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw4         7002    sdw4    /opt/greenplum/data/mirror/gpseg10      28
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw4         7003    sdw4    /opt/greenplum/data/mirror/gpseg11      29
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw1         7000    sdw1    /opt/greenplum/data/mirror/gpseg12      30
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw1         7001    sdw1    /opt/greenplum/data/mirror/gpseg13      31
20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw1         7002    sdw1    /opt/greenplum/data/mirror/gpseg14      32
20230131:16:18:15:004521 gpinitsystem:mdw: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:mdw:gpadmin-[INFO]:-Building the Master instance database, please wait...
20230131:16:19:42:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Starting the Master in admin mode
20230131:16:19:43:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Commencing parallel build of primary segment instances
20230131:16:19:43:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Spawning parallel processes    batch [1], please wait...
................
20230131:16:19:43:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Waiting for parallel processes batch [1], please wait...
............................
20230131:16:20:12:004521 gpinitsystem:mdw:gpadmin-[INFO]:------------------------------------------------
20230131:16:20:12:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Parallel process exit status
20230131:16:20:12:004521 gpinitsystem:mdw:gpadmin-[INFO]:------------------------------------------------
20230131:16:20:12:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Total processes marked as completed           = 16
20230131:16:20:12:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Total processes marked as killed              = 0
20230131:16:20:12:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Total processes marked as failed              = 0
20230131:16:20:12:004521 gpinitsystem:mdw:gpadmin-[INFO]:------------------------------------------------
20230131:16:20:12:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Removing back out file
20230131:16:20:12:004521 gpinitsystem:mdw:gpadmin-[INFO]:-No errors generated from parallel processes
20230131:16:20:12:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Restarting the Greenplum instance in production mode
20230131:16:20:12:016455 gpstop:mdw: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:mdw:gpadmin-[INFO]:-Gathering information and validating the environment...
20230131:16:20:12:016455 gpstop:mdw:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20230131:16:20:12:016455 gpstop:mdw:gpadmin-[INFO]:-Obtaining Segment details from master...
20230131:16:20:12:016455 gpstop:mdw:gpadmin-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 6.23.1 build commit:5b5e432f35f92a40c18dffe4e5bca94790aae83c Open Source'
20230131:16:20:12:016455 gpstop:mdw:gpadmin-[INFO]:-Commencing Master instance shutdown with mode='smart'
20230131:16:20:12:016455 gpstop:mdw:gpadmin-[INFO]:-Master segment instance directory=/opt/greenplum/data/master/gpseg-1
20230131:16:20:12:016455 gpstop:mdw:gpadmin-[INFO]:-Stopping master segment and waiting for user connections to finish ...
server shutting down
20230131:16:20:13:016455 gpstop:mdw:gpadmin-[INFO]:-Attempting forceful termination of any leftover master process
20230131:16:20:13:016455 gpstop:mdw:gpadmin-[INFO]:-Terminating processes for segment /opt/greenplum/data/master/gpseg-1
20230131:16:20:13:016478 gpstart:mdw:gpadmin-[INFO]:-Starting gpstart with args: -a -l /home/gpadmin/gpAdminLogs -d /opt/greenplum/data/master/gpseg-1
20230131:16:20:13:016478 gpstart:mdw:gpadmin-[INFO]:-Gathering information and validating the environment...
20230131:16:20:13:016478 gpstart:mdw:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 6.23.1 build commit:5b5e432f35f92a40c18dffe4e5bca94790aae83c Open Source'
20230131:16:20:13:016478 gpstart:mdw:gpadmin-[INFO]:-Greenplum Catalog Version: '301908232'
20230131:16:20:13:016478 gpstart:mdw:gpadmin-[INFO]:-Starting Master instance in admin mode
20230131:16:20:13:016478 gpstart:mdw:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20230131:16:20:13:016478 gpstart:mdw:gpadmin-[INFO]:-Obtaining Segment details from master...
20230131:16:20:13:016478 gpstart:mdw:gpadmin-[INFO]:-Setting new master era
20230131:16:20:13:016478 gpstart:mdw:gpadmin-[INFO]:-Master Started...
20230131:16:20:13:016478 gpstart:mdw:gpadmin-[INFO]:-Shutting down master
20230131:16:20:13:016478 gpstart:mdw:gpadmin-[INFO]:-Commencing parallel segment instance startup, please wait...
20230131:16:20:14:016478 gpstart:mdw:gpadmin-[INFO]:-Process results...
20230131:16:20:14:016478 gpstart:mdw:gpadmin-[INFO]:-----------------------------------------------------
20230131:16:20:14:016478 gpstart:mdw:gpadmin-[INFO]:-   Successful segment starts                                            = 16
20230131:16:20:14:016478 gpstart:mdw:gpadmin-[INFO]:-   Failed segment starts                                                = 0
20230131:16:20:14:016478 gpstart:mdw:gpadmin-[INFO]:-   Skipped segment starts (segments are marked down in configuration)   = 0
20230131:16:20:14:016478 gpstart:mdw:gpadmin-[INFO]:-----------------------------------------------------
20230131:16:20:14:016478 gpstart:mdw:gpadmin-[INFO]:-Successfully started 16 of 16 segment instances 
20230131:16:20:14:016478 gpstart:mdw:gpadmin-[INFO]:-----------------------------------------------------
20230131:16:20:14:016478 gpstart:mdw:gpadmin-[INFO]:-Starting Master instance mdw directory /opt/greenplum/data/master/gpseg-1 
20230131:16:20:15:016478 gpstart:mdw:gpadmin-[INFO]:-Command pg_ctl reports Master mdw instance active
20230131:16:20:15:016478 gpstart:mdw:gpadmin-[INFO]:-Connecting to dbname='template1' connect_timeout=15
20230131:16:20:15:016478 gpstart:mdw:gpadmin-[INFO]:-No standby master configured.  skipping...
20230131:16:20:15:016478 gpstart:mdw:gpadmin-[INFO]:-Database successfully started
20230131:16:20:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Completed restart of Greenplum instance in production mode
20230131:16:20:21:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Commencing parallel build of mirror segment instances
20230131:16:20:21:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Spawning parallel processes    batch [1], please wait...
................
20230131:16:20:21:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Waiting for parallel processes batch [1], please wait...
.......................
20230131:16:20:45:004521 gpinitsystem:mdw:gpadmin-[INFO]:------------------------------------------------
20230131:16:20:45:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Parallel process exit status
20230131:16:20:45:004521 gpinitsystem:mdw:gpadmin-[INFO]:------------------------------------------------
20230131:16:20:45:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Total processes marked as completed           = 16
20230131:16:20:45:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Total processes marked as killed              = 0
20230131:16:20:45:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Total processes marked as failed              = 0
20230131:16:20:45:004521 gpinitsystem:mdw:gpadmin-[INFO]:------------------------------------------------
20230131:16:20:45:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Starting initialization of standby master smdw
20230131:16:20:45:020512 gpinitstandby:mdw:gpadmin-[INFO]:-Validating environment and parameters for standby initialization...
20230131:16:20:45:020512 gpinitstandby:mdw:gpadmin-[INFO]:-Checking for data directory /opt/greenplum/data/master/gpseg-1 on smdw
20230131:16:20:45:020512 gpinitstandby:mdw:gpadmin-[INFO]:------------------------------------------------------
20230131:16:20:45:020512 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum standby master initialization parameters
20230131:16:20:45:020512 gpinitstandby:mdw:gpadmin-[INFO]:------------------------------------------------------
20230131:16:20:45:020512 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum master hostname               = mdw
20230131:16:20:45:020512 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum master data directory         = /opt/greenplum/data/master/gpseg-1
20230131:16:20:45:020512 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum master port                   = 5432
20230131:16:20:45:020512 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum standby master hostname       = smdw
20230131:16:20:45:020512 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum standby master port           = 5432
20230131:16:20:45:020512 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum standby master data directory = /opt/greenplum/data/master/gpseg-1
20230131:16:20:45:020512 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum update system catalog         = On
20230131:16:20:45:020512 gpinitstandby:mdw:gpadmin-[INFO]:-Syncing Greenplum Database extensions to standby
20230131:16:20:45:020512 gpinitstandby:mdw:gpadmin-[INFO]:-The packages on smdw are consistent.
20230131:16:20:45:020512 gpinitstandby:mdw:gpadmin-[INFO]:-Adding standby master to catalog...
20230131:16:20:45:020512 gpinitstandby:mdw:gpadmin-[INFO]:-Database catalog updated successfully.
20230131:16:20:45:020512 gpinitstandby:mdw:gpadmin-[INFO]:-Updating pg_hba.conf file...
20230131:16:20:46:020512 gpinitstandby:mdw:gpadmin-[INFO]:-pg_hba.conf files updated successfully.
20230131:16:20:52:020512 gpinitstandby:mdw:gpadmin-[INFO]:-Starting standby master
20230131:16:20:52:020512 gpinitstandby:mdw:gpadmin-[INFO]:-Checking if standby master is running on host: smdw  in directory: /opt/greenplum/data/master/gpseg-1
20230131:16:20:53:020512 gpinitstandby:mdw:gpadmin-[INFO]:-Cleaning up pg_hba.conf backup files...
20230131:16:20:53:020512 gpinitstandby:mdw:gpadmin-[INFO]:-Backup files of pg_hba.conf cleaned up successfully.
20230131:16:20:53:020512 gpinitstandby:mdw:gpadmin-[INFO]:-Successfully created standby master on smdw
20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Successfully completed standby master initialization
20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Scanning utility log file for any warning messages
20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[WARN]:-*******************************************************
20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[WARN]:-Scan of log file indicates that some warnings or errors
20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[WARN]:-were generated during the array creation
20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Please review contents of log file
20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-/home/gpadmin/gpAdminLogs/gpinitsystem_20230131.log
20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-To determine level of criticality
20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[WARN]:-*******************************************************
20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Greenplum Database instance successfully created
20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-------------------------------------------------------
20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-To complete the environment configuration, please 
20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-update gpadmin .bashrc file with the following
20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-1. Ensure that the greenplum_path.sh file is sourced
20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-2. Add "export MASTER_DATA_DIRECTORY=/opt/greenplum/data/master/gpseg-1"
20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-   to access the Greenplum scripts for this instance:
20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-   or, use -d /opt/greenplum/data/master/gpseg-1 option for the Greenplum scripts
20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-   Example gpstate -d /opt/greenplum/data/master/gpseg-1
20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Script log file = /home/gpadmin/gpAdminLogs/gpinitsystem_20230131.log
20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-To remove instance, run gpdeletesystem utility
20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Standby Master smdw has been configured
20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-To activate the Standby Master Segment in the event of Master
20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-failure review options for gpactivatestandby
20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-------------------------------------------------------
20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-The Master /opt/greenplum/data/master/gpseg-1/pg_hba.conf post gpinitsystem
20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-has been configured to allow all hosts within this new
20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-array to intercommunicate. Any hosts external to this
20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-new array must be explicitly added to this file
20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Refer to the Greenplum Admin support guide which is
20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-located in the /usr/local/greenplum-db-6.23.1/docs directory
20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-------------------------------------------------------

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

[gpadmin@mdw ~]$ gpinitsystem -c /home/gpadmin/conf/initgp_config -e=lhr -s smdw -P 5432 -S /opt/greenplum/data/master/gpseg-1 -m 500 -b 256MB

20230131:16:17:44:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Checking configuration parameters, please wait...

20230131:16:17:44:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Reading Greenplum configuration file /home/gpadmin/conf/initgp_config

20230131:16:17:44:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Locale has not been set in /home/gpadmin/conf/initgp_config, will set to default value

20230131:16:17:44:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Locale set to en_US.utf8

20230131:16:17:44:004521 gpinitsystem:mdw:gpadmin-[WARN]:-CHECK_POINT_SEGMENTS variable not set, will set to default value

20230131:16:17:44:004521 gpinitsystem:mdw:gpadmin-[WARN]:-ENCODING variable not set, will set to default UTF-8

20230131:16:17:44:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Checking configuration parameters, Completed

20230131:16:17:44:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Commencing multi-home checks, please wait...

....

20230131:16:17:45:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Configuring build for standard array

20230131:16:17:45:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Commencing multi-home checks, Completed

20230131:16:17:45:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Building primary segment instance array, please wait...

................

20230131:16:17:50:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Building group mirror array type , please wait...

................

20230131:16:17:55:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Checking Master host

20230131:16:17:55:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Checking new segment hosts, please wait...

................................

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Checking new segment hosts, Completed

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Greenplum Database Creation Parameters

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:---------------------------------------

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Master Configuration

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:---------------------------------------

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Master instance name = lhrgp

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Master hostname = mdw

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Master port = 5432

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Master instance dir = /opt/greenplum/data/master/gpseg-1

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Master LOCALE = en_US.utf8

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Greenplum segment prefix = gpseg

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Master Database = lhrgpdb

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Master connections = 500

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Master buffers = 256MB

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Segment connections = 1500

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Segment buffers = 256MB

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Checkpoint segments = 8

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Encoding = UTF-8

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Postgres param file = Off

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Initdb to be used = /usr/local/greenplum-db-6.23.1/bin/initdb

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-GP_LIBRARY_PATH is = /usr/local/greenplum-db-6.23.1/lib

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-HEAP_CHECKSUM is = on

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-HBA_HOSTNAMES is = 0

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Ulimit check = Passed

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Array host connect type = Single hostname per node

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Master IP address [1] = 172.72.6.50

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Standby Master = smdw

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Number of primary segments = 4

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Standby IP address = 172.72.6.51

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Total Database segments = 16

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Trusted shell = /bin/ssh

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Number segment hosts = 4

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Mirror port base = 7000

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Number of mirror segments = 4

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Mirroring config = ON

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Mirroring type = Group

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:----------------------------------------

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Greenplum Primary Segment Configuration

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:----------------------------------------

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw1 6000 sdw1 /opt/greenplum/data/primary/gpseg0 2

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw1 6001 sdw1 /opt/greenplum/data/primary/gpseg1 3

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw1 6002 sdw1 /opt/greenplum/data/primary/gpseg2 4

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw1 6003 sdw1 /opt/greenplum/data/primary/gpseg3 5

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw2 6000 sdw2 /opt/greenplum/data/primary/gpseg4 6

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw2 6001 sdw2 /opt/greenplum/data/primary/gpseg5 7

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw2 6002 sdw2 /opt/greenplum/data/primary/gpseg6 8

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw2 6003 sdw2 /opt/greenplum/data/primary/gpseg7 9

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw3 6000 sdw3 /opt/greenplum/data/primary/gpseg8 10

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw3 6001 sdw3 /opt/greenplum/data/primary/gpseg9 11

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw3 6002 sdw3 /opt/greenplum/data/primary/gpseg10 12

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw3 6003 sdw3 /opt/greenplum/data/primary/gpseg11 13

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw4 6000 sdw4 /opt/greenplum/data/primary/gpseg12 14

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw4 6001 sdw4 /opt/greenplum/data/primary/gpseg13 15

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw4 6002 sdw4 /opt/greenplum/data/primary/gpseg14 16

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw4 6003 sdw4 /opt/greenplum/data/primary/gpseg15 17

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:---------------------------------------

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Greenplum Mirror Segment Configuration

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:---------------------------------------

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw2 7000 sdw2 /opt/greenplum/data/mirror/gpseg0 18

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw2 7001 sdw2 /opt/greenplum/data/mirror/gpseg1 19

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw2 7002 sdw2 /opt/greenplum/data/mirror/gpseg2 20

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw2 7003 sdw2 /opt/greenplum/data/mirror/gpseg3 21

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw3 7000 sdw3 /opt/greenplum/data/mirror/gpseg4 22

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw3 7001 sdw3 /opt/greenplum/data/mirror/gpseg5 23

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw3 7002 sdw3 /opt/greenplum/data/mirror/gpseg6 24

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw3 7003 sdw3 /opt/greenplum/data/mirror/gpseg7 25

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw4 7000 sdw4 /opt/greenplum/data/mirror/gpseg8 26

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw4 7001 sdw4 /opt/greenplum/data/mirror/gpseg9 27

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw4 7002 sdw4 /opt/greenplum/data/mirror/gpseg10 28

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw4 7003 sdw4 /opt/greenplum/data/mirror/gpseg11 29

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw1 7000 sdw1 /opt/greenplum/data/mirror/gpseg12 30

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw1 7001 sdw1 /opt/greenplum/data/mirror/gpseg13 31

20230131:16:18:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-sdw1 7002 sdw1 /opt/greenplum/data/mirror/gpseg14 32

20230131:16:18:15:004521 gpinitsystem:mdw: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:mdw:gpadmin-[INFO]:-Building the Master instance database, please wait...

20230131:16:19:42:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Starting the Master in admin mode

20230131:16:19:43:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Commencing parallel build of primary segment instances

20230131:16:19:43:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Spawning parallel processes batch [1], please wait...

................

20230131:16:19:43:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Waiting for parallel processes batch [1], please wait...

............................

20230131:16:20:12:004521 gpinitsystem:mdw:gpadmin-[INFO]:------------------------------------------------

20230131:16:20:12:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Parallel process exit status

20230131:16:20:12:004521 gpinitsystem:mdw:gpadmin-[INFO]:------------------------------------------------

20230131:16:20:12:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Total processes marked as completed = 16

20230131:16:20:12:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Total processes marked as killed = 0

20230131:16:20:12:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Total processes marked as failed = 0

20230131:16:20:12:004521 gpinitsystem:mdw:gpadmin-[INFO]:------------------------------------------------

20230131:16:20:12:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Removing back out file

20230131:16:20:12:004521 gpinitsystem:mdw:gpadmin-[INFO]:-No errors generated from parallel processes

20230131:16:20:12:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Restarting the Greenplum instance in production mode

20230131:16:20:12:016455 gpstop:mdw: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:mdw:gpadmin-[INFO]:-Gathering information and validating the environment...

20230131:16:20:12:016455 gpstop:mdw:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information

20230131:16:20:12:016455 gpstop:mdw:gpadmin-[INFO]:-Obtaining Segment details from master...

20230131:16:20:12:016455 gpstop:mdw:gpadmin-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 6.23.1 build commit:5b5e432f35f92a40c18dffe4e5bca94790aae83c Open Source'

20230131:16:20:12:016455 gpstop:mdw:gpadmin-[INFO]:-Commencing Master instance shutdown with mode='smart'

20230131:16:20:12:016455 gpstop:mdw:gpadmin-[INFO]:-Master segment instance directory=/opt/greenplum/data/master/gpseg-1

20230131:16:20:12:016455 gpstop:mdw:gpadmin-[INFO]:-Stopping master segment and waiting for user connections to finish ...

server shutting down

20230131:16:20:13:016455 gpstop:mdw:gpadmin-[INFO]:-Attempting forceful termination of any leftover master process

20230131:16:20:13:016455 gpstop:mdw:gpadmin-[INFO]:-Terminating processes for segment /opt/greenplum/data/master/gpseg-1

20230131:16:20:13:016478 gpstart:mdw:gpadmin-[INFO]:-Starting gpstart with args: -a -l /home/gpadmin/gpAdminLogs -d /opt/greenplum/data/master/gpseg-1

20230131:16:20:13:016478 gpstart:mdw:gpadmin-[INFO]:-Gathering information and validating the environment...

20230131:16:20:13:016478 gpstart:mdw:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 6.23.1 build commit:5b5e432f35f92a40c18dffe4e5bca94790aae83c Open Source'

20230131:16:20:13:016478 gpstart:mdw:gpadmin-[INFO]:-Greenplum Catalog Version: '301908232'

20230131:16:20:13:016478 gpstart:mdw:gpadmin-[INFO]:-Starting Master instance in admin mode

20230131:16:20:13:016478 gpstart:mdw:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information

20230131:16:20:13:016478 gpstart:mdw:gpadmin-[INFO]:-Obtaining Segment details from master...

20230131:16:20:13:016478 gpstart:mdw:gpadmin-[INFO]:-Setting new master era

20230131:16:20:13:016478 gpstart:mdw:gpadmin-[INFO]:-Master Started...

20230131:16:20:13:016478 gpstart:mdw:gpadmin-[INFO]:-Shutting down master

20230131:16:20:13:016478 gpstart:mdw:gpadmin-[INFO]:-Commencing parallel segment instance startup, please wait...

20230131:16:20:14:016478 gpstart:mdw:gpadmin-[INFO]:-Process results...

20230131:16:20:14:016478 gpstart:mdw:gpadmin-[INFO]:-----------------------------------------------------

20230131:16:20:14:016478 gpstart:mdw:gpadmin-[INFO]:- Successful segment starts = 16

20230131:16:20:14:016478 gpstart:mdw:gpadmin-[INFO]:- Failed segment starts = 0

20230131:16:20:14:016478 gpstart:mdw:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 0

20230131:16:20:14:016478 gpstart:mdw:gpadmin-[INFO]:-----------------------------------------------------

20230131:16:20:14:016478 gpstart:mdw:gpadmin-[INFO]:-Successfully started 16 of 16 segment instances

20230131:16:20:14:016478 gpstart:mdw:gpadmin-[INFO]:-----------------------------------------------------

20230131:16:20:14:016478 gpstart:mdw:gpadmin-[INFO]:-Starting Master instance mdw directory /opt/greenplum/data/master/gpseg-1

20230131:16:20:15:016478 gpstart:mdw:gpadmin-[INFO]:-Command pg_ctl reports Master mdw instance active

20230131:16:20:15:016478 gpstart:mdw:gpadmin-[INFO]:-Connecting to dbname='template1' connect_timeout=15

20230131:16:20:15:016478 gpstart:mdw:gpadmin-[INFO]:-No standby master configured. skipping...

20230131:16:20:15:016478 gpstart:mdw:gpadmin-[INFO]:-Database successfully started

20230131:16:20:15:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Completed restart of Greenplum instance in production mode

20230131:16:20:21:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Commencing parallel build of mirror segment instances

20230131:16:20:21:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Spawning parallel processes batch [1], please wait...

................

20230131:16:20:21:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Waiting for parallel processes batch [1], please wait...

.......................

20230131:16:20:45:004521 gpinitsystem:mdw:gpadmin-[INFO]:------------------------------------------------

20230131:16:20:45:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Parallel process exit status

20230131:16:20:45:004521 gpinitsystem:mdw:gpadmin-[INFO]:------------------------------------------------

20230131:16:20:45:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Total processes marked as completed = 16

20230131:16:20:45:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Total processes marked as killed = 0

20230131:16:20:45:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Total processes marked as failed = 0

20230131:16:20:45:004521 gpinitsystem:mdw:gpadmin-[INFO]:------------------------------------------------

20230131:16:20:45:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Starting initialization of standby master smdw

20230131:16:20:45:020512 gpinitstandby:mdw:gpadmin-[INFO]:-Validating environment and parameters for standby initialization...

20230131:16:20:45:020512 gpinitstandby:mdw:gpadmin-[INFO]:-Checking for data directory /opt/greenplum/data/master/gpseg-1 on smdw

20230131:16:20:45:020512 gpinitstandby:mdw:gpadmin-[INFO]:------------------------------------------------------

20230131:16:20:45:020512 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum standby master initialization parameters

20230131:16:20:45:020512 gpinitstandby:mdw:gpadmin-[INFO]:------------------------------------------------------

20230131:16:20:45:020512 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum master hostname = mdw

20230131:16:20:45:020512 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum master data directory = /opt/greenplum/data/master/gpseg-1

20230131:16:20:45:020512 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum master port = 5432

20230131:16:20:45:020512 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum standby master hostname = smdw

20230131:16:20:45:020512 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum standby master port = 5432

20230131:16:20:45:020512 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum standby master data directory = /opt/greenplum/data/master/gpseg-1

20230131:16:20:45:020512 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum update system catalog = On

20230131:16:20:45:020512 gpinitstandby:mdw:gpadmin-[INFO]:-Syncing Greenplum Database extensions to standby

20230131:16:20:45:020512 gpinitstandby:mdw:gpadmin-[INFO]:-The packages on smdw are consistent.

20230131:16:20:45:020512 gpinitstandby:mdw:gpadmin-[INFO]:-Adding standby master to catalog...

20230131:16:20:45:020512 gpinitstandby:mdw:gpadmin-[INFO]:-Database catalog updated successfully.

20230131:16:20:45:020512 gpinitstandby:mdw:gpadmin-[INFO]:-Updating pg_hba.conf file...

20230131:16:20:46:020512 gpinitstandby:mdw:gpadmin-[INFO]:-pg_hba.conf files updated successfully.

20230131:16:20:52:020512 gpinitstandby:mdw:gpadmin-[INFO]:-Starting standby master

20230131:16:20:52:020512 gpinitstandby:mdw:gpadmin-[INFO]:-Checking if standby master is running on host: smdw in directory: /opt/greenplum/data/master/gpseg-1

20230131:16:20:53:020512 gpinitstandby:mdw:gpadmin-[INFO]:-Cleaning up pg_hba.conf backup files...

20230131:16:20:53:020512 gpinitstandby:mdw:gpadmin-[INFO]:-Backup files of pg_hba.conf cleaned up successfully.

20230131:16:20:53:020512 gpinitstandby:mdw:gpadmin-[INFO]:-Successfully created standby master on smdw

20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Successfully completed standby master initialization

20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Scanning utility log file for any warning messages

20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[WARN]:-*******************************************************

20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[WARN]:-Scan of log file indicates that some warnings or errors

20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[WARN]:-were generated during the array creation

20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Please review contents of log file

20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-/home/gpadmin/gpAdminLogs/gpinitsystem_20230131.log

20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-To determine level of criticality

20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[WARN]:-*******************************************************

20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Greenplum Database instance successfully created

20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-------------------------------------------------------

20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-To complete the environment configuration, please

20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-update gpadmin .bashrc file with the following

20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-1. Ensure that the greenplum_path.sh file is sourced

20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-2. Add "export MASTER_DATA_DIRECTORY=/opt/greenplum/data/master/gpseg-1"

20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:- to access the Greenplum scripts for this instance:

20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:- or, use -d /opt/greenplum/data/master/gpseg-1 option for the Greenplum scripts

20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:- Example gpstate -d /opt/greenplum/data/master/gpseg-1

20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Script log file = /home/gpadmin/gpAdminLogs/gpinitsystem_20230131.log

20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-To remove instance, run gpdeletesystem utility

20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Standby Master smdw has been configured

20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-To activate the Standby Master Segment in the event of Master

20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-failure review options for gpactivatestandby

20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-------------------------------------------------------

20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-The Master /opt/greenplum/data/master/gpseg-1/pg_hba.conf post gpinitsystem

20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-has been configured to allow all hosts within this new

20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-array to intercommunicate. Any hosts external to this

20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-new array must be explicitly added to this file

20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-Refer to the Greenplum Admin support guide which is

20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-located in the /usr/local/greenplum-db-6.23.1/docs directory

20230131:16:20:53:004521 gpinitsystem:mdw:gpadmin-[INFO]:-------------------------------------------------------

看到“Greenplum Database instance successfully created”说明创建成功。

若创建失败，则可以使用如下命令检查错误：

 more /home/gpadmin/gpAdminLogs/gpinitsystem_20230213.log | grep FATAL

1	more /home/gpadmin/gpAdminLogs/gpinitsystem_20230213.log \| grep FATAL

GP验证

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

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

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

260

261

262

263

264

265

266

267

268

269

270

271

272

273

274

275

276

277

278

279

280

281

282

283

284

285

286

287

288

289

290

291

292

293

294

295

296

297

298

299

300

301

302

303

304

305

306

307

308

309

310

311

312

313

314

315

316

317

318

319

320

321

322

323

324

325

326

327

328

329

330

331

332

333

334

335

336

337

338

339

340

341

342

343

344

345

346

347

348

349

350

351

352

353

354

355

356

357

358

359

360

361

362

363

364

365

366

367

368

369

370

371

372

373

374

375

376

377

378

379

380

381

382

383

384

385

386

387

388

389

390

391

392

393

394

395

396

397

398

399

400

401

402

403

404

405

406

407

408

409

410

411

412

413

414

415

416

417

418

419

420

421

422

423

424

425

426

427

428

429

430

431

432

433

434

435

436

437

438

439

440

441

442

443

444

445

446

447

448

449

450

451

452

453

454

455

456

457

458

459

460

461

462

463

464

465

466

467

468

469

470

471

472

473

474

475

476

477

478

479

480

481

482

483

484

485

486

487

488

489

490

491

492

493

494

495

496

497

498

499

500

501

502

503

504

505

506

507

508

509

510

511

512

513

514

515

516

517

518

519

520

521

522

523

524

525

526

527

528

529

530

531

532

533

534

535

536

537

538

539

540

541

542

543

544

545

546

547

548

549

550

551

552

553

554

555

556

557

558

559

560

561

562

563

564

565

566

567

568

569

570

571

572

573

574

575

576

577

578

579

580

581

582

583

584

585

586

587

588

589

590

591

592

593

594

595

596

597

598

599

600

601

602

603

604

605

606

607

608

609

610

611

612

613

614

615

616

617

618

619

620

621

622

623

624

625

626

627

628

629

630

631

632

633

634

635

636

637

638

639

640

641

642

643

644

645

646

647

648

649

650

651

652

653

654

655

656

657

658

659

660

661

662

663

664

665

666

667

668

669

670

671

672

673

674

675

676

677

678

679

680

681

682

683

684

685

686

687

688

689

690

691

692

693

694

695

696

697

698

699

700

701

702

703

704

705

706

707

708

709

710

711

712

713

714

715

716

717

718

719

720

721

722

723

724

725

726

727

728

729

730

731

732

733

734

735

736

737

738

739

740

741

742

743

744

745

746

747

748

749

750

751

752

753

754

755

756

757

758

759

760

761

762

763

764

765

766

767

768

769

770

771

772

773

774

775

776

777

778

779

780

781

782

783

784

785

786

787

788

789

790

791

792

793

794

795

796

797

798

799

800

801

802

803

804

805

806

807

808

809

810

811

812

813

814

815

816

817

[gpadmin@mdw ~]$ 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@mdw ~]$ psql postgres -c 'SELECT * FROM pg_stat_replication;'

-------+----------+---------+------------------+-------------+-----------------+-------------+-------------------------------+--------------+-----------+---------------+----------------+----------------+-----------------+---------------+------------

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@mdw ~]$

[gpadmin@mdw ~]$ psql -d lhrgpdb

psql (9.4.26)

Type "help" for help.

lhrgpdb=# \l

List of databases

-----------+---------+----------+------------+------------+---------------------

(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;

------+---------+------+----------------+------+--------+------+----------+---------+-------------------------------------

1 | -1 | p | p | n | u | 5432 | mdw | mdw | /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 | smdw | smdw | /opt/greenplum/data/master/gpseg-1

(34 rows)

lhrgpdb=# select * from gp_segment_configuration order by hostname,port;