GreenPlum 7 单机安装

由 小麦苗 · 发布日期 2023年7月21日 · 已更新 2023年11月13日  

0    127    1

Tags： GreenPlum安装部署单机GPDB 7

👉 本文共约311个字，系统预计阅读时间或需2分钟。

显示/隐藏全文目录

目录

• 安装
• gpcc
• 镜像
• 总结

本页目录 隐藏

1) 安装

2) gpcc

3) 相关文章

安装

docker rm -f gpdb7 docker run -itd --name gpdb7 -h gpdb7 \ -p 5437:5432 -p 28087:28080 \ -v /sys/fs/cgroup:/sys/fs/cgroup \ --privileged=true lhrbest/centosstream8:4.0 \ /usr/sbin/init docker cp -q open-source-greenplum-db-7.0.0-el8-x86_64.rpm gpdb7:/soft/ docker cp -q greenplum-cc-web-7.0.0-gp6-rhel8-x86_64.zip gpdb7:/soft/ docker exec -it gpdb7 bash sed -i s/SELINUX=enforcing/SELINUX=disabled/g /etc/selinux/config setenforce 0 systemctl status firewalld.service systemctl disable firewalld.service systemctl start firewalld firewall-cmd --add-port=0-65535/tcp --permanent firewall-cmd --add-port=0-65535/udp --permanent firewall-cmd --reload firewall-cmd --list-ports systemctl stop firewalld.service cat >> /etc/security/limits.conf <<"EOF" * soft nofile 655350 * hard nofile 655350 * soft nproc 655350 * hard nproc 655350 EOF cat >> /etc/sysctl.conf <<"EOF" kernel.shmmax = 4398046511104 kernel.shmmni = 4096 kernel.shmall = 4000000000 kernel.sem = 32000 1024000000 500 32000 vm.overcommit_memory=1 vm.overcommit_ratio=95 EOF sysctl -p groupadd -g 530 gpadmin useradd -g 530 -u 530 -m -d /home/gpadmin -s /bin/bash gpadmin chown -R gpadmin:gpadmin /home/gpadmin echo "gpadmin:lhr" | chpasswd su - gpadmin mkdir -p /home/gpadmin/conf/ cat > /home/gpadmin/conf/all_hosts <<"EOF" gpdb7 EOF cat > /home/gpadmin/conf/seg_hosts <<"EOF" gpdb7 EOF dnf install -y python39 rpm -ivh /soft/open-source-greenplum-db-7.0.0-el8-x86_64.rpm chown -R gpadmin:gpadmin /usr/local/greenplum-db chown -R gpadmin:gpadmin /usr/local/greenplum-db-7.0.0 echo ". /usr/local/greenplum-db/greenplum_path.sh" >> /home/gpadmin/.bashrc echo "export MASTER_DATA_DIRECTORY=/opt/greenplum/data/master/gpseg-1" >> /home/gpadmin/.bashrc echo "export PGDATABASE=postgres" >> /home/gpadmin/.bashrc echo "export PGPORT=5432" >> /home/gpadmin/.bashrc ./sshUserSetup.sh -user root -hosts "gpdb7 gpdb7" -advanced -noPromptPassphrase ./sshUserSetup.sh -user gpadmin -hosts "gpdb7 gpdb7" -advanced -noPromptPassphrase chmod 600 /home/gpadmin/.ssh/config mkdir -p /opt/greenplum/data/master mkdir -p /opt/greenplum/data/master_standby mkdir -p /opt/greenplum/data/primary mkdir -p /opt/greenplum/data/mirror mkdir -p /opt/greenplum/data/ chown -R gpadmin:gpadmin /opt/greenplum su - gpadmin cat > /home/gpadmin/conf/initgp_config <<"EOF" declare -a DATA_DIRECTORY=(/opt/greenplum/data/primary /opt/greenplum/data/primary) declare -a MIRROR_DATA_DIRECTORY=(/opt/greenplum/data/mirror /opt/greenplum/data/mirror) ARRAY_NAME="lhrgp" SEG_PREFIX=gpseg PORT_BASE=6000 MIRROR_PORT_BASE=7000 MASTER_PORT=5432 MASTER_HOSTNAME=gpdb7 MASTER_DIRECTORY=/opt/greenplum/data/master DATABASE_NAME=lhrgpdb MACHINE_LIST_FILE=/home/gpadmin/conf/seg_hosts EOF gpinitsystem -c /home/gpadmin/conf/initgp_config -e=lhr -s gpdb7 -P 5433 -S /opt/greenplum/data/master_standby/gpseg-1 echo "host all all all md5" >> /opt/greenplum/data/master/gpseg-1/pg_hba.conf gpstop -u psql \password gpadmin postgres=# select version(); version ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- PostgreSQL 12.12 (Greenplum Database 7.0.0 build commit:0a7a3566873325aca1789ae6f818c80f17a9402d Open Source) on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-18), 64-bit compiled on Sep 20 2023 23:29:19 Bhuvnesh C. (1 row) postgres=# \l List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges -----------+---------+----------+-------------+-------------+--------------------- lhrgpdb | gpadmin | UTF8 | en_US.UTF-8 | en_US.UTF-8 | postgres | gpadmin | UTF8 | en_US.UTF-8 | en_US.UTF-8 | template0 | gpadmin | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/gpadmin + | | | | | gpadmin=CTc/gpadmin template1 | gpadmin | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/gpadmin + | | | | | gpadmin=CTc/gpadmin (4 rows) postgres=# select * from gp_segment_configuration order by 1,3 ; dbid | content | role | preferred_role | mode | status | port | hostname | address | datadir ------+---------+------+----------------+------+--------+------+----------+---------+-------------------------------------------- 1 | -1 | p | p | n | u | 5432 | gpdb7 | gpdb7 | /opt/greenplum/data/master/gpseg-1 2 | 0 | p | p | s | u | 6000 | gpdb7 | gpdb7 | /opt/greenplum/data/primary/gpseg0 3 | 1 | p | p | s | u | 6001 | gpdb7 | gpdb7 | /opt/greenplum/data/primary/gpseg1 4 | 0 | m | m | s | u | 7000 | gpdb7 | gpdb7 | /opt/greenplum/data/mirror/gpseg0 5 | 1 | m | m | s | u | 7001 | gpdb7 | gpdb7 | /opt/greenplum/data/mirror/gpseg1 6 | -1 | m | m | s | u | 5433 | gpdb7 | gpdb7 | /opt/greenplum/data/master_standby/gpseg-1 (6 rows) postgres=# psql -U gpadmin -h172.18.0.14 -p 5431 -d lhrgpdb

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152

