Installation GreenPlum 5.14.0 on Oracle Linux 7.6

Greenplum主要由Master节点、Segment节点、interconnect三大部分组成。Greenplum master是Greenplum数据库系统的入口，接受客户端连接及提交的SQL语句，将工作负载分发给其它数据库实例（segment实例），由它们存储和处理数据。Greenplum interconnect负责不同PostgreSQL实例之间的通信。Greenplum segment是独立的PostgreSQL数据库，每个segment存储一部分数据。大部分查询处理都由segment完成。

一、安装环境配置

1.1 主机信息

Installation GreenPlum 5.14.0 on Oracle Linux 7.6

1.2 操作系统配置

在所有节点执行以下操作步骤。

安装操作系统软件包

yum -y install wget cmake3 git gcc gcc-c++ bison flex libedit-devel zlib zlib-devel perl-devel perl-ExtUtils-Embed python-devel libevent libevent-devel libxml2 libxml2-devel libcurl libcurl-devel bzip2 bzip2-devel net-tools libffi-devel openssl-devel

设置OS内核参数

[root@pg01 ~]# vi /etc/sysctl.conf
kernel.shmmax = 500000000
kernel.shmmni = 4096
kernel.shmall = 4000000000
kernel.sem = 500 1024000 200 4096
kernel.sysrq = 1
kernel.core_uses_pid = 1
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.msgmni = 2048
net.ipv4.tcp_syncookies = 1
net.ipv4.conf.default.accept_source_route = 0
net.ipv4.tcp_tw_recycle = 1
net.ipv4.tcp_max_syn_backlog = 4096
net.ipv4.conf.all.arp_filter = 1
net.ipv4.ip_local_port_range = 10000 65535
net.core.netdev_max_backlog = 10000
net.core.rmem_max = 2097152
net.core.wmem_max = 2097152
vm.overcommit_memory = 2
vm.swappiness = 10
vm.dirty_expire_centisecs = 500
vm.dirty_writeback_centisecs = 100
vm.dirty_background_ratio = 0
vm.dirty_ratio=0
vm.dirty_background_bytes = 1610612736
vm.dirty_bytes = 4294967296

设置OS资源限制

[root@pg01 ~]# vi /etc/security/limits.conf
* soft nofile 65536
* hard nofile 65536
* soft nproc 131072
* hard nproc 131072

设置xfs挂载参数

[root@pg01 ~]# vi /etc/fstab
/dev/datavg/lv01        /u01    xfs     nodev,noatime,inode64,allocsize=16m     0 0

设置disk I/O scheduler

[root@pg01 ~]# grubby --update-kernel=ALL --args="elevator=deadline"

禁用Transparent Huge Pages (THP)

[root@pg01 ~]# grubby --update-kernel=ALL --args="transparent_hugepage=never"

设置disk device的read-ahead值为16384
默认为8192，根据官方要求，必须设置为16384。此参数重启后失效。
```
[root@pg01 ~]# blockdev --getra /dev/datavg/lv01 
8192
[root@pg01 ~]# blockdev --setra 16384 /dev/datavg/lv01
[root@pg01 ~]# blockdev --getra /dev/datavg/lv01 
16384
```
二、安装配置GreenPlum

2.1 安装GreenPlum

这里从官方下载的为二进制rpm软件包，只需在master节点安装即可。
```
[root@pg01 ~]# yum -y localinstall /u02/software/Greenplum/greenplum-db-5.14.0-rhel7-x86_64.rpm
```
2.2 创建ssh免密码登录

[root@pg01 ~]# cd /usr/local/greenplum-db
[root@pg01 greenplum-db]# . ./greenplum_path.sh
[root@pg01 greenplum-db]# cd etc
[root@pg01 etc]# vi gp_all_nodes
pg01
pg02
pg03
pg04
pg05
pg06
[root@pg01 etc]# gpssh-exkeys -f gp_all_nodes
[STEP 1 of 5] create local ID and authorize on local host
  ... /root/.ssh/id_rsa file exists ... key generation skipped

[STEP 2 of 5] keyscan all hosts and update known_hosts file

[STEP 3 of 5] authorize current user on remote hosts
  ... send to pg02
  ... send to pg03
  ... send to pg04
  ... send to pg05
  ... send to pg06

[STEP 4 of 5] determine common authentication file content

[STEP 5 of 5] copy authentication files to all remote hosts
  ... finished key exchange with pg02
  ... finished key exchange with pg03
  ... finished key exchange with pg04
  ... finished key exchange with pg05
  ... finished key exchange with pg06

[INFO] completed successfully

2.3 批量创建GP用户

[root@pg01 etc]# gpssh -f gp_all_nodes
=> groupadd -g 2000 gpadmin
[pg01]
[pg04]
[pg03]
[pg02]
[pg05]
[pg06]
=> groupadd -g 2001 gpmon
[pg01]
[pg04]
[pg03]
[pg02]
[pg05]
[pg06]
=> useradd -u 2000 -g gpadmin -m -s /bin/bash gpadmin
[pg01]
[pg04]
[pg03]
[pg02]
[pg05]
[pg06]
=> useradd -u 2001 -g gpmon -m -s /bin/bash gpmon
[pg01]
[pg04]
[pg03]
[pg02]
[pg05]
[pg06]
=> echo redhat|passwd --stdin gpadmin
[pg01] Changing password for user gpadmin.
[pg01] passwd: all authentication tokens updated successfully.
[pg04] Changing password for user gpadmin.
[pg04] passwd: all authentication tokens updated successfully.
[pg03] Changing password for user gpadmin.
[pg03] passwd: all authentication tokens updated successfully.
[pg02] Changing password for user gpadmin.
[pg02] passwd: all authentication tokens updated successfully.
[pg05] Changing password for user gpadmin.
[pg05] passwd: all authentication tokens updated successfully.
[pg06] Changing password for user gpadmin.
[pg06] passwd: all authentication tokens updated successfully.
=> echo redhat|passwd --stdin gpmon
[pg01] Changing password for user gpmon.
[pg01] passwd: all authentication tokens updated successfully.
[pg04] Changing password for user gpmon.
[pg04] passwd: all authentication tokens updated successfully.
[pg03] Changing password for user gpmon.
[pg03] passwd: all authentication tokens updated successfully.
[pg02] Changing password for user gpmon.
[pg02] passwd: all authentication tokens updated successfully.
[pg05] Changing password for user gpmon.
[pg05] passwd: all authentication tokens updated successfully.
[pg06] Changing password for user gpmon.
[pg06] passwd: all authentication tokens updated successfully.
=> chown -R gpadmin.gpadmin /u01
[pg01]
[pg04]
[pg03]
[pg02]
[pg05]
[pg06]
=> exit

2.4 其他节点安装GP

