greenplum 5.7 + gpadmin 用户的一些设置详解数据库

创建 greenplum 组

# groupadd -g 10000 gpadmin

创建 greenplum 用户

# useradd -u 10000 -g gpadmin gpadmin 
# usermod -G root gpadmin 
# passwd gpadmin

创建 greenplum 软件目录

# mkdir -p /usr/local/greenplum-db 
# chown -R gpadmin:gpadmin /usr/local/greenplum-db

创建 greenplum 数据目录

# mkdir -p /u01/greenplum-data/ 
# chown -R gpadmin:gpadmin /u01

修改 .bash_profile .bashrc 文件
master 节点

# vi /home/gpadmin/.bash_profile 
source /usr/local/greenplum-db/greenplum_path.sh 
export MASTER_DATA_DIRECTORY=/u01/greenplum-data/gpseg-1 
 
# vi /home/gpadmin/.bashrc 
source /usr/local/greenplum-db/greenplum_path.sh 
export MASTER_DATA_DIRECTORY=/u01/greenplum-data/gpseg-1

segment 节点

# vi /home/gpadmin/.bash_profile 
source /usr/local/greenplum-db/greenplum_path.sh 
 
# vi /home/gpadmin/.bashrc 
source /usr/local/greenplum-db/greenplum_path.sh