greenplum单节点安装

官方网址： https://greenplum.org 根据文档: Greenplum Installation => Platform Requirements => Software Dependencies  安装操作系统依赖包 yum install apr apr-util bash bzip2 curl krb5 libcurl libevent libxml2 libyaml zlib openldap openssh openssl openssl-libs perl readline rsync R sed tar zip gcc c++ 配置操作系统: Greenplum Installation => Configuring Your Systems 1.Make sure your host systems meet the requirements described in Platform Requirements. 2.Disable SELinux and firewall software. vi /etc/selinux/config SELINUX=disabled 3.Set the required operating system parameters. Set the parameters in the /etc/sysctl.conf file and reload with sysctl -p: # kernel.shmall = _PHYS_PAGES / 2 # See Shared Memory Pages kernel.shmall = 197951838 # kernel.shmmax = kernel.shmall * PAGE_SIZE  kernel.shmmax = 810810728448 kernel.shmmni = 4096 vm.overcommit_memory = 2 # See Segment Host Memory vm.overcommit_ratio = 95 # See Segment Host Memory net.ipv4.ip_local_port_range = 10000 65535 # See Port Settings kernel.sem = 500 2048000 200 4096 kernel.sysrq = 1 kernel.core_uses_pid = 1 kernel.msgmnb = 65536 kernel.msgmax = 65536 kernel.msgmni = 2048 net.ipv4.tcp_syncookies = 1 net.ipv4.conf.default.accept_source_route = 0 net.ipv4.tcp_max_syn_backlog = 4096 net.ipv4.conf.all.arp_filter = 1 net.core.netdev_max_backlog = 10000 net.core.rmem_max = 2097152 net.core.wmem_max = 2097152 vm.swappiness = 10 vm.zone_reclaim_mode = 0 vm.dirty_expire_centisecs = 500 vm.dirty_writeback_centisecs = 100 vm.dirty_background_ratio = 0 # See System Memory vm.dirty_ratio = 0 vm.dirty_background_bytes = 1610612736 vm.dirty_bytes = 4294967296 4.System Resources Limits Set the following parameters in the /etc/security/limits.conf file: * soft nofile 524288 * hard nofile 524288 * soft nproc 131072 * hard nproc 131072 5.IPC Object Removal Disable RemoveIPC. Set this parameter in /etc/systemd/logind.conf on the Greenplum Database host systems. RemoveIPC=no The setting takes effect after restarting the systemd-login service or rebooting the system. To restart the service, run this command as the root user. service systemd-logind restart 6.add gpadmin user # groupadd gpadmin # useradd gpadmin -r -m -g gpadmin # passwd gpadmin New password: <changeme> Retype new password: <changeme> 安装 greenplum 数据库软件 Greenplum Installation => Installing the Greenplum Database Software 1.Installing Greenplum Database rpm -ivh open-source-greenplum-db-6.15.0-rhel7-x86_64.rpm 2.Enabling Passwordless SSH Log in to the master host as the gpadmin user. Source the path file in the Greenplum Database installation directory. $ source /usr/local/greenplum-db-<version>/greenplum_path.sh Run the gpssh-exkeys utility with your hostfile_exkeys file to enable n-n passwordless SSH for the gpadmin user. $ gpssh-exkeys -f hostfile_exkeys 初始化 greenplum 数据库 Greenplum Installation => Initializing a Greenplum Database System 1.Creating the Greenplum Database Configuration File [gpadmin@gp1 greenplum-db]$ pwd /usr/local/greenplum-db [gpadmin@gp1 greenplum-db]$ cat gpinitsystem_configbak | grep ^[a-zA-Z] ARRAY_NAME="Greenplum" SEG_PREFIX=gpseg PORT_BASE=6000 declare -a DATA_DIRECTORY=(/home/gpadmin/gpdata/gp1 /home/gpadmin/gpdata/gp2 /home/gpadmin/gpdata/gp3 /home/gpadmin/gpdata/gp4) MASTER_HOSTNAME=gp1 MASTER_DIRECTORY=/home/gpadmin/gpdata/master MASTER_PORT=5432 TRUSTED_SHELL=ssh CHECK_POINT_SEGMENTS=8 ENCODING=UNICODE DATABASE_NAME=gpdb MACHINE_LIST_FILE=/usr/local/greenplum-db/hostlist 2.Running the Initialization Utility bin/gpinitsystem -c gpinitsystem_configbak -h hostlist 登录验证 [gpadmin@gp1 greenplum-db]$ psql -U gpadmin -d gpdb psql (9.4.24) Type "help" for help. gpdb=# select * from version();                                                                                                       version                                                                                                        --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------  PostgreSQL 9.4.24 (Greenplum Database 6.15.0 build commit:4e6288c9e9fca634b007a978fba3ce25aae26aed Open Source) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on  Mar 11 2021 18:31:50 (1 row)