[root@pg01 ~]# source /usr/local/greenplum-db/greenplum_path.sh
[root@pg01 ~]# export MASTER_DATA_DIRECTORY=/u01/gpmaster
[root@pg01 ~]# cd /usr/local/greenplum-db/etc/
[root@pg01 etc]# gpseginstall -f gp_all_nodes -u gpadmin -p redhat
20181207:13:47:49:013628 gpseginstall:pg01:root-[INFO]:-Installation Info:
link_name greenplum-db
binary_path /usr/local/greenplum-db-5.14.0
binary_dir_location /usr/local
binary_dir_name greenplum-db-5.14.0
20181207:13:47:49:013628 gpseginstall:pg01:root-[INFO]:-check cluster password access
20181207:13:47:50:013628 gpseginstall:pg01:root-[INFO]:-de-duplicate hostnames
20181207:13:47:50:013628 gpseginstall:pg01:root-[INFO]:-master hostname: pg01
20181207:13:47:51:013628 gpseginstall:pg01:root-[INFO]:-check for user gpadmin on cluster
20181207:13:47:52:013628 gpseginstall:pg01:root-[INFO]:-add user gpadmin on master
20181207:13:47:52:013628 gpseginstall:pg01:root-[INFO]:-add user gpadmin on cluster
20181207:13:47:52:013628 gpseginstall:pg01:root-[INFO]:-chown -R gpadmin:gpadmin /usr/local/greenplum-db
20181207:13:47:52:013628 gpseginstall:pg01:root-[INFO]:-chown -R gpadmin:gpadmin /usr/local/greenplum-db-5.14.0
20181207:13:47:52:013628 gpseginstall:pg01:root-[INFO]:-rm -f /usr/local/greenplum-db-5.14.0.tar; rm -f /usr/local/greenplum-db-5.14.0.tar.gz
20181207:13:47:52:013628 gpseginstall:pg01:root-[INFO]:-cd /usr/local; tar cf greenplum-db-5.14.0.tar greenplum-db-5.14.0
20181207:13:47:55:013628 gpseginstall:pg01:root-[INFO]:-gzip /usr/local/greenplum-db-5.14.0.tar
20181207:13:48:31:013628 gpseginstall:pg01:root-[INFO]:-remote command: mkdir -p /usr/local
20181207:13:48:32:013628 gpseginstall:pg01:root-[INFO]:-remote command: rm -rf /usr/local/greenplum-db-5.14.0
20181207:13:48:33:013628 gpseginstall:pg01:root-[INFO]:-scp software to remote location
20181207:13:48:37:013628 gpseginstall:pg01:root-[INFO]:-remote command: gzip -f -d /usr/local/greenplum-db-5.14.0.tar.gz
20181207:13:48:45:013628 gpseginstall:pg01:root-[INFO]:-md5 check on remote location
20181207:13:48:49:013628 gpseginstall:pg01:root-[INFO]:-remote command: cd /usr/local; tar xf greenplum-db-5.14.0.tar
20181207:13:48:52:013628 gpseginstall:pg01:root-[INFO]:-remote command: rm -f /usr/local/greenplum-db-5.14.0.tar
20181207:13:48:53:013628 gpseginstall:pg01:root-[INFO]:-remote command: cd /usr/local; rm -f greenplum-db; ln -fs greenplum-db-5.14.0 greenplum-db
20181207:13:48:54:013628 gpseginstall:pg01:root-[INFO]:-remote command: chown -R gpadmin:gpadmin /usr/local/greenplum-db
20181207:13:48:54:013628 gpseginstall:pg01:root-[INFO]:-remote command: chown -R gpadmin:gpadmin /usr/local/greenplum-db-5.14.0
20181207:13:48:55:013628 gpseginstall:pg01:root-[INFO]:-rm -f /usr/local/greenplum-db-5.14.0.tar.gz
20181207:13:48:55:013628 gpseginstall:pg01:root-[INFO]:-Changing system passwords ...
20181207:13:49:02:013628 gpseginstall:pg01:root-[INFO]:-exchange ssh keys for user root
20181207:13:49:07:013628 gpseginstall:pg01:root-[INFO]:-exchange ssh keys for user gpadmin
20181207:13:49:13:013628 gpseginstall:pg01:root-[INFO]:-/usr/local/greenplum-db/./sbin/gpfixuserlimts -f /etc/security/limits.conf -u gpadmin
20181207:13:49:14:013628 gpseginstall:pg01:root-[INFO]:-remote command: . /usr/local/greenplum-db/./greenplum_path.sh; /usr/local/greenplum-db/./sbin/gpfixuserlimts -f /etc/security/limits.conf -u gpadmin
20181207:13:49:15:013628 gpseginstall:pg01:root-[INFO]:-version string on master: gpssh version 5.14.0 build commit:13927a46a9b39527fc1af2cbb1571d4fd394ff88
20181207:13:49:15:013628 gpseginstall:pg01:root-[INFO]:-remote command: . /usr/local/greenplum-db/./greenplum_path.sh; /usr/local/greenplum-db/./bin/gpssh --version
20181207:13:49:16:013628 gpseginstall:pg01:root-[INFO]:-remote command: . /usr/local/greenplum-db-5.14.0/greenplum_path.sh; /usr/local/greenplum-db-5.14.0/bin/gpssh --version
20181207:13:49:17:013628 gpseginstall:pg01:root-[INFO]:-SUCCESS -- Requested commands completed

2.5 创建相关数据目录

--master和slave创建以下目录
[root@pg01 ~]# su - gpadmin
[gpadmin@pg01 ~]$ mkdir /u01/gpmaster
--其他节点创建以下目录
[root@pg03 ~]# su - gpadmin
[gpadmin@pg03 ~]$ mkdir /u01/gpdatap{1,2};mkdir /u01/gpdatam{1,2}

2.6 初始化GP

--创建初始化文件
[gpadmin@pg01 ~]$ cd /usr/local/greenplum-db/etc
[gpadmin@pg01 etc]$ vi gp_seg_nodes 
pg03
pg04
pg05
pg06
[gpadmin@pg01 etc]$ vi gpinitsystem_config 
ARRAY_NAME="Lee Greenplum DW"
SEG_PREFIX=gpseg
PORT_BASE=40000
declare -a DATA_DIRECTORY=(/u01/gpdatap1 /u01/gpdatap2)
MASTER_HOSTNAME=pg01
MASTER_DIRECTORY=/u01/gpmaster
MASTER_PORT=5432
CHECK_POINT_SEGMENTS=8
ENCODING=UNICODE
MIRROR_PORT_BASE=50000
REPLICATION_PORT_BASE=41000
MIRROR_REPLICATION_PORT_BASE=51000
declare -a MIRROR_DATA_DIRECTORY=(/u01/gpdatam1 /u01/gpdatam2)
--初始化GP
[gpadmin@pg01 etc]$ gpinitsystem -c gpinitsystem_config -h gp_seg_nodes -s pg02 -S
20181207:14:13:16:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Checking configuration parameters, please wait...
20181207:14:13:16:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Reading Greenplum configuration file gpinitsystem_config
20181207:14:13:16:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Locale has not been set in gpinitsystem_config, will set to default value
20181207:14:13:16:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Locale set to en_US.utf8
20181207:14:13:16:020658 gpinitsystem:pg01:gpadmin-[INFO]:-No DATABASE_NAME set, will exit following template1 updates
20181207:14:13:16:020658 gpinitsystem:pg01:gpadmin-[INFO]:-MASTER_MAX_CONNECT not set, will set to default value 250
20181207:14:13:17:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Checking configuration parameters, Completed
20181207:14:13:17:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Commencing multi-home checks, please wait...
....
20181207:14:13:18:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Configuring build for standard array
20181207:14:13:18:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Sufficient hosts for spread mirroring request
20181207:14:13:18:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Commencing multi-home checks, Completed
20181207:14:13:18:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Building primary segment instance array, please wait...
........
20181207:14:13:22:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Building spread mirror array type , please wait...
........
20181207:14:13:26:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Checking Master host
20181207:14:13:26:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Checking new segment hosts, please wait...
................
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Checking new segment hosts, Completed
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Greenplum Database Creation Parameters
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:---------------------------------------
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Master Configuration
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:---------------------------------------
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Master instance name       = Lee Greenplum DW
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Master hostname            = pg01
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Master port                = 5432
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Master instance dir        = /u01/gpmaster/gpseg-1
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Master LOCALE              = en_US.utf8
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Greenplum segment prefix   = gpseg
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Master Database            = 
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Master connections         = 250
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Master buffers             = 128000kB
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Segment connections        = 750
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Segment buffers            = 128000kB
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Checkpoint segments        = 8
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Encoding                   = UNICODE
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Postgres param file        = Off
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Initdb to be used          = /usr/local/greenplum-db/./bin/initdb
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-GP_LIBRARY_PATH is         = /usr/local/greenplum-db/./lib
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-HEAP_CHECKSUM is           = on
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-HBA_HOSTNAMES is           = 0
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Ulimit check               = Passed
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Array host connect type    = Single hostname per node
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Master IP address [1]      = ::1
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Master IP address [2]      = 192.168.120.141
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Master IP address [3]      = fe80::250:56ff:feb0:59ea
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Standby Master             = pg02
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Primary segment #          = 2
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Standby IP address         = ::1
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Standby IP address         = 192.168.120.142
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Standby IP address         = fe80::250:56ff:feb0:696
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Total Database segments    = 8
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Trusted shell              = /bin/ssh
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Number segment hosts       = 4
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Mirror port base           = 50000
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Replicaton port base       = 41000
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Mirror replicaton port base= 51000
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Mirror segment #           = 2
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Mirroring config           = ON
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Mirroring type             = Spread
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:----------------------------------------
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Greenplum Primary Segment Configuration
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:----------------------------------------
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-pg03         /u01/gpdatap1/gpseg0    40000   2       0       41000
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-pg03         /u01/gpdatap1/gpseg1    40001   3       1       41001
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-pg04         /u01/gpdatap1/gpseg2    40000   4       2       41000
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-pg04         /u01/gpdatap1/gpseg3    40001   5       3       41001
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-pg05         /u01/gpdatap1/gpseg4    40000   6       4       41000
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-pg05         /u01/gpdatap1/gpseg5    40001   7       5       41001
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-pg06         /u01/gpdatap1/gpseg6    40000   8       6       41000
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-pg06         /u01/gpdatap1/gpseg7    40001   9       7       41001
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:---------------------------------------
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Greenplum Mirror Segment Configuration
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:---------------------------------------
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-pg04         /u01/gpdatam1/gpseg0    50000   10      0       51000
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-pg05         /u01/gpdatam2/gpseg1    50001   11      1       51001
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-pg05         /u01/gpdatam1/gpseg2    50000   12      2       51000
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-pg06         /u01/gpdatam2/gpseg3    50001   13      3       51001
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-pg06         /u01/gpdatam1/gpseg4    50000   14      4       51000
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-pg03         /u01/gpdatam2/gpseg5    50001   15      5       51001
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-pg03         /u01/gpdatam1/gpseg6    50000   16      6       51000
20181207:14:13:44:020658 gpinitsystem:pg01:gpadmin-[INFO]:-pg04         /u01/gpdatam2/gpseg7    50001   17      7       51001