docker rm -f gpdb7 docker run -itd --name gpdb7 -h gpdb7 \   -p 5437:5432 -p 28087:28080  \   -v /sys/fs/cgroup:/sys/fs/cgroup \   --privileged=true lhrbest/centosstream8:4.0 \   /usr/sbin/init   docker cp -q open-source-greenplum-db-7.0.0-el8-x86_64.rpm gpdb7:/soft/ docker cp -q greenplum-cc-web-7.0.0-gp6-rhel8-x86_64.zip gpdb7:/soft/   docker exec -it gpdb7 bash   sed -i s/SELINUX=enforcing/SELINUX=disabled/g /etc/selinux/config setenforce 0   systemctl status firewalld.service systemctl disable firewalld.service   systemctl start firewalld   firewall-cmd --add-port=0-65535/tcp --permanent firewall-cmd --add-port=0-65535/udp --permanent firewall-cmd --reload firewall-cmd --list-ports   systemctl stop firewalld.service   cat >> /etc/security/limits.conf <<"EOF"   * soft nofile 655350 * hard nofile 655350 * soft nproc 655350 * hard nproc 655350   EOF   cat >> /etc/sysctl.conf <<"EOF" kernel.shmmax = 4398046511104 kernel.shmmni = 4096 kernel.shmall = 4000000000 kernel.sem = 32000 1024000000 500 32000   vm.overcommit_memory=1 vm.overcommit_ratio=95   EOF   sysctl -p   groupadd -g 530 gpadmin useradd -g 530 -u 530 -m -d /home/gpadmin -s /bin/bash gpadmin chown -R gpadmin:gpadmin /home/gpadmin echo "gpadmin:lhr" | chpasswd   su - gpadmin   mkdir -p /home/gpadmin/conf/   cat > /home/gpadmin/conf/all_hosts <<"EOF"   gpdb7   EOF   cat > /home/gpadmin/conf/seg_hosts <<"EOF"   gpdb7   EOF   dnf install -y python39 rpm -ivh /soft/open-source-greenplum-db-7.0.0-el8-x86_64.rpm   chown -R gpadmin:gpadmin /usr/local/greenplum-db chown -R gpadmin:gpadmin /usr/local/greenplum-db-7.0.0   echo ". /usr/local/greenplum-db/greenplum_path.sh" >> /home/gpadmin/.bashrc   echo "export MASTER_DATA_DIRECTORY=/opt/greenplum/data/master/gpseg-1" >> /home/gpadmin/.bashrc echo "export PGDATABASE=postgres" >> /home/gpadmin/.bashrc echo "export PGPORT=5432" >> /home/gpadmin/.bashrc   ./sshUserSetup.sh -user root  -hosts "gpdb7 gpdb7"  -advanced  -noPromptPassphrase ./sshUserSetup.sh -user gpadmin  -hosts "gpdb7 gpdb7"  -advanced  -noPromptPassphrase chmod 600 /home/gpadmin/.ssh/config   mkdir -p /opt/greenplum/data/master mkdir -p /opt/greenplum/data/master_standby mkdir -p /opt/greenplum/data/primary mkdir -p /opt/greenplum/data/mirror   mkdir -p /opt/greenplum/data/ chown -R gpadmin:gpadmin /opt/greenplum   su - gpadmin   cat > /home/gpadmin/conf/initgp_config <<"EOF" declare -a DATA_DIRECTORY=(/opt/greenplum/data/primary /opt/greenplum/data/primary) declare -a MIRROR_DATA_DIRECTORY=(/opt/greenplum/data/mirror /opt/greenplum/data/mirror) ARRAY_NAME="lhrgp" SEG_PREFIX=gpseg PORT_BASE=6000 MIRROR_PORT_BASE=7000 MASTER_PORT=5432 MASTER_HOSTNAME=gpdb7 MASTER_DIRECTORY=/opt/greenplum/data/master DATABASE_NAME=lhrgpdb MACHINE_LIST_FILE=/home/gpadmin/conf/seg_hosts EOF   gpinitsystem -c /home/gpadmin/conf/initgp_config -e=lhr -s gpdb7 -P 5433 -S /opt/greenplum/data/master_standby/gpseg-1   echo "host all all all md5" >> /opt/greenplum/data/master/gpseg-1/pg_hba.conf gpstop -u   psql \password gpadmin   postgres=# select version();                                                                                                                       version                                                                                                                       ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- PostgreSQL 12.12 (Greenplum Database 7.0.0 build commit:0a7a3566873325aca1789ae6f818c80f17a9402d Open Source) on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-18), 64-bit compiled on Sep 20 2023 23:29:19 Bhuvnesh C. (1 row)   postgres=# \l                                 List of databases    Name    |  Owner  | Encoding |   Collate   |    Ctype    |  Access privileges   -----------+---------+----------+-------------+-------------+--------------------- lhrgpdb   | gpadmin | UTF8     | en_US.UTF-8 | en_US.UTF-8 | postgres  | gpadmin | UTF8     | en_US.UTF-8 | en_US.UTF-8 | template0 | gpadmin | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/gpadmin         +            |         |          |             |             | gpadmin=CTc/gpadmin template1 | gpadmin | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/gpadmin         +            |         |          |             |             | gpadmin=CTc/gpadmin (4 rows)   postgres=#  select * from gp_segment_configuration order by 1,3 ; dbid | content | role | preferred_role | mode | status | port | hostname | address |                  datadir                   ------+---------+------+----------------+------+--------+------+----------+---------+--------------------------------------------     1 |      -1 | p    | p              | n    | u      | 5432 | gpdb7    | gpdb7   | /opt/greenplum/data/master/gpseg-1     2 |       0 | p    | p              | s    | u      | 6000 | gpdb7    | gpdb7   | /opt/greenplum/data/primary/gpseg0     3 |       1 | p    | p              | s    | u      | 6001 | gpdb7    | gpdb7   | /opt/greenplum/data/primary/gpseg1     4 |       0 | m    | m              | s    | u      | 7000 | gpdb7    | gpdb7   | /opt/greenplum/data/mirror/gpseg0     5 |       1 | m    | m              | s    | u      | 7001 | gpdb7    | gpdb7   | /opt/greenplum/data/mirror/gpseg1     6 |      -1 | m    | m              | s    | u      | 5433 | gpdb7    | gpdb7   | /opt/greenplum/data/master_standby/gpseg-1 (6 rows)   postgres=#   psql -U gpadmin -h172.18.0.14 -p 5431 -d lhrgpdb

