创建用户 : groupadd -g 530 gpadmin
useradd -g 530 -u 530 -m -d /home/gpadmin -s /bin/bash gpadmin
对文件夹进行赋权,为新用户创建密码:
chown -R gpadmin:gpadmin /home/gpadmin/
passwd gpadmin
vim /etc/hosts
192.168.10.1 mdw
192.168.10.2 sdw1
192.168.10.3 sdw2
192.168.10.4 sdw3
rpm -ivh --prefix=/opt/greenplum/ open-source-greenplum-db-6.16.0-rhel7-x86_64.rpm
chown -R gpadmin:gpamdin /opt/gpadmin
cd /opt/greenplum
vi hostlist
mdw
sdw1
sdw2
sdw3
vi seg_host
192.168.10.2
192.168.10.3
192.168.10.4
su gpadmin
source /opt/greenplum/greenplum-db/greenplum_path.sh
gpssh-exkeys -f /home/gpadmin/conf/hostlist
alias ssh='ssh -p 9922'
ssh sdw1
gpssh -f /home/gpadmin/conf/seg_hosts
=> pwd
[gp-sdw1] /home/gpadmin
[gp-sdw3] /home/gpadmin
[gp-sdw2] /home/gpadmin
[ gp-master] /home/gpadmin
chown -R gpadmin:gpadmin /usr/local/
chown -R gpadmin:gpadmin /opt
tar -cf gp.tar greenplum-db-5.0.0/
source /usr/local/ greenplum-db/greenplum_path.sh
gpssh -f /home/gpadmin/conf/hostlist
cd /usr/local
tar -xf gp.tar
ln -s ./greenplum-db-6.7.0 greenplum-db
mkdir -p /opt/greenplum/data/master
mkdir -p /opt/greenplum/data/primary
mkdir -p /opt/greenplum/data/mirror
mkdir -p /opt/greenplum/data2/primary
mkdir -p /opt/greenplum/data2/mirror
vi /home/gpadmin/.bash_profile
source /home/gpadmin/greenplum/greenplum-db/greenplum_path.sh
export MASTER_DATA_DIRECTORY=/home/gpadmin/greenplum/gpdata/gpmaster/gpseg-1
export PGPORT=15432
export GPPORT=15432
export PGDATABASE=testDB
source /home/gpadmin/.bash_profile
scp /home/gpadmin/.bash_profile gp-sdw1:/home/gpadmin/
scp /home/gpadmin/.bash_profile gp-sdw2:/home/gpadmin/
scp /home/gpadmin/.bash_profile gp-sdw3:/home/gpadmin/
gpinitsystem -c /home/gpadmin/gpinit_config -s sdw3
gpstate -e #查看mirror的状态
gpstate -f #查看standby master的状态
gpstate -s #查看整个GP群集的状态
gpstate -i #查看GP的版本
gpstate --help #帮助文档,可以查看gpstate更多用法