Greenplum 备忘

groupadd -g 530 gpadmin
useradd -g 530 -u 530 -m -d /home/gpadmin -s /bin/bash gpadmin
chown -R gpadmin:gpadmin /home/gpadmin
echo "gpadmin" | passwd --stdin gpadmin

mkdir -p /home/gpadmin/conf
vi /home/gpadmin/conf/hostlist

master
segment1
segment2

su - gpadmin
source /usr/local/greenplum-db/greenplum_path.sh
ssh-keygen
ssh-copy-id segment1
ssh-copy-id segment2
gpssh-exkeys -f /home/gpadmin/conf/hostlist

mkdir -p /opt/greenplum/data1/primary
mkdir -p /opt/greenplum/data1/mirror
mkdir -p /opt/greenplum/data2/primary
mkdir -p /opt/greenplum/data2/mirror
chown -R gpadmin /opt/greenplum/data*

gpinitsystem -c /home/gpadmin/gpconfigs/gpinitsystem_config -h /home/gpadmin/conf/seg_hosts -D

gpscp -f /home/gpadmin/conf/seg_hosts /home/gpadmin/.bash_profile gpadmin@=:/home/gpadmin/.bash_profile
gpscp -f /home/gpadmin/conf/seg_hosts /home/gpadmin/.bashrc gpadmin@=:/home/gpadmin/.bashrc
gpssh -f /home/gpadmin/conf/hostlist -e 'source /home/gpadmin/.bash_profile;source /home/gpadmin/.bashrc;'

psql -h 10.10.1.187 -p 6000 -d database -U root -W dsideal;

ALTER USER gpadmin WITH PASSWORD 'dsideal'