Continue with Greenplum creation Yy|Nn (default=N):
> y
20181207:14:13:59:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Building the Master instance database, please wait...
20181207:14:14:07:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Starting the Master in admin mode
20181207:14:14:18:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Commencing parallel build of primary segment instances
20181207:14:14:18:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Spawning parallel processes    batch [1], please wait...
........
20181207:14:14:18:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Waiting for parallel processes batch [1], please wait...
.................
20181207:14:14:35:020658 gpinitsystem:pg01:gpadmin-[INFO]:------------------------------------------------
20181207:14:14:35:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Parallel process exit status
20181207:14:14:35:020658 gpinitsystem:pg01:gpadmin-[INFO]:------------------------------------------------
20181207:14:14:35:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Total processes marked as completed           = 8
20181207:14:14:35:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Total processes marked as killed              = 0
20181207:14:14:35:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Total processes marked as failed              = 0
20181207:14:14:35:020658 gpinitsystem:pg01:gpadmin-[INFO]:------------------------------------------------
20181207:14:14:35:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Commencing parallel build of mirror segment instances
20181207:14:14:35:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Spawning parallel processes    batch [1], please wait...
........
20181207:14:14:36:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Waiting for parallel processes batch [1], please wait...
.............
20181207:14:14:49:020658 gpinitsystem:pg01:gpadmin-[INFO]:------------------------------------------------
20181207:14:14:49:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Parallel process exit status
20181207:14:14:49:020658 gpinitsystem:pg01:gpadmin-[INFO]:------------------------------------------------
20181207:14:14:49:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Total processes marked as completed           = 8
20181207:14:14:49:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Total processes marked as killed              = 0
20181207:14:14:49:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Total processes marked as failed              = 0
20181207:14:14:49:020658 gpinitsystem:pg01:gpadmin-[INFO]:------------------------------------------------
20181207:14:14:49:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Deleting distributed backout files
20181207:14:14:49:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Removing back out file
20181207:14:14:49:020658 gpinitsystem:pg01:gpadmin-[INFO]:-No errors generated from parallel processes
20181207:14:14:49:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Restarting the Greenplum instance in production mode
20181207:14:14:50:029433 gpstop:pg01:gpadmin-[INFO]:-Starting gpstop with args: -a -l /home/gpadmin/gpAdminLogs -i -m -d /u01/gpmaster/gpseg-1
20181207:14:14:50:029433 gpstop:pg01:gpadmin-[INFO]:-Gathering information and validating the environment...
20181207:14:14:50:029433 gpstop:pg01:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20181207:14:14:50:029433 gpstop:pg01:gpadmin-[INFO]:-Obtaining Segment details from master...
20181207:14:14:50:029433 gpstop:pg01:gpadmin-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 5.14.0 build commit:13927a46a9b39527fc1af2cbb1571d4fd394ff88'
20181207:14:14:50:029433 gpstop:pg01:gpadmin-[INFO]:-There are 0 connections to the database
20181207:14:14:50:029433 gpstop:pg01:gpadmin-[INFO]:-Commencing Master instance shutdown with mode='immediate'
20181207:14:14:50:029433 gpstop:pg01:gpadmin-[INFO]:-Master host=pg01
20181207:14:14:50:029433 gpstop:pg01:gpadmin-[INFO]:-Commencing Master instance shutdown with mode=immediate
20181207:14:14:50:029433 gpstop:pg01:gpadmin-[INFO]:-Master segment instance directory=/u01/gpmaster/gpseg-1
20181207:14:14:51:029433 gpstop:pg01:gpadmin-[INFO]:-Attempting forceful termination of any leftover master process
20181207:14:14:51:029433 gpstop:pg01:gpadmin-[INFO]:-Terminating processes for segment /u01/gpmaster/gpseg-1
20181207:14:14:51:029461 gpstart:pg01:gpadmin-[INFO]:-Starting gpstart with args: -a -l /home/gpadmin/gpAdminLogs -d /u01/gpmaster/gpseg-1
20181207:14:14:51:029461 gpstart:pg01:gpadmin-[INFO]:-Gathering information and validating the environment...
20181207:14:14:51:029461 gpstart:pg01:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 5.14.0 build commit:13927a46a9b39527fc1af2cbb1571d4fd394ff88'
20181207:14:14:52:029461 gpstart:pg01:gpadmin-[INFO]:-Greenplum Catalog Version: '301705051'
20181207:14:14:52:029461 gpstart:pg01:gpadmin-[INFO]:-Starting Master instance in admin mode
20181207:14:14:53:029461 gpstart:pg01:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20181207:14:14:53:029461 gpstart:pg01:gpadmin-[INFO]:-Obtaining Segment details from master...
20181207:14:14:53:029461 gpstart:pg01:gpadmin-[INFO]:-Setting new master era
20181207:14:14:53:029461 gpstart:pg01:gpadmin-[INFO]:-Master Started...
20181207:14:14:53:029461 gpstart:pg01:gpadmin-[INFO]:-Shutting down master
20181207:14:14:55:029461 gpstart:pg01:gpadmin-[INFO]:-Commencing parallel primary and mirror segment instance startup, please wait...
... 
20181207:14:14:58:029461 gpstart:pg01:gpadmin-[INFO]:-Process results...
20181207:14:14:58:029461 gpstart:pg01:gpadmin-[INFO]:-----------------------------------------------------
20181207:14:14:58:029461 gpstart:pg01:gpadmin-[INFO]:-   Successful segment starts                                            = 16
20181207:14:14:58:029461 gpstart:pg01:gpadmin-[INFO]:-   Failed segment starts                                                = 0
20181207:14:14:58:029461 gpstart:pg01:gpadmin-[INFO]:-   Skipped segment starts (segments are marked down in configuration)   = 0
20181207:14:14:58:029461 gpstart:pg01:gpadmin-[INFO]:-----------------------------------------------------
20181207:14:14:58:029461 gpstart:pg01:gpadmin-[INFO]:-Successfully started 16 of 16 segment instances 
20181207:14:14:58:029461 gpstart:pg01:gpadmin-[INFO]:-----------------------------------------------------
20181207:14:14:58:029461 gpstart:pg01:gpadmin-[INFO]:-Starting Master instance pg01 directory /u01/gpmaster/gpseg-1 
20181207:14:14:59:029461 gpstart:pg01:gpadmin-[INFO]:-Command pg_ctl reports Master pg01 instance active
20181207:14:14:59:029461 gpstart:pg01:gpadmin-[INFO]:-No standby master configured.  skipping...
20181207:14:14:59:029461 gpstart:pg01:gpadmin-[INFO]:-Database successfully started
20181207:14:14:59:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Completed restart of Greenplum instance in production mode
20181207:14:15:00:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Starting initialization of standby master pg02
20181207:14:15:00:029608 gpinitstandby:pg01:gpadmin-[INFO]:-Validating environment and parameters for standby initialization...
20181207:14:15:00:029608 gpinitstandby:pg01:gpadmin-[INFO]:-Checking for filespace directory /u01/gpmaster/gpseg-1 on pg02
20181207:14:15:01:029608 gpinitstandby:pg01:gpadmin-[INFO]:------------------------------------------------------
20181207:14:15:01:029608 gpinitstandby:pg01:gpadmin-[INFO]:-Greenplum standby master initialization parameters
20181207:14:15:01:029608 gpinitstandby:pg01:gpadmin-[INFO]:------------------------------------------------------
20181207:14:15:01:029608 gpinitstandby:pg01:gpadmin-[INFO]:-Greenplum master hostname               = pg01
20181207:14:15:01:029608 gpinitstandby:pg01:gpadmin-[INFO]:-Greenplum master data directory         = /u01/gpmaster/gpseg-1
20181207:14:15:01:029608 gpinitstandby:pg01:gpadmin-[INFO]:-Greenplum master port                   = 5432
20181207:14:15:01:029608 gpinitstandby:pg01:gpadmin-[INFO]:-Greenplum standby master hostname       = pg02
20181207:14:15:01:029608 gpinitstandby:pg01:gpadmin-[INFO]:-Greenplum standby master port           = 5432
20181207:14:15:01:029608 gpinitstandby:pg01:gpadmin-[INFO]:-Greenplum standby master data directory = /u01/gpmaster/gpseg-1
20181207:14:15:01:029608 gpinitstandby:pg01:gpadmin-[INFO]:-Greenplum update system catalog         = On
20181207:14:15:01:029608 gpinitstandby:pg01:gpadmin-[INFO]:------------------------------------------------------
20181207:14:15:01:029608 gpinitstandby:pg01:gpadmin-[INFO]:- Filespace locations
20181207:14:15:01:029608 gpinitstandby:pg01:gpadmin-[INFO]:------------------------------------------------------
20181207:14:15:01:029608 gpinitstandby:pg01:gpadmin-[INFO]:-pg_system -> /u01/gpmaster/gpseg-1
20181207:14:15:01:029608 gpinitstandby:pg01:gpadmin-[INFO]:-Syncing Greenplum Database extensions to standby
20181207:14:15:02:029608 gpinitstandby:pg01:gpadmin-[INFO]:-The packages on pg02 are consistent.
20181207:14:15:02:029608 gpinitstandby:pg01:gpadmin-[INFO]:-Adding standby master to catalog...
20181207:14:15:02:029608 gpinitstandby:pg01:gpadmin-[INFO]:-Database catalog updated successfully.
20181207:14:15:02:029608 gpinitstandby:pg01:gpadmin-[INFO]:-Updating pg_hba.conf file...
20181207:14:15:04:029608 gpinitstandby:pg01:gpadmin-[INFO]:-pg_hba.conf files updated successfully.
20181207:14:15:05:029608 gpinitstandby:pg01:gpadmin-[INFO]:-Updating filespace flat files...
20181207:14:15:05:029608 gpinitstandby:pg01:gpadmin-[INFO]:-Filespace flat file updated successfully.
20181207:14:15:05:029608 gpinitstandby:pg01:gpadmin-[INFO]:-Starting standby master
20181207:14:15:05:029608 gpinitstandby:pg01:gpadmin-[INFO]:-Checking if standby master is running on host: pg02  in directory: /u01/gpmaster/gpseg-1
20181207:14:15:07:029608 gpinitstandby:pg01:gpadmin-[INFO]:-Cleaning up pg_hba.conf backup files...
20181207:14:15:08:029608 gpinitstandby:pg01:gpadmin-[INFO]:-Backup files of pg_hba.conf cleaned up successfully.
20181207:14:15:08:029608 gpinitstandby:pg01:gpadmin-[INFO]:-Successfully created standby master on pg02
20181207:14:15:09:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Successfully completed standby master initialization
20181207:14:15:09:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Scanning utility log file for any warning messages
20181207:14:15:09:020658 gpinitsystem:pg01:gpadmin-[WARN]:-*******************************************************
20181207:14:15:09:020658 gpinitsystem:pg01:gpadmin-[WARN]:-Scan of log file indicates that some warnings or errors
20181207:14:15:09:020658 gpinitsystem:pg01:gpadmin-[WARN]:-were generated during the array creation
20181207:14:15:09:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Please review contents of log file
20181207:14:15:09:020658 gpinitsystem:pg01:gpadmin-[INFO]:-/home/gpadmin/gpAdminLogs/gpinitsystem_20181207.log
20181207:14:15:09:020658 gpinitsystem:pg01:gpadmin-[INFO]:-To determine level of criticality
20181207:14:15:09:020658 gpinitsystem:pg01:gpadmin-[INFO]:-These messages could be from a previous run of the utility
20181207:14:15:09:020658 gpinitsystem:pg01:gpadmin-[INFO]:-that was called today!
20181207:14:15:09:020658 gpinitsystem:pg01:gpadmin-[WARN]:-*******************************************************
20181207:14:15:09:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Greenplum Database instance successfully created
20181207:14:15:09:020658 gpinitsystem:pg01:gpadmin-[INFO]:-------------------------------------------------------
20181207:14:15:09:020658 gpinitsystem:pg01:gpadmin-[INFO]:-To complete the environment configuration, please 
20181207:14:15:09:020658 gpinitsystem:pg01:gpadmin-[INFO]:-update gpadmin .bashrc file with the following
20181207:14:15:09:020658 gpinitsystem:pg01:gpadmin-[INFO]:-1. Ensure that the greenplum_path.sh file is sourced
20181207:14:15:09:020658 gpinitsystem:pg01:gpadmin-[INFO]:-2. Add "export MASTER_DATA_DIRECTORY=/u01/gpmaster/gpseg-1"
20181207:14:15:09:020658 gpinitsystem:pg01:gpadmin-[INFO]:-   to access the Greenplum scripts for this instance:
20181207:14:15:09:020658 gpinitsystem:pg01:gpadmin-[INFO]:-   or, use -d /u01/gpmaster/gpseg-1 option for the Greenplum scripts
20181207:14:15:09:020658 gpinitsystem:pg01:gpadmin-[INFO]:-   Example gpstate -d /u01/gpmaster/gpseg-1
20181207:14:15:09:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Script log file = /home/gpadmin/gpAdminLogs/gpinitsystem_20181207.log
20181207:14:15:09:020658 gpinitsystem:pg01:gpadmin-[INFO]:-To remove instance, run gpdeletesystem utility
20181207:14:15:09:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Standby Master pg02 has been configured
20181207:14:15:09:020658 gpinitsystem:pg01:gpadmin-[INFO]:-To activate the Standby Master Segment in the event of Master
20181207:14:15:09:020658 gpinitsystem:pg01:gpadmin-[INFO]:-failure review options for gpactivatestandby
20181207:14:15:09:020658 gpinitsystem:pg01:gpadmin-[INFO]:-------------------------------------------------------
20181207:14:15:09:020658 gpinitsystem:pg01:gpadmin-[INFO]:-The Master /u01/gpmaster/gpseg-1/pg_hba.conf post gpinitsystem
20181207:14:15:09:020658 gpinitsystem:pg01:gpadmin-[INFO]:-has been configured to allow all hosts within this new
20181207:14:15:09:020658 gpinitsystem:pg01:gpadmin-[INFO]:-array to intercommunicate. Any hosts external to this
20181207:14:15:09:020658 gpinitsystem:pg01:gpadmin-[INFO]:-new array must be explicitly added to this file
20181207:14:15:09:020658 gpinitsystem:pg01:gpadmin-[INFO]:-Refer to the Greenplum Admin support guide which is
20181207:14:15:09:020658 gpinitsystem:pg01:gpadmin-[INFO]:-located in the /usr/local/greenplum-db/./docs directory
20181207:14:15:09:020658 gpinitsystem:pg01:gpadmin-[INFO]:-------------------------------------------------------