gpcc

参考：https://docs.vmware.com/en/VMware-Greenplum-Command-Center/7.0/greenplum-command-center/topics-install.html

mkdir -p /usr/local/greenplum-cc-7.0.0; chown -R gpadmin:gpadmin /usr/local/greenplum-cc-7.0.0 ln -s /usr/local/greenplum-cc-7.0.0 /usr/local/greenplum-cc chown -R gpadmin:gpadmin /usr/local/greenplum-db chown -R gpadmin:gpadmin /usr/local/greenplum-db-7.0.0 su - gpadmin source /usr/local/greenplum-db/greenplum_path.sh unzip /soft/greenplum-cc-web-7.0.0-gp7-el8-x86_64.zip cd greenplum-cc-web-7.0.0-gp7-el8-x86_64/ cat > /tmp/gpcc_install.conf <<"EOF" path = /usr/local master_port = 5432 web_port = 28080 rpc_port = 8899 enable_ssl = false enable_kerberos = false language = 2 EOF ./gpccinstall-7.0.0 -c /tmp/gpcc_install.conf echo 'source /usr/local/greenplum-cc/gpcc_path.sh' >> ~/.bashrc source /usr/local/greenplum-cc/gpcc_path.sh cd $GPCC_HOME cat update-extension.txt cd /usr/local/greenplum-cc-7.0.0/gppkg gppkg install MetricsCollector-7.0.0_gp_7.0.0-rocky8-x86_64.gppkg gpstop -M fast -ra gpcc start ; gpcc status psql -d gpperfmon alter user gpmon with password 'lhr'; echo '*:5432:gpperfmon:gpmon:lhr' > ~/.pgpass chmod 600 /home/gpadmin/.pgpass gpconfig -c shared_preload_libraries -v metrics_collector gpconfig -c gp_enable_query_metrics -v on gpconfig -c track_activities -v on gpconfig -c track_activity_query_size -v 102400 -m 102400 gpconfig -s shared_preload_libraries gpconfig -s gp_enable_query_metrics gpconfig -s track_activities gpstop -M fast -ra gpcc stop ; gpcc start ; gpcc status

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54

