greenplum 5.7 + gpinitsystem_config详解数据库

os: centos 7.4
gp: greenplum 5.7.0

# FILE NAME: gpinitsystem_config 
 
# Configuration file needed by the gpinitsystem 
 
################################################ 
#### REQUIRED PARAMETERS 
################################################ 
 
#### Name of this Greenplum system enclosed in quotes. 
ARRAY_NAME="test 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=40000 
 
#### 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=(/u01/greenplum-data) 
 
#### OS-configured hostname or IP address of the master host. 
MASTER_HOSTNAME=node1 
 
#### File system location where the master data directory  
#### will be created. 
MASTER_DIRECTORY=/u01/greenplum-data 
 
#### Port number for the master instance.  
MASTER_PORT=5432 
 
#### 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=50000 
 
#### Base number by which primary file replication port  
#### numbers are calculated. 
#REPLICATION_PORT_BASE=41000 
 
#### Base number by which mirror file replication port  
#### numbers are calculated.  
#MIRROR_REPLICATION_PORT_BASE=51000 
 
#### 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=(/data1/mirror /data1/mirror /data1/mirror /data2/mirror /data2/mirror /data2/mirror) 
 
 
################################################ 
#### OTHER OPTIONAL PARAMETERS 
################################################ 
 
#### Create a database of this name after initialization. 
DATABASE_NAME=peiybdb 
 
#### 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/all_segment

简单说明下
ARRAY_NAME：设置阵列名称，默认EMC Greenplum DW。
SEG_PREFIX：设置segment的前缀，默认gpseg。
PORT_BASE：设置segment的起始端口，会从此端口往上增加，默认从40000开始。
DATA_DIRECTORY：设置segment primary的数据存储目录，控制每个机器上segment实例个数。
MASTER_HOSTNAME：设置master的主机名。
MASTER_DIRECTORY：设置master的存储目录。
MASTER_PORT：设置master的端口，默认5432。
TRUSTED_SHELL：设置节点之间的信任方式，默认SSH。
CHECK_POINT_SEGMENTS：预写日志文件（WAL）数量，默认为8，这意味着为主机上的每个Segment或Master实例分配1088MB的WAL空间。
ENCODING=UNICODE：设置初始字符集，默认UNICODE（UTF-8）。
MACHINE_LIST_FILE：仅包含segment主机地址
注意，其中所有需要的目录都是在创建数据存储区域时做好的。