greenplum6.0单机安装测试

hostnamectl set-hostname gpdb6

vi /etc/hosts
127.0.0.1 gpdb6

groupadd -g 530 gpadmin
useradd -g 530 -u530 -m -d /home/gpadmin -s /bin/bash gpadmin
passwd gpadmin

vi /etc/sysctl.conf

kernel.shmmax = 500000000
kernel.shmmni = 4096
kernel.shmall = 4000000000
kernel.sem = 250 512000 100 2048
kernel.sysrq = 1
kernel.core_uses_pid = 1
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.msgmni = 2048
net.ipv4.tcp_syncookies = 1
net.ipv4.ip_forward = 0
net.ipv4.conf.default.accept_source_route = 0
net.ipv4.tcp_tw_recycle = 1
net.ipv4.tcp_max_syn_backlog = 4096
net.ipv4.conf.all.arp_filter = 1
net.ipv4.ip_local_port_range = 1025 65535
net.core.netdev_max_backlog = 10000
net.core.rmem_max = 2097152
net.core.wmem_max = 2097152
vm.overcommit_memory = 2

sysctl -p


vi /etc/security/limits.conf

* soft nofile 65536
* hard nofile 65536
* soft nproc 131072
* hard nproc 131072


vi /etc/selinux/config

SELINUX=disabled

systemctl stop firewalld.service
systemctl disable firewalld.service

rpm -Uvh greenplum-db-6.0.0-rhel7-x86_64.rpm 
yum install apr
yum install apr-util
yum install krb5-devel
rpm -Uvh greenplum-db-6.0.0-rhel7-x86_64.rpm 

chown -R gpadmin:gpadmin /usr/local/greenplum-db-6.0.0
chown -R gpadmin:gpadmin /usr/local/greenplum-db

mkdir -p /home/gpadmin/gpdata/gpmaster
mkdir -p /home/gpadmin/gpdata/gpdatap1
mkdir -p /home/gpadmin/gpdata/gpdatap2
mkdir -p /home/gpadmin/gpdata/gpdatap3
mkdir -p /home/gpadmin/gpdata/gpdatap4
mkdir -p /home/gpadmin/gpdata/gpdatap5
mkdir -p /home/gpadmin/gpdata/gpdatap6
mkdir -p /home/gpadmin/gpdata/gpdatap7
mkdir -p /home/gpadmin/gpdata/gpdatap8

mkdir -p /home/gpadmin/gpdata/gpdatam1
mkdir -p /home/gpadmin/gpdata/gpdatam2
mkdir -p /home/gpadmin/gpdata/gpdatam3
mkdir -p /home/gpadmin/gpdata/gpdatam4
mkdir -p /home/gpadmin/gpdata/gpdatam5
mkdir -p /home/gpadmin/gpdata/gpdatam6
mkdir -p /home/gpadmin/gpdata/gpdatam7
mkdir -p /home/gpadmin/gpdata/gpdatam8

vi /home/gpadmin/.bash_profile

source /usr/local/greenplum-db/greenplum_path.sh
export MASTER_DATA_DIRECTORY=/home/gpadmin/gpdata/gpmaster/gpseg-1
export PGPORT=5432
export PGDATABASE=postgres

vi /home/gpadmin/conf/seg_hosts
gpdb6


vi /home/gpadmin/conf/gpinitsystem_config

RRAY_NAME="Greenplum"
SEG_PREFIX=gpseg
PORT_BASE=33000
declare -a DATA_DIRECTORY=(/home/gpadmin/gpdata/gpdatap1  /home/gpadmin/gpdata/gpdatap2)
MASTER_HOSTNAME=gpdb6
MASTER_DIRECTORY=/home/gpadmin/gpdata/gpmaster
MASTER_PORT=5432
TRUSTED_SHELL=/usr/bin/ssh
MIRROR_PORT_BASE=43000
REPLICATION_PORT_BASE=34000
MIRROR_REPLICATION_PORT_BASE=44000
declare -a MIRROR_DATA_DIRECTORY=(/home/gpadmin/gpdata/gpdatam1 /home/gpadmin/gpdata/gpdatam2)
MACHINE_LIST_FILE=/home/gpadmin/conf/seg_hosts

source /usr/local/greenplum-db/greenplum_path.sh
gpinitsystem -c /home/gpadmin/conf/gpinitsystem_config -h /home/gpadmin/conf/seg_hosts

gpinitstandby -s smdw
gpinitsystem -c /home/gpadmin/conf/gpinitsystem_config -s gpdb6
./gpinitstandby -s gpdb6 -P 2345 -S /home/gpadmin/gpdata/gpstandby
./gpaddmirros
./gpaddmirros -i

vi /home/gpadmin/gpdata/gpmaster/gpseg-1/pg_hba.conf
host     all         gpadmin        192.168.184.0/24 md5
host all all 0.0.0.0/0 md5

psql -d postgres
psql -h gpdb6 -p 5432 -d postgres gpadmin -U gpadmin -W
alter role gpadmin PASSWORD 'gpadmin';

gpstop -a
gpstart -a