mkdir -p /usr/local/greenplum-cc-7.0.0; chown -R gpadmin:gpadmin /usr/local/greenplum-cc-7.0.0 ln -s /usr/local/greenplum-cc-7.0.0 /usr/local/greenplum-cc   chown -R gpadmin:gpadmin /usr/local/greenplum-db chown -R gpadmin:gpadmin /usr/local/greenplum-db-7.0.0   su - gpadmin source /usr/local/greenplum-db/greenplum_path.sh unzip /soft/greenplum-cc-web-7.0.0-gp7-el8-x86_64.zip cd greenplum-cc-web-7.0.0-gp7-el8-x86_64/   cat > /tmp/gpcc_install.conf <<"EOF" path = /usr/local   master_port = 5432 web_port = 28080 rpc_port = 8899 enable_ssl = false enable_kerberos = false language = 2 EOF   ./gpccinstall-7.0.0 -c /tmp/gpcc_install.conf   echo 'source /usr/local/greenplum-cc/gpcc_path.sh' >> ~/.bashrc   source /usr/local/greenplum-cc/gpcc_path.sh cd $GPCC_HOME cat update-extension.txt   cd /usr/local/greenplum-cc-7.0.0/gppkg gppkg install  MetricsCollector-7.0.0_gp_7.0.0-rocky8-x86_64.gppkg gpstop -M fast -ra gpcc start ; gpcc status   psql -d gpperfmon alter  user gpmon with password 'lhr';   echo '*:5432:gpperfmon:gpmon:lhr' >  ~/.pgpass chmod 600 /home/gpadmin/.pgpass   gpconfig -c shared_preload_libraries -v metrics_collector gpconfig -c gp_enable_query_metrics -v on gpconfig -c track_activities  -v on gpconfig -c track_activity_query_size -v 102400 -m 102400   gpconfig -s shared_preload_libraries gpconfig -s gp_enable_query_metrics gpconfig -s track_activities   gpstop -M fast -ra gpcc stop ; gpcc start ; gpcc status

