1、获取安装包
Download VMware Greenplum® — VMware Tanzu Network
2.安装
yum -y install greenplum-db-6.0.0-rhel7-x86_64.rpm
3.创建gpadmin用户
-
useradd gpadmin
-
passwd gpadmin
4.修改安装目录的权限
-
chown -R gpadmin.gpadmin /usr/local/greenplum-db*
-
chown gpadmin.gpadmin /usr/local
5.创建数据目录并给gpadmin赋权限
-
mkdir -p /data/{primary,mirror,master}
-
chown -R gpadmin.gpadmin /data/{primary,mirror,master}
6.切换到gpadmin用户下,并在用户目录中执行以下操作:添加本机hostname
-
vi list
-
node2
7.添加环境变量--做免密
gpssh-exkeys -f list
$ cat /usr/local/greenplum-db/greenplum_path.sh >>~/.bashrc
$ cat >> ~/.bashrc <<EOF
MASTER_DATA_DIRECTORY=/data/master/gpseg-1
export MASTER_DATA_DIRECTORY
EOF
source ~/.bashrc
cp /usr/local/greenplum-db/docs/cli_help/gpconfigs/gpinitsystem_config /home/gpadmin/gpinitsystem_config
chmod 775 /home/gpadmin/gpinitsystem_config
vi /home/gpadmin/gpinitsystem_config #对配置进行修改
## 数据文件的位置
declare -a DATA_DIRECTORY=(/data/primary)
MASTER_HOSTNAME=node1
MASTER_DIRECTORY=/data/master
MIRROR_PORT_BASE=7000
declare -a MIRROR_DATA_DIRECTORY=(/data/mirror)
7.初始化数据库--
注意:此步骤时间较长,请耐心等待,如果出现输入密码的,是要做免密
gpinitsystem -a -c gpinitsystem_config -h list
8.登录psql -d postgres -p 5432
9.开启远程访问
vi /data/master/gpseg-1/pg_hba.conf
10.重启生效
-
gpstop
-
-
gpstart
alter role gpadmin password 'gpadmin'
然后可以用工具连接了