Greenplum Database Installation Master on RHEL 5

set /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
vm.overcommit_memory = 2

set /etc/security/limits.conf

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

set /etc/pam.d/login

session required pam_limits.so

set /etc/hosts

# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1               localhost.localdomain localhost
192.168.1.21 gp01
192.168.1.22 gp02
192.168.1.23 gp03

create group

groupadd gpadmin
useradd -g gpadmin gpadmin
passwd gpadmin

set gpadmin's .bash_profile

export LANG=en_US.utf8
export GPHOME=/gpdata/greenplum-db-4.2.3.1
export PATH=$GPHOME/bin:$GPHOME/ext/python/bin:$PATH
export LD_LIBRARY_PATH=$GPHOME/lib:$GPHOME/ext/python/lib:$LD_LIBRARY_PATH
export PYTHONPATH=$GPHOME/lib/python
export PYTHONHOME=$GPHOME/ext/python
export PGPORT=1527
export MASTER_DATA_DIRECTORY=/database/gp_master/gp-1

install

[root@gp01 ~]# ./greenplum-db-4.2.3.1-build-2-RHEL5-x86_64.bin 

********************************************************************************
Do you accept the Greenplum Database license agreement? [yes|no]
********************************************************************************

yes

********************************************************************************
Provide the installation path for Greenplum Database or press ENTER to 
accept the default installation path: /usr/local/greenplum-db-4.2.3.1
********************************************************************************

/gpdata/greenplum-db-4.2.3.1

********************************************************************************
Install Greenplum Database into </gpdata/greenplum-db-4.2.3.1>? [yes|no]
********************************************************************************

yes

********************************************************************************
/gpdata/greenplum-db-4.2.3.1 does not exist.
Create /gpdata/greenplum-db-4.2.3.1 ? [yes|no]
(Selecting no will exit the installer)
********************************************************************************

yes

********************************************************************************
[Optional] Provide the path to a previous installation of Greenplum Database,
or press ENTER to skip this step. e.g. /usr/local/greenplum-db-4.1.1.3

This installation step will migrate any Greenplum Database extensions from the
provided path to the version currently being installed. This step is optional 
and can be run later with: 
gppkg --migrate <path_to_old_gphome> /gpdata/greenplum-db-4.2.3.1
********************************************************************************



Extracting product to /gpdata/greenplum-db-4.2.3.1


Skipping migration of Greenplum Database extensions...

********************************************************************************
Installation complete.
Greenplum Database is installed in /gpdata/greenplum-db-4.2.3.1

Greenplum Database documentation is available for download
at http://powerlink.emc.com.
********************************************************************************



[root@gp01 ~]# cd /gpdata/
[root@gp01 gpdata]# ll
total 8
lrwxrwxrwx  1 root    root      22 Sep 16 17:25 greenplum-db -> ./greenplum-db-4.2.3.1
drwxr-xr-x 11 root    root    4096 Sep 16 17:25 greenplum-db-4.2.3.1
-rw-rw-r--  1 gpadmin gpadmin   15 Sep 16 17:12 sshkey_hostname
[root@gp01 gpdata]# chown -R gpadmin.gpadmin greenplum-db-4.2.3.1
[root@gp01 gpdata]# ll
total 8
lrwxrwxrwx  1 root    root      22 Sep 16 17:25 greenplum-db -> ./greenplum-db-4.2.3.1
drwxr-xr-x 11 gpadmin gpadmin 4096 Sep 16 17:25 greenplum-db-4.2.3.1
-rw-rw-r--  1 gpadmin gpadmin   15 Sep 16 17:12 sshkey_hostname

set ssh_key file

[gpadmin@gp01 gpdata]$ cat ssh_key
gp01
gp02
gp03

[root@gp01 ~]# gpssh-exkeys -f /gpdata/greenplum-db/cfg/ssh_key 
[STEP 1 of 5] create local ID and authorize on local host

[STEP 2 of 5] keyscan all hosts and update known_hosts file

[STEP 3 of 5] authorize current user on remote hosts
  ... send to gp02
  ***
  *** Enter password for gp02: 
  ... send to gp03

[STEP 4 of 5] determine common authentication file content

[STEP 5 of 5] copy authentication files to all remote hosts
  ... finished key exchange with gp02
  ... finished key exchange with gp03

[INFO] completed successfully
[root@gp01 ~]# 
[root@gp01 ~]# su - gpadmin
[gpadmin@gp01 ~]$ gpssh-exkeys -f /gpdata/greenplum-db/cfg/ssh_key 
[STEP 1 of 5] create local ID and authorize on local host

[STEP 2 of 5] keyscan all hosts and update known_hosts file

[STEP 3 of 5] authorize current user on remote hosts
  ... send to gp02
  ***
  *** Enter password for gp02: 
  ... send to gp03

[STEP 4 of 5] determine common authentication file content

[STEP 5 of 5] copy authentication files to all remote hosts
  ... finished key exchange with gp02
  ... finished key exchange with gp03

[INFO] completed successfully