本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务，私聊QQ646634621或微信db_bao，谢谢！

后续精彩内容已被小麦苗无情隐藏，请输入验证码解锁本站所有文章！

验证码：

请先关注本站微信公众号，然后回复“小麦苗博客”，获取验证码。在微信里搜索“DB宝”或者“www_xmmup_com”或者微信扫描右侧二维码都可以关注本站微信公众号。

相关文章

• GreenPlum 6 单机安装
• GreenPlum工具之gppkg
• Greenplum 7 新特性整理
• 在Docker中快速体验GreenPlum 7.0.0和gpcc 7.0.0
• MPP架构之Greenplum的安装配置高级版（企业配置）
• GreenPlum官方监控工具GPCC的安装和卸载
• GreenPlum启动数据库报错pre-existing shared memory block
• GreenPlum中查询用户表卡住 Interconnect encountered a network error, please check your network
• GreenPlum初始化时一直卡住“Completed restart of Greenplum instance in production mode”，psql postgres 命令也一直卡住，警告Failed to connect to template1
• GreenPlum在删除数据文件后如何恢复
• gprecoverseg恢复GreenPlum的时候报错“gprecoverseg failed(Reason ''ascii' codec can't encode character u'\u2018' in positition 229: ordinal not in range(128)'）exiting”
• 在Docker中快速使用各个版本的GreenPlum数据库
• pg_restore导入数据报警告 pg_restore: WARNING: column "foobar" has type "unknown" DETAIL: Proceeding with relation creation anyway.
• Greenplum介绍
• Greenplum的差异化修复原理简介
• GreenPlum中的vacuumdb和analyzedb
• Oracle同步数据到GreenPlum
• 小麦苗GreenPlum DBA课程
• Greenplum中的进程优先级（PR、NI）
• GreenPlum查询报错failed to initialize zstd stream: Allocation error : not enough memory

打赏赞(1)分享

标签： GreenPlum安装部署单机GPDB 7

小麦苗

学习或考证，均可联系麦老师，请加微信db_bao或QQ646634621

• 下一篇 在Docker中快速体验GreenPlum 7.0.0和gpcc 7.0.0
• 上一篇 虚拟化和裸金属中的K8s部署环境架构与特性对比

您可能还喜欢...

• 0

  PG中的物化视图

  2023年5月22日

   由 小麦苗

   由 小麦苗 · Published 2023年5月22日

   

  0    48    2
• 0

  小麦苗GreenPlum DBA课程

  2023年9月6日

   由 小麦苗

   由 小麦苗 · Published 2023年9月6日 · Last modified 2023年11月13日

  · 已更新 2023年11月13日  

  0    365    5
• 1

  【DB宝4】只需2步即可拥有Oracle19c的ASM+DB环境

  2021年6月3日

   由 小麦苗

   由 小麦苗 · Published 2021年6月3日 · Last modified 2023年4月7日

  · 已更新 2023年4月7日  

  1    10615    6