2.7 GP登录验证

[gpadmin@pg01 etc]$ psql postgres
psql (8.3.23)
Type "help" for help.

postgres=# l
                  List of databases
   Name    |  Owner  | Encoding |  Access privileges  
-----------+---------+----------+---------------------
 postgres  | gpadmin | UTF8     | 
 template0 | gpadmin | UTF8     | =c/gpadmin          
                                : gpadmin=CTc/gpadmin
 template1 | gpadmin | UTF8     | =c/gpadmin          
                                : gpadmin=CTc/gpadmin
(3 rows)

postgres=# l+
                                           List of databases
   Name    |  Owner  | Encoding |  Access privileges  | Size  | Tablespace |        Description        
-----------+---------+----------+---------------------+-------+------------+---------------------------
 postgres  | gpadmin | UTF8     |                     | 94 MB | pg_default | 
 template0 | gpadmin | UTF8     | =c/gpadmin          | 93 MB | pg_default | 
                                : gpadmin=CTc/gpadmin                        
 template1 | gpadmin | UTF8     | =c/gpadmin          | 94 MB | pg_default | default template database
                                : gpadmin=CTc/gpadmin                        
(3 rows)

postgres=# select *from gp_toolkit.gp_disk_free order by dfhostname;
 dfsegment | dfhostname |         dfdevice         | dfspace  
