Greenplum 6 基于openEuler22.03编译安装（不支持）
Tags： GreenPlumopenEuler安装配置源码编译
👉 本文共约1065个字，系统预计阅读时间或需5分钟。
前言
GreenPlum中文社区发布称Greenplum完全兼容欧拉开源操作系统 ，参考：https://cn.greenplum.org/greenplum_openeuler_whitepaper/ ，下载：https://cn.greenplum.org/wp-content/uploads/2022/02/%E5%AE%8C%E5%85%A8%E5%85%BC%E5%AE%B9%E6%AC%A7%E6%8B%89%E5%BC%80%E6%BA%90%E6%93%8D%E4%BD%9C%E7%B3%BB%E7%BB%9F%E7%9A%84-HTAP-%E6%95%B0%E6%8D%AE%E5%B9%B3%E5%8F%B0-Greenplum.pdf
但是仓库：https://gitee.com/src-openeuler/gpdb为空，感觉该项目可能黄了。。。
我自己的编译过程
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 | docker rm -f openeuler2203gpdb6 docker run -itd --name openeuler2203gpdb6 -h mdw \ --privileged=true \ -v /sys/fs/cgroup:/sys/fs/cgroup \ lhrbest/openeuler22:2.0 \ init docker exec -it openeuler2203gpdb6 bash wget https://ghproxy.com/https://github.com/greenplum-db/gpdb/releases/download/6.23.3/6.23.3-src-full.tar.gz dnf groupinstall -y 'Development Tools' # GCC, libtools etc dnf install -y curl-devel bzip2-devel python-devel openssl-devel readline-devel libzstd-devel dnf install -y perl-ExtUtils-Embed # If enable perl dnf install -y libxml2-devel # If enable XML support dnf install -y openldap-devel # If enable LDAP dnf install -y pam pam-devel # If enable PAM dnf install -y perl-devel # If need installcheck-world dnf install -y sudo python mkdir -p ~/.pip cat > ~/.pip/pip.conf << EOF [global] index-url = https://pypi.douban.com/simple/ [install] trusted-host = pypi.douban.com EOF wget https://bootstrap.pypa.io/get-pip.py sudo python get-pip.py sudo pip install psutil lockfile paramiko setuptools epydoc tar -zxvf 6.23.3-src-full.tar.gz cd gpdb_src/ CFLAGS="-O0 -g3 -ggdb3" \ ./configure --with-perl --with-python --with-libxml --enable-debug --enable-cassert \ --disable-orca --disable-gpcloud --disable-gpfdist \ --prefix=/usr/local/gpdb make -j16 ##成功会提示：All of Greenplum Database successfully made. Ready to install. make install Traceback (most recent call last): File "/soft/gpdb_src/gpMgmt/bin/pythonSrc/PyGreSQL-4.0/setup.py", line 45, in <module> raise Exception("PyGreSQL %s requires a Python 2 version" Exception: PyGreSQL 4.0 requires a Python 2 version newer than 2.2. make[2]: *** [Makefile:80: pygresql] Error 1 make[2]: Leaving directory '/soft/gpdb_src/gpMgmt/bin' make[1]: *** [Makefile:7: install-bin-recurse] Error 2 make[1]: Leaving directory '/soft/gpdb_src/gpMgmt' make: *** [GNUmakefile:86: install] Error 2 -- 测试 cd gpAux/gpdemo source /usr/local/gpdb/greenplum_path.sh export PGHOST=`hostname` make source gpdemo-env.sh sed -i s/SELINUX=enforcing/SELINUX=disabled/g /etc/selinux/config setenforce 0 cat >> /etc/security/limits.conf <<"EOF" * soft nofile 65535 * hard nofile 65535 EOF ulimit -HSn 65535 cat >> /etc/sysctl.conf <<"EOF" kernel.shmmax = 4398046511104 kernel.shmmni = 4096 kernel.shmall = 4000000000 kernel.sem = 32000 1024000000 500 32000 vm.overcommit_memory=2 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" mdw EOF cat > /home/gpadmin/conf/seg_hosts <<"EOF" mdw EOF rpm -ivh /soft/open-source-greenplum-db-6.23.1-rhel7-x86_64.rpm chown -R gpadmin:gpadmin /usr/local/gpdb chown -R gpadmin:gpadmin /usr/local/gpdb-6.23.1 echo ". /usr/local/gpdb/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 "mdw mdw" -advanced exverify –confirm ./sshUserSetup.sh -user gpadmin -hosts "mdw mdw" -advanced exverify –confirm chmod 600 /home/gpadmin/.ssh/config mkdir -p /opt/greenplum/data/master mkdir -p /opt/greenplum/data/primary mkdir -p /opt/greenplum/data/mirror mkdir -p /opt/greenplum/data/master_standby 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=mdw 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 mdw -P 5433 -S /opt/greenplum/data/master_standby/gpseg-1 会报错："FATAL","58P01","could not access file ""gp_resource_group"": No such file or directory",,,,,,"/* -- 无解。。。。 |
总结
1、make install报错：Exception: PyGreSQL 4.0 requires a Python 2 version newer than 2.2. ，需要python2的版本，请参考：https://gitee.com/src-openeuler/gpdb/issues/I40R9G?from=project-issue ，目前官方并不支持。。。。
2、gpinitsystem初始化报错："FATAL","58P01","could not access file ""gp_resource_group"": No such file or directory",,,,,,"/*
本人提供Oracle、MySQL、PG等数据库的培训和考证业务，私聊QQ646634621或微信db_bao，谢谢！
暂未安装成功。。。。
3、使用二进制安装也不能成功，请参考：https://www.xmmup.com/mppjiagouzhigreenplumdeanzhuangpeizhigaojiban.html#you_guan_hua_weiopenEuler_xi_tong_de_shi_pei_shuo_ming
参考
https://github.com/greenplum-db/gpdb
https://cn.greenplum.org/greenplum-compile-install/
