【PG】Greenplum-db-6.2.1的安装部署
目录
- 1配置host文件(所有节点)
- 2 配置用户
- 3 配置/etc/sysctl.conf文件
- 4 limit文件，后面添加【不影响安装】
- 5 安装greenplum-db-6.2.1-rhel7-x86_64.rpm
- 6 应用环境变量
- 7 设置conf文件
- 8 使用gpssh-exkeys命令打通所有机器的通道
- 9 打包master的Greenplum-db-6.2.1软件，分发到各个segment机器中。
- 10 master节点：建立pgmaster目录。
- 11 segment节点:建立Primary目录和Mirror目录。
- 12 master节点:配置环境变量
- 13 初始化Greenplum的配置文件
- 14 初始化数据库
前置条件:
Greenplum一般集群，需要一个Master和三个Segment。这篇文档，只讲部署，不讲基本概念。
IP地址规划：
Mater:172.30.200.100
Segment：172.30.200.101,172.30.200.102,172.30.200.103
1配置host文件(所有节点)
[root@arpmdw ~]# cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
172.30.200.100 arpmdw
172.30.200.101 arpsdw1
172.30.200.102 arpsdw2
172.30.200.103 arpsdw3当然每个主机，都需要配置自己的hostname，这里不赘述了。
2 配置用户
groupadd gpadmin
useradd gpadmin -g gpadmin
passwd gpadmin3 配置/etc/sysctl.conf文件
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2147483648
kernel.shmmax = 68719476736
kernel.shmmni = 4096
kernel.sem = 1024 204800 1024 512
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586因为/proc/sys/kernel/sem配置不正确，可能会有如下错误
错误日志如下:
cat /home/gpadmin/gpAdminLogs/gpinitsystem_20200304.log
有如下错误:
2020-03-04 03:10:25.714894 GMT,,,p11333,th-349497216,,,,0,,,seg-10000,,,,,"FATAL","XX000","could not create semaphores: 设备上没有空间 (pg_sema.c:126)","Failed system call was semget(5432031, 17, 03600).","This error does *not* mean that you have run out of disk space. It occurs when either the system limit for the maximum number of semaphore sets (SEMMNI), or the system wide maximum number of semaphores (SEMMNS), would be exceeded. You need to raise the respective kernel parameter. Alternatively, reduce PostgreSQL's consumption of semaphores by reducing its max_connections parameter.4 limit文件，后面添加【不影响安装】
5 安装greenplum-db-6.2.1-rhel7-x86_64.rpm
rpm -ivh greenplum-db-6.2.1-rhel7-x86_64.rpm安装的默认目录:/usr/local/greenplum-db。这是一个链接，指向的是:/usr/local/greenplum-db-6.2.1
其目录下的核心文件对应的用途如下:
- bin目录:代表了Greenplum数据库管理的核心执行工具程序。
- doc/cli_help目录:对于command-line工具的一些帮助文档。
- doc/cli_help/gpconfigs：包含了gpinitsystem的时候，配置文件的范例，可以在安装和初始化Greenplum数据库的时候使用或者修改后使用。
- ext目录:一些附加的程序
- inclue:对于Greenplum数据库的一些C语言头文件。
- lib:对于Greenplum数据库的一些库文件
- sbin:作为支持的脚本和程序或者内部的脚本和程序。
6 应用环境变量
su - gpadmin
[gpadmin@arpmdw ~]$ source /usr/local/greenplum-db/greenplum_path.sh7 设置conf文件
[gpadmin@arpmdw greenplum-db]$ mkdir conf
[gpadmin@arpmdw greenplum-db]$ pwd
/usr/local/greenplum-db
[gpadmin@arpmdw greenplum-db]$ cd conf
[gpadmin@arpmdw conf]$ cat hostlist
arpmdw
arpsdw1
arpsdw2
arpsdw3
[gpadmin@arpmdw conf]$ cat /usr/local/greenplum-db/conf/seg_hosts
arpsdw1
arpsdw2
arpsdw3举例如下:设置hostlist文件，用于互信打通各个服务器
gpssh-exkeys -f hostlist
8 使用gpssh-exkeys命令打通所有机器的通道
[STEP 1 of 5] create local ID and authorize on local host
... /home/gpadmin/.ssh/id_rsa file exists ... key generation skipped
[STEP 2 of 5] keyscan all hosts and update known_hosts file
[STEP 3 of 5] retrieving credentials from remote hosts
... send to arpsdw1
... send to arpsdw2
... send to arpsdw3
[STEP 4 of 5] determine common authentication file content
[STEP 5 of 5] copy authentication files to all remote hosts
... finished key exchange with arpsdw1
... finished key exchange with arpsdw2
... finished key exchange with arpsdw3
[INFO] completed successfully后面可以使用gpssh的命令，做批量操作。
[gpadmin@arpmdw conf]$ gpssh -f hostlist这里，使用一个pwd命令，可以看到四台服务器的目录。
[gpadmin@arpmdw conf]$ gpssh -f hostlist
=> pwd
[ arpmdw] /home/gpadmin
[arpsdw2] /home/gpadmin
[arpsdw1] /home/gpadmin
[arpsdw3] /home/gpadmin9 打包master的Greenplum-db-6.2.1软件，分发到各个segment机器中。
打包，赋权
[root@arpmdw local]# tar zcvf greenplum-db-6-2-1.tar.gz greenplum-db-6.2.1/
[root@arpmdw local]# chown -R gpadmin:gpadmin greenplum-db-6-2-1.tar.gz使用gpscp命令分发到每一台机器上去。
[root@arpmdw local]# su - gpadmin
[gpadmin@arpmdw ~]$ source /usr/local/greenplum-db/greenplum_path.sh
gpscp -f /usr/local/greenplum-db/conf/hostlist /usr/local/greenplum-db-6-2-1.tar.gz =:/usr/local/传送到各个服务器之后，由于/usr/local的权限问题。权宜之计，我在每台服务器上面执行如下命令:
tar zxvf greenplum-db-6-2-1.tar.gz
[root@arpsdw3 local]# ln -s greenplum-db-6.2.1 greenplum-db
[root@arpsdw2 local]# chown -R gpadmin:gpadmin greenplum-db查看各个服务器，每个软件的权限和位置，是否配置正确
[gpadmin@arpmdw ~]$ source /usr/local/greenplum-db/greenplum_path.sh
[gpadmin@arpmdw ~]$ pgssh -f /usr/local/greenplum-db/conf/hostlist
=> ll |grep green
[ arpmdw] lrwxrwxrwx 1 gpadmin gpadmin 29 2月 19 15:49 greenplum-db -> /usr/local/greenplum-db-6.2.1
[ arpmdw] drwxr-xr-x 11 gpadmin gpadmin 4096 2月 19 16:06 greenplum-db-6.2.1
[ arpmdw] -rw-r--r-- 1 gpadmin gpadmin 111984084 2月 19 16:20 greenplum-db-6-2-1.tar.gz
[arpsdw2] lrwxrwxrwx 1 gpadmin gpadmin 18 2月 19 16:32 greenplum-db -> greenplum-db-6.2.1
[arpsdw2] drwxr-xr-x 11 gpadmin gpadmin 4096 2月 19 16:06 greenplum-db-6.2.1
[arpsdw2] -rw-r--r-- 1 root root 111984084 2月 19 16:20 greenplum-db-6-2-1.tar.gz
[arpsdw1] lrwxrwxrwx 1 gpadmin gpadmin 18 2月 19 16:34 greenplum-db -> greenplum-db-6.2.1
[arpsdw1] drwxr-xr-x 11 gpadmin gpadmin 4096 2月 19 16:06 greenplum-db-6.2.1
[arpsdw1] -rw-r--r-- 1 root root 111984084 2月 19 16:20 greenplum-db-6-2-1.tar.gz
[arpsdw3] lrwxrwxrwx 1 gpadmin gpadmin 18 2月 19 16:33 greenplum-db -> greenplum-db-6.2.1
[arpsdw3] drwxr-xr-x 11 gpadmin gpadmin 4096 2月 19 16:06 greenplum-db-6.2.1
[arpsdw3] -rw-r--r-- 1 root root 111984084 2月 19 16:20 greenplum-db-6-2-1.tar.gz10 master节点：建立pgmaster目录。
[root@arpmdw local]# su - gpadmin
[gpadmin@arpmdw ~]$ mkdir -p /data/gpdata/gpmaster11 segment节点:建立Primary目录和Mirror目录。
mkdir -p /data/gpdata/gpdatap1
mkdir -p /data/gpdata/gpdatap2
mkdir -p /data/gpdata/gpdatam1
mkdir -p /data/gpdata/gpdatam2这里,使用pwd命令，可以看到四台服务器的目录
su - gpadmin
[gpadmin@arpmdw ~]$ source /usr/local/greenplum-db/greenplum_path.sh
[gpadmin@arpmdw conf]$ gpssh -f /usr/local/greenplum-db/conf/seg_hosts
=> mkdir -p /data/gpdata/gpdatap1
=> mkdir -p /data/gpdata/gpdatap2
=> mkdir -p /data/gpdata/gpdatam1
=> mkdir -p /data/gpdata/gpdatam2
=> ls -l /data/gpdata/
[arpsdw2] 总用量 0
[arpsdw2] drwxrwxr-x 2 gpadmin gpadmin 6 2月 19 18:05 gpdatam1
[arpsdw2] drwxrwxr-x 2 gpadmin gpadmin 6 2月 19 18:05 gpdatam2
[arpsdw2] drwxrwxr-x 2 gpadmin gpadmin 6 2月 19 18:04 gpdatap1
[arpsdw2] drwxrwxr-x 2 gpadmin gpadmin 6 2月 19 18:04 gpdatap2
[arpsdw1] 总用量 0
[arpsdw1] drwxrwxr-x 2 gpadmin gpadmin 6 2月 19 18:05 gpdatam1
[arpsdw1] drwxrwxr-x 2 gpadmin gpadmin 6 2月 19 18:05 gpdatam2
[arpsdw1] drwxrwxr-x 2 gpadmin gpadmin 6 2月 19 18:04 gpdatap1
[arpsdw1] drwxrwxr-x 2 gpadmin gpadmin 6 2月 19 18:04 gpdatap2
[arpsdw3] 总用量 0
[arpsdw3] drwxrwxr-x 2 gpadmin gpadmin 6 2月 19 18:05 gpdatam1
[arpsdw3] drwxrwxr-x 2 gpadmin gpadmin 6 2月 19 18:05 gpdatam2
[arpsdw3] drwxrwxr-x 2 gpadmin gpadmin 6 2月 19 18:04 gpdatap1
[arpsdw3] drwxrwxr-x 2 gpadmin gpadmin 6 2月 19 18:05 gpdatap212 master节点:配置环境变量
su - gpadmin
环境变量设置:
source /usr/local/greenplum-db/greenplum_path.sh
export MASTER_DATA_DIRECTORY=/data/gpdata/gpmaster/gpseg-1
export PGPORT=2345
export PGDATABASE=testDB13 初始化Greenplum的配置文件
$GPHOME/docs/cli_help/gpconfigs
# FILE NAME: gpinitsystem_config
# Configuration file needed by the gpinitsystem
################################################
#### REQUIRED PARAMETERS
################################################
#### Name of this Greenplum system enclosed in quotes.
ARRAY_NAME="Greenplum Data Platform"
#### Naming convention for utility-generated data directories.
SEG_PREFIX=gpseg
#### Base number by which primary segment port numbers
#### are calculated.
PORT_BASE=33000
#### File system location(s) where primary segment data directories
#### will be created. The number of locations in the list dictate
#### the number of primary segments that will get created per
#### physical host (if multiple addresses for a host are listed in
#### the hostfile, the number of segments will be spread evenly across
#### the specified interface addresses).
declare -a DATA_DIRECTORY=(/data/gpdata/gpdatap1 /data/gpdata/gpdatap2)
#### OS-configured hostname or IP address of the master host.
MASTER_HOSTNAME=arpmdw
#### File system location where the master data directory
#### will be created.
MASTER_DIRECTORY=/data/gpdata/gpmaster
#### Port number for the master instance.
MASTER_PORT=2345
#### Shell utility used to connect to remote hosts.
TRUSTED_SHELL=ssh
#### Maximum log file segments between automatic WAL checkpoints.
CHECK_POINT_SEGMENTS=8
#### Default server-side character set encoding.
ENCODING=UNICODE
################################################
#### OPTIONAL MIRROR PARAMETERS
################################################
#### Base number by which mirror segment port numbers
#### are calculated.
MIRROR_PORT_BASE=43000
REPLICATION_PORT_BASE=34000
MIRROR_REPLICATION_PORT_BASE=44000
#### File system location(s) where mirror segment data directories
#### will be created. The number of mirror locations must equal the
#### number of primary locations as specified in the
#### DATA_DIRECTORY parameter.
declare -a MIRROR_DATA_DIRECTORY=(/data/gpdata/gpdatam1 /data/gpdata/gpdatam2)
################################################
#### OTHER OPTIONAL PARAMETERS
################################################
#### Create a database of this name after initialization.
#DATABASE_NAME=name_of_database
#### Specify the location of the host address file here instead of
#### with the the -h option of gpinitsystem.
MACHINE_LIST_FILE=/usr/local/greenplum-db/conf/seg_hosts14 初始化数据库
gpinitsystem -c cluster_configuration_file -s standby_master_host
-c 对应配置文件
-s 指定哪个是stanby的master。
[gpadmin@arpmdw gpconfigs]$ pwd
/usr/local/greenplum-db/docs/cli_help/gpconfigs
gpinitsystem -c gpinitsystem_config
因为有standby，所以standby必须安装/data/gpdata/gpmaster 目录。安装的部署日志:
[gpadmin@arpmdw gpdata]$ gpinitsystem -c gpinitsystem_config -s arpsdw3
20200304:10:09:04:008914 gpinitsystem:arpmdw:gpadmin-[INFO]:-Checking configuration parameters, please wait...
20200304:10:09:04:008914 gpinitsystem:arpmdw:gpadmin-[FATAL]:-Configuration file gpinitsystem_config does not exist. Script Exiting!
[gpadmin@arpmdw gpdata]$ cd /usr/local/greenplum-db/docs/cli_help/gpconfigs
[gpadmin@arpmdw gpconfigs]$ gpinitsystem -c gpinitsystem_config -s arpsdw3
20200304:10:09:27:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Checking configuration parameters, please wait...
20200304:10:09:27:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Reading Greenplum configuration file gpinitsystem_config
20200304:10:09:27:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Locale has not been set in gpinitsystem_config, will set to default value
20200304:10:09:27:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Locale set to en_US.utf8
20200304:10:09:27:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-No DATABASE_NAME set, will exit following template1 updates
20200304:10:09:27:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-MASTER_MAX_CONNECT not set, will set to default value 250
20200304:10:09:28:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Checking configuration parameters, Completed
20200304:10:09:28:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Commencing multi-home checks, please wait...
...
20200304:10:09:29:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Configuring build for standard array
20200304:10:09:29:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Commencing multi-home checks, Completed
20200304:10:09:29:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Building primary segment instance array, please wait...
......
20200304:10:09:33:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Building group mirror array type , please wait...
......
20200304:10:09:37:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Checking Master host
20200304:10:09:37:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Checking new segment hosts, please wait...
............
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Checking new segment hosts, Completed
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Greenplum Database Creation Parameters
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:---------------------------------------
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Master Configuration
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:---------------------------------------
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Master instance name = Greenplum Data Platform
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Master hostname = arpmdw
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Master port = 2345
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Master instance dir = /data/gpdata/gpmaster/gpseg-1
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Master LOCALE = en_US.utf8
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Greenplum segment prefix = gpseg
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Master Database =
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Master connections = 250
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Master buffers = 128000kB
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Segment connections = 750
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Segment buffers = 128000kB
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Checkpoint segments = 8
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Encoding = UNICODE
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Postgres param file = Off
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Initdb to be used = /usr/local/greenplum-db/./bin/initdb
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-GP_LIBRARY_PATH is = /usr/local/greenplum-db/./lib
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-HEAP_CHECKSUM is = on
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-HBA_HOSTNAMES is = 0
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Ulimit check = Passed
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Array host connect type = Single hostname per node
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Master IP address [1] = ::1
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Master IP address [2] = 172.30.200.100
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Master IP address [3] = fe80::250:56ff:fea3:52aa
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Standby Master = arpsdw3
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Number of primary segments = 2
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Standby IP address = ::1
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Standby IP address = 172.30.200.103
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Standby IP address = fe80::250:56ff:fea3:35b9
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Total Database segments = 6
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Trusted shell = ssh
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Number segment hosts = 3
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Mirror port base = 43000
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Number of mirror segments = 2
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Mirroring config = ON
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Mirroring type = Group
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:----------------------------------------
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Greenplum Primary Segment Configuration
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:----------------------------------------
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-arpsdw1 /data/gpdata/gpdatap1/gpseg033000 2 0
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-arpsdw1 /data/gpdata/gpdatap2/gpseg133001 3 1
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-arpsdw2 /data/gpdata/gpdatap1/gpseg233000 4 2
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-arpsdw2 /data/gpdata/gpdatap2/gpseg333001 5 3
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-arpsdw3 /data/gpdata/gpdatap1/gpseg433000 6 4
20200304:10:09:54:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-arpsdw3 /data/gpdata/gpdatap2/gpseg533001 7 5
20200304:10:09:55:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:---------------------------------------
20200304:10:09:55:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-Greenplum Mirror Segment Configuration
20200304:10:09:55:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:---------------------------------------
20200304:10:09:55:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-arpsdw2 /data/gpdata/gpdatam1/gpseg043000 8 0
20200304:10:09:55:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-arpsdw2 /data/gpdata/gpdatam2/gpseg143001 9 1
20200304:10:09:55:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-arpsdw3 /data/gpdata/gpdatam1/gpseg243000 10 2
20200304:10:09:55:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-arpsdw3 /data/gpdata/gpdatam2/gpseg343001 11 3
20200304:10:09:55:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-arpsdw1 /data/gpdata/gpdatam1/gpseg443000 12 4
20200304:10:09:55:009095 gpinitsystem:arpmdw:gpadmin-[INFO]:-arpsdw1 /data/gpdata/gpdatam2/gpseg543001 13 5
Continue with Greenplum creation Yy|Nn (default=N):上述选择Y
如果后面出现，如下日志说明安装成功。
[gpadmin@arpmdw ~]$ cd /usr/local/greenplum-db/docs/cli_help/gpconfigs
[gpadmin@arpmdw gpconfigs]$ gpinitsystem -c gpinitsystem_config
20200304:11:47:47:005603 gpinitsystem:arpmdw:gpadmin-[INFO]:-Checking configuration parameters, please wait...
20200304:11:47:47:005603 gpinitsystem:arpmdw:gpadmin-[INFO]:-Reading Greenplum configuration file gpinitsystem_config
20200304:11:47:47:005603 gpinitsystem:arpmdw:gpadmin-[INFO]:-Locale has not been set in gpinitsystem_config, will set to default value
20200304:11:47:47:005603 gpinitsystem:arpmdw:gpadmin-[INFO]:-Locale set to en_US.utf8
20200304:11:47:47:005603 gpinitsystem:arpmdw:gpadmin-[FATAL]:-Master host data directory /data/gpdata/gpmaster/gpseg-1 already exists Script Exiting!
[gpadmin@arpmdw gpconfigs]$ rm -rf /data/gpdata/gpmaster/gpseg-*
[gpadmin@arpmdw gpconfigs]$ gpinitsystem -c gpinitsystem_config
20200304:11:48:10:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Checking configuration parameters, please wait...
20200304:11:48:10:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Reading Greenplum configuration file gpinitsystem_config
20200304:11:48:10:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Locale has not been set in gpinitsystem_config, will set to default value
20200304:11:48:10:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Locale set to en_US.utf8
20200304:11:48:10:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-No DATABASE_NAME set, will exit following template1 updates
20200304:11:48:10:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-MASTER_MAX_CONNECT not set, will set to default value 250
20200304:11:48:10:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Checking configuration parameters, Completed
20200304:11:48:10:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Commencing multi-home checks, please wait...
...
20200304:11:48:11:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Configuring build for standard array
20200304:11:48:11:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Commencing multi-home checks, Completed
20200304:11:48:11:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Building primary segment instance array, please wait...
......
20200304:11:48:15:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Checking Master host
20200304:11:48:15:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Checking new segment hosts, please wait...
......
20200304:11:48:26:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Checking new segment hosts, Completed
20200304:11:48:26:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Greenplum Database Creation Parameters
20200304:11:48:26:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:---------------------------------------
20200304:11:48:26:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Master Configuration
20200304:11:48:26:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:---------------------------------------
20200304:11:48:26:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Master instance name = Greenplum Data Platform
20200304:11:48:26:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Master hostname = arpmdw
20200304:11:48:26:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Master port = 2345
20200304:11:48:26:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Master instance dir = /data/gpdata/gpmaster/gpseg-1
20200304:11:48:26:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Master LOCALE = en_US.utf8
20200304:11:48:26:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Greenplum segment prefix = gpseg
20200304:11:48:26:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Master Database =
20200304:11:48:26:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Master connections = 250
20200304:11:48:26:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Master buffers = 128000kB
20200304:11:48:26:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Segment connections = 750
20200304:11:48:26:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Segment buffers = 128000kB
20200304:11:48:26:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Checkpoint segments = 8
20200304:11:48:26:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Encoding = UNICODE
20200304:11:48:26:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Postgres param file = Off
20200304:11:48:26:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Initdb to be used = /usr/local/greenplum-db/./bin/initdb
20200304:11:48:26:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-GP_LIBRARY_PATH is = /usr/local/greenplum-db/./lib
20200304:11:48:26:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-HEAP_CHECKSUM is = on
20200304:11:48:26:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-HBA_HOSTNAMES is = 0
20200304:11:48:26:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Ulimit check = Passed
20200304:11:48:26:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Array host connect type = Single hostname per node
20200304:11:48:26:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Master IP address [1] = ::1
20200304:11:48:26:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Master IP address [2] = 172.30.200.100
20200304:11:48:26:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Master IP address [3] = fe80::250:56ff:fea3:52aa
20200304:11:48:26:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Standby Master = Not Configured
20200304:11:48:26:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Number of primary segments = 2
20200304:11:48:26:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Total Database segments = 6
20200304:11:48:26:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Trusted shell = ssh
20200304:11:48:26:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Number segment hosts = 3
20200304:11:48:26:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Mirroring config = OFF
20200304:11:48:26:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:----------------------------------------
20200304:11:48:26:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Greenplum Primary Segment Configuration
20200304:11:48:26:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:----------------------------------------
20200304:11:48:26:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-arpsdw1 /data/gpdata/gpdatap1/gpseg033000 2 0
20200304:11:48:26:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-arpsdw1 /data/gpdata/gpdatap2/gpseg133001 3 1
20200304:11:48:26:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-arpsdw2 /data/gpdata/gpdatap1/gpseg233000 4 2
20200304:11:48:26:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-arpsdw2 /data/gpdata/gpdatap2/gpseg333001 5 3
20200304:11:48:26:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-arpsdw3 /data/gpdata/gpdatap1/gpseg433000 6 4
20200304:11:48:26:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-arpsdw3 /data/gpdata/gpdatap2/gpseg533001 7 5
Continue with Greenplum creation Yy|Nn (default=N):
> Y
20200304:11:48:30:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Building the Master instance database, please wait...
20200304:11:48:39:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Starting the Master in admin mode
20200304:11:48:42:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Commencing parallel build of primary segment instances
20200304:11:48:42:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Spawning parallel processes batch [1], please wait...
......
20200304:11:48:42:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Waiting for parallel processes batch [1], please wait...
..................
20200304:11:49:01:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:------------------------------------------------
20200304:11:49:01:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Parallel process exit status
20200304:11:49:01:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:------------------------------------------------
20200304:11:49:01:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Total processes marked as completed = 6
20200304:11:49:01:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Total processes marked as killed = 0
20200304:11:49:01:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Total processes marked as failed = 0
20200304:11:49:01:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:------------------------------------------------
20200304:11:49:01:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Deleting distributed backout files
20200304:11:49:01:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Removing back out file
20200304:11:49:01:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-No errors generated from parallel processes
20200304:11:49:01:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Restarting the Greenplum instance in production mode
20200304:11:49:01:009748 gpstop:arpmdw:gpadmin-[INFO]:-Starting gpstop with args: -a -l /home/gpadmin/gpAdminLogs -m -d /data/gpdata/gpmaster/gpseg-1
20200304:11:49:01:009748 gpstop:arpmdw:gpadmin-[INFO]:-Gathering information and validating the environment...
20200304:11:49:01:009748 gpstop:arpmdw:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20200304:11:49:01:009748 gpstop:arpmdw:gpadmin-[INFO]:-Obtaining Segment details from master...
20200304:11:49:01:009748 gpstop:arpmdw:gpadmin-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 6.2.1 build commit:d90ac1a1b983b913b3950430d4d9e47ee8827fd4'
20200304:11:49:01:009748 gpstop:arpmdw:gpadmin-[INFO]:-Commencing Master instance shutdown with mode='smart'
20200304:11:49:01:009748 gpstop:arpmdw:gpadmin-[INFO]:-Master segment instance directory=/data/gpdata/gpmaster/gpseg-1
20200304:11:49:01:009748 gpstop:arpmdw:gpadmin-[INFO]:-Stopping master segment and waiting for user connections to finish ...
server shutting down
20200304:11:49:02:009748 gpstop:arpmdw:gpadmin-[INFO]:-Attempting forceful termination of any leftover master process
20200304:11:49:02:009748 gpstop:arpmdw:gpadmin-[INFO]:-Terminating processes for segment /data/gpdata/gpmaster/gpseg-1
20200304:11:49:02:009748 gpstop:arpmdw:gpadmin-[ERROR]:-Failed to kill processes for segment /data/gpdata/gpmaster/gpseg-1: ([Errno 3] No such process)
20200304:11:49:03:009772 gpstart:arpmdw:gpadmin-[INFO]:-Starting gpstart with args: -a -l /home/gpadmin/gpAdminLogs -d /data/gpdata/gpmaster/gpseg-1
20200304:11:49:03:009772 gpstart:arpmdw:gpadmin-[INFO]:-Gathering information and validating the environment...
20200304:11:49:03:009772 gpstart:arpmdw:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 6.2.1 build commit:d90ac1a1b983b913b3950430d4d9e47ee8827fd4'
20200304:11:49:03:009772 gpstart:arpmdw:gpadmin-[INFO]:-Greenplum Catalog Version: '301908232'
20200304:11:49:03:009772 gpstart:arpmdw:gpadmin-[INFO]:-Starting Master instance in admin mode
20200304:11:49:03:009772 gpstart:arpmdw:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20200304:11:49:03:009772 gpstart:arpmdw:gpadmin-[INFO]:-Obtaining Segment details from master...
20200304:11:49:03:009772 gpstart:arpmdw:gpadmin-[INFO]:-Setting new master era
20200304:11:49:03:009772 gpstart:arpmdw:gpadmin-[INFO]:-Master Started...
20200304:11:49:03:009772 gpstart:arpmdw:gpadmin-[INFO]:-Shutting down master
20200304:11:49:04:009772 gpstart:arpmdw:gpadmin-[INFO]:-Commencing parallel segment instance startup, please wait...
.
20200304:11:49:05:009772 gpstart:arpmdw:gpadmin-[INFO]:-Process results...
20200304:11:49:05:009772 gpstart:arpmdw:gpadmin-[INFO]:-----------------------------------------------------
20200304:11:49:05:009772 gpstart:arpmdw:gpadmin-[INFO]:- Successful segment starts = 6
20200304:11:49:05:009772 gpstart:arpmdw:gpadmin-[INFO]:- Failed segment starts = 0
20200304:11:49:05:009772 gpstart:arpmdw:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 0
20200304:11:49:05:009772 gpstart:arpmdw:gpadmin-[INFO]:-----------------------------------------------------
20200304:11:49:05:009772 gpstart:arpmdw:gpadmin-[INFO]:-Successfully started 6 of 6 segment instances
20200304:11:49:05:009772 gpstart:arpmdw:gpadmin-[INFO]:-----------------------------------------------------
20200304:11:49:05:009772 gpstart:arpmdw:gpadmin-[INFO]:-Starting Master instance arpmdw directory /data/gpdata/gpmaster/gpseg-1
20200304:11:49:05:009772 gpstart:arpmdw:gpadmin-[INFO]:-Command pg_ctl reports Master arpmdw instance active
20200304:11:49:05:009772 gpstart:arpmdw:gpadmin-[INFO]:-Connecting to dbname='template1' connect_timeout=15
20200304:11:49:06:009772 gpstart:arpmdw:gpadmin-[INFO]:-No standby master configured. skipping...
20200304:11:49:06:009772 gpstart:arpmdw:gpadmin-[INFO]:-Database successfully started
20200304:11:49:06:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Completed restart of Greenplum instance in production mode
20200304:11:49:06:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Scanning utility log file for any warning messages
20200304:11:49:06:005855 gpinitsystem:arpmdw:gpadmin-[WARN]:-*******************************************************
20200304:11:49:06:005855 gpinitsystem:arpmdw:gpadmin-[WARN]:-Scan of log file indicates that some warnings or errors
20200304:11:49:06:005855 gpinitsystem:arpmdw:gpadmin-[WARN]:-were generated during the array creation
20200304:11:49:06:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Please review contents of log file
20200304:11:49:06:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-/home/gpadmin/gpAdminLogs/gpinitsystem_20200304.log
20200304:11:49:06:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-To determine level of criticality
20200304:11:49:06:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-These messages could be from a previous run of the utility
20200304:11:49:06:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-that was called today!
20200304:11:49:06:005855 gpinitsystem:arpmdw:gpadmin-[WARN]:-*******************************************************
20200304:11:49:06:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Greenplum Database instance successfully created
20200304:11:49:06:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-------------------------------------------------------
20200304:11:49:06:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-To complete the environment configuration, please
20200304:11:49:06:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-update gpadmin .bashrc file with the following
20200304:11:49:06:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-1. Ensure that the greenplum_path.sh file is sourced
20200304:11:49:06:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-2. Add "export MASTER_DATA_DIRECTORY=/data/gpdata/gpmaster/gpseg-1"
20200304:11:49:06:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:- to access the Greenplum scripts for this instance:
20200304:11:49:06:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:- or, use -d /data/gpdata/gpmaster/gpseg-1 option for the Greenplum scripts
20200304:11:49:06:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:- Example gpstate -d /data/gpdata/gpmaster/gpseg-1
20200304:11:49:06:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Script log file = /home/gpadmin/gpAdminLogs/gpinitsystem_20200304.log
20200304:11:49:06:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-To remove instance, run gpdeletesystem utility
20200304:11:49:06:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-To initialize a Standby Master Segment for this Greenplum instance
20200304:11:49:06:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Review options for gpinitstandby
20200304:11:49:06:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-------------------------------------------------------
20200304:11:49:06:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-The Master /data/gpdata/gpmaster/gpseg-1/pg_hba.conf post gpinitsystem
20200304:11:49:06:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-has been configured to allow all hosts within this new
20200304:11:49:06:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-array to intercommunicate. Any hosts external to this
20200304:11:49:06:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-new array must be explicitly added to this file
20200304:11:49:06:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-Refer to the Greenplum Admin support guide which is
20200304:11:49:06:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-located in the /usr/local/greenplum-db/./docs directory
20200304:11:49:06:005855 gpinitsystem:arpmdw:gpadmin-[INFO]:-------------------------------------------------------里面有Greenplum Database instance successfully created,恭喜你成功。
手机扫一扫
移动阅读更方便
你可能感兴趣的文章