-----------+------------+--------------------------+----------
         0 |  pg03      |  /dev/mapper/datavg-lv01 | 51966932
         1 |  pg03      |  /dev/mapper/datavg-lv01 | 51966932
         3 |  pg04      |  /dev/mapper/datavg-lv01 | 51966928
         2 |  pg04      |  /dev/mapper/datavg-lv01 | 51966928
         5 |  pg05      |  /dev/mapper/datavg-lv01 | 51966912
         4 |  pg05      |  /dev/mapper/datavg-lv01 | 51966912
         7 |  pg06      |  /dev/mapper/datavg-lv01 | 51966932
         6 |  pg06      |  /dev/mapper/datavg-lv01 | 51966932
(8 rows)

2.8 集群状态信息

[gpadmin@pg01 ~]$ gpstate -s
20181207:14:37:37:031467 gpstate:pg01:gpadmin-[INFO]:-Starting gpstate with args: -s
20181207:14:37:37:031467 gpstate:pg01:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 5.14.0 build commit:13927a46a9b39527fc1af2cbb1571d4fd394ff88'
20181207:14:37:37:031467 gpstate:pg01:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 8.3.23 (Greenplum Database 5.14.0 build commit:13927a46a9b39527fc1af2cbb1571d4fd394ff88) on x86_64-pc-linux-gnu, compiled by GCC gcc (GCC) 6.2.0, 64-bit compiled on Nov 28 2018 08:08:06'
20181207:14:37:37:031467 gpstate:pg01:gpadmin-[INFO]:-Obtaining Segment details from master...
20181207:14:37:37:031467 gpstate:pg01:gpadmin-[INFO]:-Gathering data from segments...
... 
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-----------------------------------------------------
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:--Master Configuration & Status
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-----------------------------------------------------
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Master host                    = pg01
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Master postgres process ID     = 29548
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Master data directory          = /u01/gpmaster/gpseg-1
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Master port                    = 5432
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Master current role            = dispatch
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Greenplum initsystem version   = 5.14.0 build commit:13927a46a9b39527fc1af2cbb1571d4fd394ff88
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Greenplum current version      = PostgreSQL 8.3.23 (Greenplum Database 5.14.0 build commit:13927a46a9b39527fc1af2cbb1571d4fd394ff88) on x86_64-pc-linux-gnu, compiled by GCC gcc (GCC) 6.2.0, 64-bit compiled on Nov 28 2018 08:08:06
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Postgres version               = 8.3.23
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Master standby                 = pg02
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Standby master state           = Standby host passive
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-----------------------------------------------------
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-Segment Instance Status Report
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-----------------------------------------------------
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Segment Info
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Hostname                          = pg03
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Address                           = pg03
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Datadir                           = /u01/gpdatap1/gpseg0
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Port                              = 40000
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Mirroring Info
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Current role                      = Primary
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Preferred role                    = Primary
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Mirror status                     = Synchronized
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Status
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      PID                               = 17457
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Configuration reports status as   = Up
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Database status                   = Up
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-----------------------------------------------------
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Segment Info
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Hostname                          = pg04
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Address                           = pg04
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Datadir                           = /u01/gpdatam1/gpseg0
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Port                              = 50000
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Mirroring Info
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Current role                      = Mirror
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Preferred role                    = Mirror
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Mirror status                     = Synchronized
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Status
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      PID                               = 17513
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Configuration reports status as   = Up
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Segment status                    = Up
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-----------------------------------------------------
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Segment Info
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Hostname                          = pg03
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Address                           = pg03
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Datadir                           = /u01/gpdatap1/gpseg1
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Port                              = 40001
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Mirroring Info
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Current role                      = Primary
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Preferred role                    = Primary
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Mirror status                     = Synchronized
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Status
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      PID                               = 17455
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Configuration reports status as   = Up
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Database status                   = Up
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-----------------------------------------------------
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Segment Info
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Hostname                          = pg05
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Address                           = pg05
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Datadir                           = /u01/gpdatam2/gpseg1
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Port                              = 50001
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Mirroring Info
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Current role                      = Mirror
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Preferred role                    = Mirror
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Mirror status                     = Synchronized
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Status
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      PID                               = 17476
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Configuration reports status as   = Up
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Segment status                    = Up
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-----------------------------------------------------
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Segment Info
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Hostname                          = pg04
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Address                           = pg04
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Datadir                           = /u01/gpdatap1/gpseg2
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Port                              = 40000
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Mirroring Info
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Current role                      = Primary
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Preferred role                    = Primary
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Mirror status                     = Synchronized
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Status
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      PID                               = 17509
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Configuration reports status as   = Up
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Database status                   = Up
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-----------------------------------------------------
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Segment Info
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Hostname                          = pg05
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Address                           = pg05
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Datadir                           = /u01/gpdatam1/gpseg2
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Port                              = 50000
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Mirroring Info
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Current role                      = Mirror
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Preferred role                    = Mirror
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Mirror status                     = Synchronized
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Status
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      PID                               = 17473
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Configuration reports status as   = Up
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Segment status                    = Up
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-----------------------------------------------------
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Segment Info
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Hostname                          = pg04
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Address                           = pg04
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Datadir                           = /u01/gpdatap1/gpseg3
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Port                              = 40001
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Mirroring Info
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Current role                      = Primary
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Preferred role                    = Primary
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Mirror status                     = Synchronized
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Status
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      PID                               = 17512
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Configuration reports status as   = Up
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Database status                   = Up
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-----------------------------------------------------
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Segment Info
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Hostname                          = pg06
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Address                           = pg06
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Datadir                           = /u01/gpdatam2/gpseg3
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Port                              = 50001
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Mirroring Info
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Current role                      = Mirror
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Preferred role                    = Mirror
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Mirror status                     = Synchronized
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Status
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      PID                               = 17484
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Configuration reports status as   = Up
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Segment status                    = Up
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-----------------------------------------------------
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Segment Info
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Hostname                          = pg05
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Address                           = pg05
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Datadir                           = /u01/gpdatap1/gpseg4
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Port                              = 40000
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Mirroring Info
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Current role                      = Primary
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Preferred role                    = Primary
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Mirror status                     = Synchronized
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Status
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      PID                               = 17474
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Configuration reports status as   = Up
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Database status                   = Up
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-----------------------------------------------------
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Segment Info
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Hostname                          = pg06
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Address                           = pg06
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Datadir                           = /u01/gpdatam1/gpseg4
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Port                              = 50000
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Mirroring Info
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Current role                      = Mirror
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Preferred role                    = Mirror
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Mirror status                     = Synchronized
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Status
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      PID                               = 17483
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Configuration reports status as   = Up
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Segment status                    = Up
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-----------------------------------------------------
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Segment Info
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Hostname                          = pg05
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Address                           = pg05
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Datadir                           = /u01/gpdatap1/gpseg5
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Port                              = 40001
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Mirroring Info
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Current role                      = Primary
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Preferred role                    = Primary
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Mirror status                     = Synchronized
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Status
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      PID                               = 17475
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Configuration reports status as   = Up
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Database status                   = Up
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-----------------------------------------------------
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Segment Info
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Hostname                          = pg03
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Address                           = pg03
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Datadir                           = /u01/gpdatam2/gpseg5
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Port                              = 50001
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Mirroring Info
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Current role                      = Mirror
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Preferred role                    = Mirror
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Mirror status                     = Synchronized
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Status
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      PID                               = 17456
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Configuration reports status as   = Up
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Segment status                    = Up
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-----------------------------------------------------
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Segment Info
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Hostname                          = pg06
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Address                           = pg06
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Datadir                           = /u01/gpdatap1/gpseg6
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Port                              = 40000
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Mirroring Info
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Current role                      = Primary
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Preferred role                    = Primary
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Mirror status                     = Synchronized
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Status
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      PID                               = 17481
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Configuration reports status as   = Up
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Database status                   = Up
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-----------------------------------------------------
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Segment Info
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Hostname                          = pg03
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Address                           = pg03
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Datadir                           = /u01/gpdatam1/gpseg6
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Port                              = 50000
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Mirroring Info
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Current role                      = Mirror
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Preferred role                    = Mirror
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Mirror status                     = Synchronized
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Status
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      PID                               = 17454
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Configuration reports status as   = Up
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Segment status                    = Up
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-----------------------------------------------------
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Segment Info
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Hostname                          = pg06
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Address                           = pg06
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Datadir                           = /u01/gpdatap1/gpseg7
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Port                              = 40001
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Mirroring Info
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Current role                      = Primary
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Preferred role                    = Primary
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Mirror status                     = Synchronized
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Status
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      PID                               = 17482
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Configuration reports status as   = Up
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Database status                   = Up
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-----------------------------------------------------
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Segment Info
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Hostname                          = pg04
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Address                           = pg04
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Datadir                           = /u01/gpdatam2/gpseg7
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Port                              = 50001
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Mirroring Info
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Current role                      = Mirror
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Preferred role                    = Mirror
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Mirror status                     = Synchronized
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-   Status
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      PID                               = 17514
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Configuration reports status as   = Up
20181207:14:37:40:031467 gpstate:pg01:gpadmin-[INFO]:-      Segment status                    = Up

