Greenplum stand-alone installation
Environment:
Server version: centos 6.5
Database version: greenplum-db-4.2.8.5-build-1-RHEL5-x86_64.zip
1. Create user and group gpadmin
Groupadd-g 3030 gpadmin
Useradd-u 3030 gpadmin-g gpadmin-d / home/gpadmin
Passwd gpadmin
Configure kernel parameters and add the following:
Vi / etc/sysctl.conf
# By greenplum
Net.ipv4.ip_forward = 0
Net.ipv4.conf.default.accept_source_route = 0
Kernel.sysrq = 1
Kernel.core_uses_pid = 1
Net.ipv4.tcp_syncookies = 1
Kernel.msgmnb = 65536
Kernel.msgmax = 65536
Kernel.sem = 250 64000 100 512
Kernel.shmmax = 500000000
Kernel.shmmni = 4096
Kernel.shmall = 4000000000
Kernel.sem = 250 64000 100 512
Net.ipv4.tcp_tw_recycle=1
Net.ipv4.tcp_max_syn_backlog=4096
Net.core.netdev_max_backlog=10000
Vm.overcommit_memory=2
Net.ipv4.conf.all.arp_filter = 1
The above parameters can be modified according to your own system configuration.
Execute the command manually to make the parameter take effect
[root@gpmaster] # sysctl-p
Add the following configuration to the limits.conf file
[root@gpmaster ~] # vi / etc/security/limits.conf
# End of file
* soft nofile 65536
* hard nofile 65536
* soft nproc 131072
* hard nproc 131072
Configure users ssh users log in without password, stand-alone must also be configured
[root@gpmaster ~] # su-gpadmin
[gpadmin@gpmaster] $mkdir ~ / .ssh
[gpadmin@gpmaster] $chmod 700 ~ / .ssh
[gpadmin@gpmaster ~] $cd .ssh /
[gpadmin@gpmaster .ssh] $ssh-keygen-t rsa
[gpadmin@gpmaster .ssh] $ssh gpmaster cat / home/gpadmin/.ssh/id_rsa.pub > > authorized_keys
[gpadmin@gpmaster .ssh] $chmod 600 authorized_keys
[gpadmin@gpmaster .ssh] $ssh gpmaster date
two。 Install GP softwar
[root@gpmaster ~] # unzip greenplum-db-4.2.8.5-build-1-RHEL5-x86_64.zip
[root@gpmaster ~] #. / greenplum-db-4.2.8.5-build-1-RHEL5-x86_64.bin
Create the directories required by instance
[root@gpmaster] # mkdir-p / app/master
[root@gpmaster] # mkdir-p / app/data/gp1
[root@gpmaster] # mkdir-p / app/data/gp2
[root@gpmaster] # mkdir-p / app/data/gp3
[root@gpmaster] # mkdir-p / app/data/gp4
Modify the directory owner:
[root@gpmaster] # chown-R gpadmin:gpadmin / usr/local/greenplum-db*
[root@gpmaster] # chown-R gpadmin:gpadmin / app/master
[root@gpmaster] # chown-R gpadmin:gpadmin / app/data/gp1
[root@gpmaster] # chown-R gpadmin:gpadmin / app/data/gp2
[root@gpmaster] # chown-R gpadmin:gpadmin / app/data/gp3
[root@gpmaster] # chown-R gpadmin:gpadmin / app/data/gp4
Modify the gpadmin user environment configuration:
[root@gpmaster ~] # su-gpadmin
[gpadmin@gpmaster ~] $vi .bash _ profile
Source / usr/local/greenplum-db/greenplum_path.sh
Export MASTER_DATA_DIRECTORY=/app/master/gpseg-1
Export PGPORT=5432
Export PGUSER=gpadmin
Export PGDATABASE=gpmaster
Effective:
[gpadmin@gpmaster ~] $source .bash _ profile
Edit the all_hosts_file file and add the following:
[gpadmin@gpmaster ~] $vi all_hosts_file
Gpmaster
Execute the following command to verify user equivalence
[gpadmin@gpmaster] $gpssh-exkeys-f all_hosts_file
3. Initialize the system:
Edit the parameter file initialized by the system. You can use the template for editing this file. The template file is located in the following directory:
[gpadmin@gpmaster ~] $cp / usr/local/greenplum-db/docs/cli_help/gpconfigs/gpinitsystem_config / home/gpadmin/
Edit the gp parameter file and modify the configuration as follows:
[gpadmin@gpmaster ~] $vi gpinitsystem_config
Declare-a DATA_DIRECTORY= (/ app/data/gp1 / app/data/gp2 / app/data/gp3 / app/data/gp4)
MASTER_HOSTNAME=gpmaster
MASTER_DIRECTORY=/app/master
DATABASE_NAME=gpmaster
Edit the seg_hosts_file file
[gpadmin@gpmaster ~] $vi seg_hosts_file
Gpmaster
Execute the initialization system command:
[gpadmin@gpmaster] $gpinitsystem-c gpinitsystem_config-h seg_hosts_file
The system initializes, and then you will see the following prompt:
Continue with Greenplum creation Yy/Nn >
Enter Y, press enter, and the system will be initialized.
After installation, you can connect to the GP database:
[gpadmin@gpmaster] $psql-d gpmaster
Psql (8.2.15)
Type "help" for help.
Gpmaster=#
Create a database
[gpadmin@gpmaster ~] $createdb testDB-E utf-8
Give permissions to the database
[gpadmin@gpmaster] $psql-d gpmaster
Psql (8.2.15)
Type "help" for help.
Gpmaster=#\ c testDB
You are now connected to database "testDB" as user "gpadmin".
TestDB=# alter role gpadmin with password 'gpadmin'
Remote permission
[gpadmin@gpmaster ~] $cd $MASTER_DATA_DIRECTORY/
[gpadmin@gpmaster gpseg-1] $ls
Base pg_distributedlog pg_stat_tmp pg_xlog
Global pg_distributedxidmap pg_subtrans postgresql.conf
Gp_dbid pg_hba.conf pg_tblspc postmaster.opts
Gpperfmon pg_ident.conf pg_twophase postmaster.pid
Pg_changetracking pg_log pg_utilitymodedtmredo
Pg_clog pg_multixact PG_VERSION
[gpadmin@gpmaster gpseg-1] $
[gpadmin@gpmaster gpseg-1] $vi pg_hba.conf
Host testDB gpadmin 192.168.96.1/32 md5
Use the gpstop-u command to make the configuration effective
[gpadmin@gpmaster gpseg-1] $gpstop-u
Log in to the database through other machines
$psql-h292.168.96.128-p5432-d testDB-Ugpadmin
