IP:11.111.111.11
vim /etc/hostname
master
#保存退出
IP:22.222.222.222
vim /etc/hostname
standby
#保存退出
IP:33.333.333.333
vim /etc/hostname
seg1
#保存退出
IP:44.444.444.444
vim /etc/hostname
seg2
#保存退出
IP:55.555.555.555
vim /etc/hostname
seg3
#保存退出
vim /home/gpadmin/gpconfigs/gpinitsystem_config
# 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.#p实例起始端口PORT_BASE=6000#### 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).#定义p实例的数据目录declare-aDATA_DIRECTORY=(/data/p1 /data/p2)#### OS-configured hostname or IP address of the master host.#这里写master的主机名MASTER_HOSTNAME=master
#### File system location where the master data directory #### will be created.#这里写master的数据目录路径MASTER_DIRECTORY=/data/master
#### Port number for the master instance. #定义gp数据库的端口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.#定义m实例的起始端口号#m指的是当p实例挂了,m自动接管p的工作,后续可通过gp的gprecover命令来恢复成pMIRROR_PORT_BASE=7000#### 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.#定义m实例的数据目录路径declare-aMIRROR_DATA_DIRECTORY=(/data/m1 /data/m2)#################################################### 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 -h option of gpinitsystem.#MACHINE_LIST_FILE=/home/gpadmin/gpconfigs/hostfile_gpinitsystem
#psql -h hostname -p port -d database -U user#-h后面接对应的master主机名或者ip#-p后面接的端口号5432#-d后面接数据库名默认有一个叫做postgres的#-u后面接用户,默认有gpadmin#在master服务器执行psql连接数据库是免密的#执行psql连接数据库
psql -h master -p5432-d postgres -U gpadmin
#执行赋权命令(用于给gpload装载外部表加操作权限)
alter role user CREATEEXTTABLE;#提示ALTER ROLE 成功#退出连接\q