三、安装GreenPlum Performance Monitor

3.1 创建gpperfmon数据库

[gpadmin@pg01 ~]$ gpperfmon_install --enable --password redhat --port 5432
20181207:16:14:14:005559 gpperfmon_install:pg01:gpadmin-[INFO]:-createdb gpperfmon >& /dev/null
20181207:16:14:16:005559 gpperfmon_install:pg01:gpadmin-[INFO]:-PGPORT=5432 psql -f /usr/local/greenplum-db/./lib/gpperfmon/gpperfmon.sql gpperfmon >& /dev/null
20181207:16:14:18:005559 gpperfmon_install:pg01:gpadmin-[INFO]:-PGPORT=5432 psql template1 -c "DROP ROLE IF EXISTS gpmon"  >& /dev/null
20181207:16:14:18:005559 gpperfmon_install:pg01:gpadmin-[INFO]:-PGPORT=5432 psql template1 -c "CREATE ROLE gpmon WITH SUPERUSER CREATEDB LOGIN ENCRYPTED PASSWORD 'redhat'"  >& /dev/null
20181207:16:14:18:005559 gpperfmon_install:pg01:gpadmin-[INFO]:-echo "local    gpperfmon         gpmon         md5" >> /u01/gpmaster/gpseg-1/pg_hba.conf
20181207:16:14:18:005559 gpperfmon_install:pg01:gpadmin-[INFO]:-echo "host     all         gpmon         127.0.0.1/28    md5" >> /u01/gpmaster/gpseg-1/pg_hba.conf
20181207:16:14:18:005559 gpperfmon_install:pg01:gpadmin-[INFO]:-echo "host     all         gpmon         ::1/128    md5" >> /u01/gpmaster/gpseg-1/pg_hba.conf
20181207:16:14:18:005559 gpperfmon_install:pg01:gpadmin-[INFO]:-touch /home/gpadmin/.pgpass >& /dev/null
20181207:16:14:18:005559 gpperfmon_install:pg01:gpadmin-[INFO]:-mv -f /home/gpadmin/.pgpass /home/gpadmin/.pgpass.1544170454 >& /dev/null
20181207:16:14:18:005559 gpperfmon_install:pg01:gpadmin-[INFO]:-echo "*:5432:gpperfmon:gpmon:redhat" >> /home/gpadmin/.pgpass
20181207:16:14:18:005559 gpperfmon_install:pg01:gpadmin-[INFO]:-cat /home/gpadmin/.pgpass.1544170454 >> /home/gpadmin/.pgpass
20181207:16:14:18:005559 gpperfmon_install:pg01:gpadmin-[INFO]:-chmod 0600 /home/gpadmin/.pgpass >& /dev/null
20181207:16:14:18:005559 gpperfmon_install:pg01:gpadmin-[INFO]:-PGPORT=5432 gpconfig -c gp_enable_gpperfmon -v on >& /dev/null
20181207:16:14:20:005559 gpperfmon_install:pg01:gpadmin-[INFO]:-PGPORT=5432 gpconfig -c gpperfmon_port -v 8888 >& /dev/null
20181207:16:14:21:005559 gpperfmon_install:pg01:gpadmin-[INFO]:-PGPORT=5432 gpconfig -c gp_external_enable_exec -v on --masteronly >& /dev/null
20181207:16:14:23:005559 gpperfmon_install:pg01:gpadmin-[INFO]:-PGPORT=5432 gpconfig -c gpperfmon_log_alert_level -v warning >& /dev/null
20181207:16:14:25:005559 gpperfmon_install:pg01:gpadmin-[INFO]:-gpperfmon will be enabled after a full restart of GPDB
[gpadmin@pg01 ~]$ gpstop -afr
20181207:16:14:45:005890 gpstop:pg01:gpadmin-[INFO]:-Starting gpstop with args: -afr
20181207:16:14:45:005890 gpstop:pg01:gpadmin-[INFO]:-Gathering information and validating the environment...
20181207:16:14:45:005890 gpstop:pg01:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20181207:16:14:45:005890 gpstop:pg01:gpadmin-[INFO]:-Obtaining Segment details from master...
20181207:16:14:46:005890 gpstop:pg01:gpadmin-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 5.14.0 build commit:13927a46a9b39527fc1af2cbb1571d4fd394ff88'
20181207:16:14:46:005890 gpstop:pg01:gpadmin-[INFO]:-There are 0 connections to the database
20181207:16:14:46:005890 gpstop:pg01:gpadmin-[INFO]:-Commencing Master instance shutdown with mode='fast'
20181207:16:14:46:005890 gpstop:pg01:gpadmin-[INFO]:-Master host=pg01
20181207:16:14:46:005890 gpstop:pg01:gpadmin-[INFO]:-Detected 0 connections to database
20181207:16:14:46:005890 gpstop:pg01:gpadmin-[INFO]:-Using standard WAIT mode of 120 seconds
20181207:16:14:46:005890 gpstop:pg01:gpadmin-[INFO]:-Commencing Master instance shutdown with mode=fast
20181207:16:14:46:005890 gpstop:pg01:gpadmin-[INFO]:-Master segment instance directory=/u01/gpmaster/gpseg-1
20181207:16:14:47:005890 gpstop:pg01:gpadmin-[INFO]:-Attempting forceful termination of any leftover master process
20181207:16:14:47:005890 gpstop:pg01:gpadmin-[INFO]:-Terminating processes for segment /u01/gpmaster/gpseg-1
20181207:16:14:47:005890 gpstop:pg01:gpadmin-[INFO]:-Stopping master standby host pg02 mode=fast
20181207:16:14:49:005890 gpstop:pg01:gpadmin-[INFO]:-Successfully shutdown standby process on pg02
20181207:16:14:49:005890 gpstop:pg01:gpadmin-[INFO]:-Targeting dbid [2, 10, 3, 11, 4, 12, 5, 13, 6, 14, 7, 15, 8, 16, 9, 17] for shutdown
20181207:16:14:49:005890 gpstop:pg01:gpadmin-[INFO]:-Commencing parallel primary segment instance shutdown, please wait...
20181207:16:14:49:005890 gpstop:pg01:gpadmin-[INFO]:-0.00% of jobs completed
20181207:16:14:51:005890 gpstop:pg01:gpadmin-[INFO]:-100.00% of jobs completed
20181207:16:14:51:005890 gpstop:pg01:gpadmin-[INFO]:-Commencing parallel mirror segment instance shutdown, please wait...
20181207:16:14:51:005890 gpstop:pg01:gpadmin-[INFO]:-0.00% of jobs completed
20181207:16:14:53:005890 gpstop:pg01:gpadmin-[INFO]:-100.00% of jobs completed
20181207:16:14:53:005890 gpstop:pg01:gpadmin-[INFO]:-----------------------------------------------------
20181207:16:14:53:005890 gpstop:pg01:gpadmin-[INFO]:-   Segments stopped successfully      = 16
20181207:16:14:53:005890 gpstop:pg01:gpadmin-[INFO]:-   Segments with errors during stop   = 0
20181207:16:14:53:005890 gpstop:pg01:gpadmin-[INFO]:-----------------------------------------------------
20181207:16:14:53:005890 gpstop:pg01:gpadmin-[INFO]:-Successfully shutdown 16 of 16 segment instances 
20181207:16:14:53:005890 gpstop:pg01:gpadmin-[INFO]:-Database successfully shutdown with no errors reported
20181207:16:14:53:005890 gpstop:pg01:gpadmin-[INFO]:-Cleaning up leftover gpmmon process
20181207:16:14:53:005890 gpstop:pg01:gpadmin-[INFO]:-No leftover gpmmon process found
20181207:16:14:53:005890 gpstop:pg01:gpadmin-[INFO]:-Cleaning up leftover gpsmon processes
20181207:16:14:54:005890 gpstop:pg01:gpadmin-[INFO]:-No leftover gpsmon processes on some hosts. not attempting forceful termination on these hosts
20181207:16:14:54:005890 gpstop:pg01:gpadmin-[INFO]:-Cleaning up leftover shared memory
20181207:16:14:54:005890 gpstop:pg01:gpadmin-[INFO]:-Restarting System...

3.2 解压安装CC

[root@pg01 ~]# unzip /u02


                        
                        
                            
                            版权声明：本文来源CSDN，感谢博主原创文章，遵循 CC 4.0 by-sa 版权协议，转载请附上原文出处链接和本声明。

                            原文链接：https://blog.csdn.net/weixin_34335458/article/details/85069739

                            站方申明：本站部分内容来自社区用户分享，若涉及侵权，请联系站方删除。
                        
                        
                        
                            
                                
                                    
                                    发表于 2020-03-07 20:41:12
                                
                                阅读 ( 1089 )
                                分类：Linux


                

    
        
            你可能感兴趣的文章
            
                
                
                    （转）Linux查看用户及其权限管理
                    1444 浏览
                
                
                
                    linux切换root用户
                    960 浏览
                
                
                
                    Linux获取root权限
                    1258 浏览
                
                
                
                    RedHat Linux 修改root用户的密码
                    827 浏览
                
                
                
                    linux如何找回root用户密码?
                    629 浏览
                
                
                
                    在Linux【centOS6.8】上安装mysql5.7的错误—— Requires: libc.so.6(GLIBC_2.17)(64bit)
                    1650 浏览
                
                
                
                    Linux 命令行处理图片（图片格式转换、缩放、旋转等）
                    1312 浏览
                
                
                
                    Linux下如何查看分区文件系统类型
                    669 浏览
                
                
                
                    Linux运维零基础学习大纲
                    1495 浏览
                
                
            
        
        
            精选的优质文章
            
                
                
                    也许 Go 开发可以更简单！
                    10573 浏览
                
                
                
                    如何使用 Golang 日志监控你的应用程序？
                    12044 浏览
                
                
                
                    从Go语言实现模板设计模式浅谈Go的抽象能力
                    14098 浏览
                
                
                
                    阿里云基于 Go 的微服务架构分享
                    23961 浏览
                
                
                
                    java是否会被取代？Go会否给Java带来冲击？
                    28488 浏览
                
                
                
                    千万级规模高性能、高并发的网络架构经验分享
                    30043 浏览
                
                
                
                    阿里部分面试题汇总,对想进阿里的同学非常实用
                    62337 浏览
                
                
                
                    实用好文：知乎实时数仓架构实践及演进
                    31358 浏览
                
                
                
                    支撑马蜂窝「双11」营销大战背后的技术架构
                    228304 浏览
                
                
                
                    想进大厂？50个多线程面试题，你会多少？（一）
                    23097 浏览
                
                
            
        

    



                
                    0 条评论
                    
                        
                        
                        
                            
                                请先 登录 后评论


            

    
        官方社群
        
            
                
                    
                
                
            

              关注公众号
            
—— 加入社区微信群 ——

                →「Go语言教程」领取

            

                
            
        
    
    

    GO教程
    
    
    
        
        
            
            
                
                1.1 Go语言简介
                
                1.2 Go语言的特性
                
                1.3 Go语言为并发而生
                
                1.4 哪些项目使用Go语言开发？
                
                1.5 哪些大公司正在使用Go语言
                
                1.6 Go语言的性能如何？
                
                1.7 Go语言标准库强大
                
                1.8 Go语言上手简单
                
                1.9 Go语言代码风格清晰、简单
                
                1.10 Go语言工程结构详述
                
                1.11 第一个Go语言程序
                
                1.12 Go语言历史版本
                
            
        
        
        
            
            
                
                2.1 Go语言变量的声明
                
                2.2 Go语言变量的初始化
                
                2.3 Go语言多个变量同时赋值
                
                2.4 Go语言匿名变量
                
                2.5 Go语言变量的作用域
                
                2.6 Go语言整型（整数类型）
                
                2.7 Go语言浮点类型（小数类型）
                
                2.8 Go语言复数
                
                2.9 Go语言bool类型（布尔类型）
                
                2.10 Go语言字符串
                
                2.11 Go语言字符类型（byte和rune）
                
                2.12 Go语言数据类型转换
                
                2.13 Go语言指针
                
                2.14 Go语言变量的生命周期
                
                2.15 Go语言常量
                
                2.16 Go语言类型别名
                
                2.17 Go语言关键字与标识符
                
                2.18 Go语言运算符的优先级
                
            
        
        
        
            
            
                
                3.1 Go语言数组
                
                3.2 Go语言多维数组
                
                3.3  Go语言切片
                
                3.4 使用append()为切片添加元素
                
                3.5 Go语言切片复制
                
                3.6 Go语言从切片中删除元素
                
                3.7 Go语言range关键字
                
                3.8 Go语言多维切片
                
                3.9 Go语言map（映射）
                
                3.10 Go语言遍历map
                
                3.11 map元素的删除和清空
                
                3.12  Go语言sync.Map
                
                3.13 Go语言list（列表）
                
                3.14 Go语言nil：空值/零值
                
            
        
        
        
            
            
                
                4.1 Go语言分支结构
                
                4.2 Go语言循环结构
                
                4.4 Go语言键值循环
                
                4.5 Go语言switch语句
                
                4.6 Go语言goto语句
                
                4.7 Go语言break（跳出循环）
                
                4.8 Go语言continue
                
            
        
        
        
            
            
                
                5.1 Go语言函数声明
                
                5.2 Go语言函数变量
                
                5.3 Go语言匿名函数
                
                5.4 Go语言函数类型实现接口
                
                5.5 Go语言闭包（Closure）
                
                5.6 Go语言可变参数
                
                5.7 Go语言defer（延迟执行语句）
                
                5.8 Go语言递归函数
                
                5.9  Go语言处理运行时错误
                
                5.10 Go语言宕机（panic）
                
                5.11 Go语言宕机恢复（recover）
                
                5.12 Go语言计算函数执行时间
                
                5.13 Go语言Test功能测试函数
                
            
        
        
        
            
            
                
                6.1 Go语言结构体定义
                
                6.2 Go语言实例化结构体
                
                6.3 初始化结构体的成员变量
                
                6.4 Go语言构造函数
                
                6.5 类型内嵌和结构体内嵌
                
                6.6 初始化内嵌结构体
                
                6.7 内嵌结构体成员名字冲突
                
                6.8 Go语言垃圾回收和SetFinalizer
                
                6.9 Go语言链表操作
                
                6.10 Go语言数据I/O对象及操作
                
            
        
        
        
            
            
                
                7.1 Go语言接口声明（定义）
                
                7.2 Go语言实现接口的条件
                
                7.3 Go语言类型与接口的关系
                
                7.4 Go语言类型断言
                
                7.5  Go语言排序
                
                7.6 Go语言接口的嵌套组合
                
                7.9 Go语言接口和类型之间的转换
                
                7.10 Go语言空接口类型
                
                7.11 Go语言类型分支
                
                7.12 Go语言error接口
                
            
        
        
        
            
            
                
                8.1 包的基本概念
                
                8.2 Go语言封装简介及实现细节
                
                8.3 Go语言GOPATH
                
                8.4 Go语言常用内置包
                
                8.5 Go语言自定义包
                
                8.6 Go语言package
                
                8.7 Go语言导出包中的标识符
                
                8.8 Go语言import导入包
                
                8.9 Go语言sync包与锁
                
                8.10 Go语言big包
                
                8.11 Go语言正则表达式：regexp包
                
                8.12 Go语言time包：时间和日期
                
                8.13  Go语言os包用法简述
                
                8.14 Go语言flag包：命令行参数解析
                
                8.15 Go语言go mod包依赖管理工具
                
                8.16 Go语言runtime包:运行时
                
            
        
        
        
            
            
                
                9.1 Go语言并发简述
                
                9.2 Go语言轻量级线程
                
                9.3 Go语言并发通信
                
                9.4 Go语言竞争状态
                
                9.5 Go语言调整并发的运行性能
                
                9.6 并发和并行的区别
                
                9.7 goroutine和coroutine的区别
                
                9.8 Go语言通道（chan）
                
                9.9 示例：并发打印
                
                9.10 Go语言单向通道
                
                9.11 Go语言无缓冲的通道
                
                9.12 Go语言带缓冲的通道
                
                9.13 Go语言channel超时机制
                
                9.14 Go语言多核并行化
                
                9.15 互斥锁和读写互斥锁
                
                9.16 Go语言等待组
                
                9.17 死锁、活锁和饥饿概述
                
                9.18 Go语言CSP：通信顺序进程简述
                
                9.19 示例：聊天服务器
                
            
        
        
        
            
            
                
                10.1 Go语言反射（reflection）
                
                10.2 Go语言反射规则浅析
                
                10.3 通过反射获取类型信息
                
                10.4 通过反射获取指针指向的元素类型
                
                10.5 通过反射获取结构体的成员类型
                
                10.6 Go语言结构体标签
                
                10.7 通过反射获取值信息
                
                10.8 通过反射访问结构体成员的值
                
                10.9 判断反射值的空和有效性
                
                10.10 通过反射修改变量的值
                
                10.11 通过类型信息创建实例
                
                10.12 通过反射调用函数
                
                10.13 Go语言inject库：依赖注入
                
            
        
        
        
            
            
                
                11.1 Go语言自定义数据文件
                
                11.2 Go语言JSON文件的读写操作
                
                11.3 Go语言XML文件的读写操作
                
                11.4 Go语言使用Gob传输数据
                
                11.5 Go语言纯文本文件的读写操作
                
                11.6 Go语言二进制文件的读写操作
                
                11.7 Go语言自定义二进制文件的读写操作
                
                11.8 Go语言zip归档文件的读写操作
                
                11.9 Go语言tar归档文件的读写操作
                
                11.10 Go语言使用buffer读取文件
                
                11.11 Go语言文件的写入、追加、读取、复制操作
                
                11.12 Go语言文件锁操作
                
            
        
        
        
            
            
                
                12.1 go build命令
                
                12.2 go clean命令
                
                12.3 go run命令
                
                12.4 go fmt命令
                
                12.5 go install命令
                
                12.6 go get命令
                
                12.7 go generate命令
                
                12.8 go test命令
                
                12.9 go pprof命令
                
            
        
        
        
            
            
                
                13.1 Go语言的深拷贝和浅拷贝
                
                13.2 Go语言引用传递和值传递
                
                13.3 Go语言的Socket编程
                
            
        
        
        
            
            
                
                14.1 Golang Map底层实现
                
                14.2 go语言触发异常的场景有哪些
                
                14.3 Printf()、Sprintf()、Fprintf()函数的区别用法是什么
                
                14.4 详细说说new和make的区别
                
                14.5 详细说说切片和数组的区别
                
                14.6 Golang的内存模型，为什么小对象多了会造成gc压力
                
                14.7 Data Race问题怎么解决？能不能不加锁解决这个问题
                
                14.8 在 range 迭代 slice 时，你怎么修改值的
                
                14.9 select可以用于什么
                
                14.10 go语言编程的好处是什么
                
                14.11 你是否主动关闭过http连接，为啥要这样做
                
                14.12 recover的执行时机
                
                14.13 说出一个避免Goroutine泄露的措施
                
                14.14 如何跳出for select 循环
                
                14.15 如何初始化带嵌套结构的结构体
                
                14.16 Printf()、Sprintf()、Fprintf()函数的区别用法是什么
                
                14.17 go语言中的引用类型包含哪些
                
                14.18 说说go语言的select机制
                
            
        
        
    



    
        推荐文章
        
            
            
                linux命令-- pstack命令(跟踪进程栈)
            
            
            
                Linux操作系统与实训教程1-2章课后习题（简答题）
            
            
            
                五种Linux IO模型+同步异步，阻塞非阻塞，再也不怕头条面试官挂我了
            
            
            
                如何管理linux设备上的bridge(网桥)和docker bridge
            
            
            
                Linux C学习笔记-排序算法1-插入排序
            
            
            
                Linux下使用jpnevulator监听串口收发数据
            
            
            
                11周通关 Linux + 云计算 + 容器技术，打通高端运维成长路线！
            
            
            
                为什么Linux允许用户删除根目录？如何删了会怎样？
            
            
            
                献给初学者：谈谈如何学习Linux操作系统
            
            
            
                【总结】linux安装mysql踩过的坑。。。
            
            
        
    
    
    

    
    
        猜你喜欢
        



        
    
    
    
    
    
    
        随便看看
        
            
            
                阿里云物联网批量获取设备的在线离线状态
                
            
            
            
                使用Linux版印象笔记nixnote2
                
            
            
            
                linux下安装一款笔记软件(为知笔记)
                
            
            
            
                MQTT+ActiveMQ实现消息推送（服务器端java实现）
                
            
            
            
                Java回调~mqtt回调处理中的问题
                
            
            
            
                Linux NFS服务器的安装与配置
                
            
            
            
                Linux下5种IO模型以及阻塞/非阻塞/同步/异步区别
                
            
            
            
                linux下错误使用pthread_mutex_lock导致程序奔溃问题分析
                
            
            
            
                模重复平方计算法
                
            
            
            
                 【Laravel+Apicloud+Vue开发混合式App系列】第1集-Laravel安装及扩展安装配置

Installation GreenPlum 5.14.0 on Oracle Linux 7.6

一、安装环境配置

1.1 主机信息

1.2 操作系统配置

二、安装配置GreenPlum

2.1 安装GreenPlum

2.2 创建ssh免密码登录

2.3 批量创建GP用户

2.4 其他节点安装GP

2.5 创建相关数据目录

2.6 初始化GP

2.7 GP登录验证

2.8 集群状态信息

三、安装GreenPlum Performance Monitor

3.1 创建gpperfmon数据库

3.2 解压安装CC

你可能感兴趣的文章

精选的优质文章

0 条评论

官方社群

GO教程

推荐文章

猜你喜欢

随便看看