鲲鹏社区首页
中文
注册
我要评分
文档获取效率
文档正确性
内容完整性
文档易理解
在线提单
论坛求助

一键下载并安装Greenplum所需插件的脚本内容

如下脚本内容可以一键下载并安装Greenplum所需插件。使用方法请参见单节点安装

由于Greenplum社区开源代码已归档,本文档中Greenplum、GPORCA、gp-xerces三个源码包的下载链接为非Greenplum社区下载链接。

下载和安装Greenplum所需插件的脚本(CentOS或openEuler 20.03)

  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
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
yum -y install curl-devel bzip2-devel python-devel openssl-devel readline-devel perl-ExtUtils-Embed libxml2-devel openldap-devel pam pam-devel perl-devel apr-devel libevent-devel libyaml libyaml-devel libedit-devel libffi-devel bison flex flex-devel
yum install -y cmake
yum install -y zstd*

echo "================================================"
echo "yum install down!"
echo "================================================"

mkdir /root/gp-plugin
cd /root/gp-plugin

# gp-xerces
wget https://gitee.com/WilliamLeoV/gp-xerces/repository/archive/v3.1.2-p1.zip --no-check-certificate
unzip v3.1.2-p1.zip
cd gp-xerces-v3.1.2-p1
./configure
make -j64
make -j64 install
cd ..
echo "================================================"
echo "gp-xerces down!"
echo "================================================"

# re2c
wget https://github.com/skvadrik/re2c/archive/refs/tags/2.0.3.tar.gz --no-check-certificate
tar -zxvf 2.0.3.tar.gz
cd re2c-2.0.3/
./autogen.sh
./configure
make -j64
make -j64 install
cd ..
echo "================================================"
echo "re2c down!"
echo "================================================"

# ninja
wget https://github.com/ninja-build/ninja/archive/refs/tags/v1.10.1.tar.gz --no-check-certificate
tar -zxvf v1.10.1.tar.gz
cd ninja-1.10.1/
./configure.py --bootstrap
cp ninja /usr/bin/
cd ..
echo "================================================"
echo "ninja down!"
echo "================================================"

# python-setuptools
wget https://github.com/pypa/setuptools/archive/refs/tags/v29.0.1.tar.gz --no-check-certificate
tar -zxvf v29.0.1.tar.gz
cd setuptools-29.0.1
python bootstrap.py
python setup.py install
cd ..
echo "================================================"
echo "python-setuptools down!"
echo "================================================"

# python-psutil
wget https://files.pythonhosted.org/packages/c4/b8/3512f0e93e0db23a71d82485ba256071ebef99b227351f0f5540f744af41/psutil-5.7.0.tar.gz --no-check-certificate
tar -zxvf psutil-5.7.0.tar.gz
cd psutil-5.7.0
python setup.py install
cd ..
echo "================================================"
echo "python-psutil down!"
echo "================================================"

# python-pbr
wget https://files.pythonhosted.org/packages/98/8a/defa5215d2dcf98cc80f4783e951a8356e38f352f7a169ae11670dcb1f25/pbr-5.4.4.tar.gz --no-check-certificate
tar -zxvf pbr-5.4.4.tar.gz
cd pbr-5.4.4
python setup.py install
cd ..
echo "================================================"
echo "python-pbr down!"
echo "================================================"

# python-lockfile
wget https://files.pythonhosted.org/packages/17/47/72cb04a58a35ec495f96984dddb48232b551aafb95bde614605b754fe6f7/lockfile-0.12.2.tar.gz --no-check-certificate
tar -zxvf lockfile-0.12.2.tar.gz
cd lockfile-0.12.2
python setup.py install
cd ..
echo "================================================"
echo "python-lockfile down!"
echo "================================================"

# python-pycparser
wget https://files.pythonhosted.org/packages/0f/86/e19659527668d70be91d0369aeaa055b4eb396b0f387a4f92293a20035bd/pycparser-2.20.tar.gz --no-check-certificate
tar -zxvf pycparser-2.20.tar.gz
cd pycparser-2.20
python setup.py install
cd ..
echo "================================================"
echo "python-pycparser down!"
echo "================================================"

# python-cffi
wget https://files.pythonhosted.org/packages/05/54/3324b0c46340c31b909fcec598696aaec7ddc8c18a63f2db352562d3354c/cffi-1.14.0.tar.gz --no-check-certificate
tar -zxvf cffi-1.14.0.tar.gz
cd cffi-1.14.0
python setup.py install
cd ..
echo "================================================"
echo "python-cffi down!"
echo "================================================"

# python-six
wget https://files.pythonhosted.org/packages/21/9f/b251f7f8a76dec1d6651be194dfba8fb8d7781d10ab3987190de8391d08e/six-1.14.0.tar.gz --no-check-certificate
tar -zxvf six-1.14.0.tar.gz
cd six-1.14.0
python setup.py install
cd ..
echo "================================================"
echo "python-six down!"
echo "================================================"

# python-bcrypt
wget https://files.pythonhosted.org/packages/fa/aa/025a3ab62469b5167bc397837c9ffc486c42a97ef12ceaa6699d8f5a5416/bcrypt-3.1.7.tar.gz --no-check-certificate
tar -zxvf bcrypt-3.1.7.tar.gz
cd bcrypt-3.1.7
python setup.py install
cd ..
echo "================================================"
echo "python-bcrypt down!"
echo "================================================"

# python-pynacl
wget https://files.pythonhosted.org/packages/61/ab/2ac6dea8489fa713e2b4c6c5b549cc962dd4a842b5998d9e80cf8440b7cd/PyNaCl-1.3.0.tar.gz --no-check-certificate
tar -zxvf PyNaCl-1.3.0.tar.gz
cd PyNaCl-1.3.0
python setup.py install
cd ..
echo "================================================"
echo "python-pynacl down!"
echo "================================================"

# python-ipaddress
wget https://files.pythonhosted.org/packages/b9/9a/3e9da40ea28b8210dd6504d3fe9fe7e013b62bf45902b458d1cdc3c34ed9/ipaddress-1.0.23.tar.gz --no-check-certificate
tar -zxvf ipaddress-1.0.23.tar.gz
cd ipaddress-1.0.23
python setup.py install
cd ..
echo "================================================"
echo "python-ipaddress down!"
echo "================================================"

# python-enum34
wget https://files.pythonhosted.org/packages/11/c4/2da1f4952ba476677a42f25cd32ab8aaf0e1c0d0e00b89822b835c7e654c/enum34-1.1.10.tar.gz --no-check-certificate
tar -zxvf enum34-1.1.10.tar.gz
cd enum34-1.1.10
python setup.py install
cd ..
echo "================================================"
echo "python-enum34 down!"
echo "================================================"

# python-cryptography
wget https://files.pythonhosted.org/packages/be/60/da377e1bed002716fb2d5d1d1cab720f298cb33ecff7bf7adea72788e4e4/cryptography-2.8.tar.gz --no-check-certificate
tar -zxvf cryptography-2.8.tar.gz
cd cryptography-2.8
python setup.py install
cd ..
echo "================================================"
echo "python-cryptography down!"
echo "================================================"

# python-paramiko
wget https://files.pythonhosted.org/packages/ac/15/4351003352e11300b9f44a13576bff52dcdc6e4a911129c07447bda0a358/paramiko-2.7.1.tar.gz --no-check-certificate
tar -zxvf paramiko-2.7.1.tar.gz
cd paramiko-2.7.1
python setup.py install
cd ..
echo "================================================"
echo "python-paramiko down!"
echo "================================================"

# python-epydoc
wget https://files.pythonhosted.org/packages/60/a7/666cb415b0f5d8d5c99f145e03a6005220090d7b77637871ac52c2cabcba/epydoc-3.0.1.tar.gz --no-check-certificate
tar -zxvf epydoc-3.0.1.tar.gz
cd epydoc-3.0.1
python setup.py install
cd ..
echo "================================================"
echo "python-epydoc down!"
echo "================================================"
echo "================================================"
echo "Still lack gp-orca!"
echo "================================================"

# gporca
wget https://gitee.com/WilliamLeoV/gporca/repository/archive/v3.65.3.zip --no-check-certificate
unzip v3.65.3.zip
cd gporca-v3.65.3
cmake -GNinja -H. -Bbuild
# vim libgpos/src/common/CStackDescriptor.cpp #注释第167行
sed -i '167d' libgpos/src/common/CStackDescriptor.cpp
ninja install -C build
echo /usr/local/lib >> /etc/ld.so.conf
ldconfig
cd ..

# greenplum-6.0.0
wget https://gitee.com/mirrors/gpdb/repository/archive/6.0.0.zip --no-check-certificate
unzip 6.0.0.zip
cd gpdb-6.0.0/
./configure --with-perl --with-python --with-libxml --prefix=/usr/local/gpdb
make -j64
make -j64 install
cd ..

下载和安装Greenplum所需插件的脚本(openEuler 22.03)

  • 下载脚本:
     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
    #!/bin/bash
    
    wget https://github.com/pypa/setuptools/archive/refs/tags/v29.0.1.tar.gz --no-check-certificate
    wget https://files.pythonhosted.org/packages/c4/b8/3512f0e93e0db23a71d82485ba256071ebef99b227351f0f5540f744af41/psutil-5.7.0.tar.gz --no-check-certificate
    wget https://files.pythonhosted.org/packages/98/8a/defa5215d2dcf98cc80f4783e951a8356e38f352f7a169ae11670dcb1f25/pbr-5.4.4.tar.gz --no-check-certificate
    wget https://files.pythonhosted.org/packages/17/47/72cb04a58a35ec495f96984dddb48232b551aafb95bde614605b754fe6f7/lockfile-0.12.2.tar.gz --no-check-certificate
    wget https://files.pythonhosted.org/packages/0f/86/e19659527668d70be91d0369aeaa055b4eb396b0f387a4f92293a20035bd/pycparser-2.20.tar.gz --no-check-certificate
    wget https://files.pythonhosted.org/packages/05/54/3324b0c46340c31b909fcec598696aaec7ddc8c18a63f2db352562d3354c/cffi-1.14.0.tar.gz --no-check-certificate
    wget https://files.pythonhosted.org/packages/fa/aa/025a3ab62469b5167bc397837c9ffc486c42a97ef12ceaa6699d8f5a5416/bcrypt-3.1.7.tar.gz --no-check-certificate
    wget https://files.pythonhosted.org/packages/21/9f/b251f7f8a76dec1d6651be194dfba8fb8d7781d10ab3987190de8391d08e/six-1.14.0.tar.gz --no-check-certificate
    wget https://files.pythonhosted.org/packages/61/ab/2ac6dea8489fa713e2b4c6c5b549cc962dd4a842b5998d9e80cf8440b7cd/PyNaCl-1.3.0.tar.gz --no-check-certificate
    wget https://files.pythonhosted.org/packages/be/60/da377e1bed002716fb2d5d1d1cab720f298cb33ecff7bf7adea72788e4e4/cryptography-2.8.tar.gz --no-check-certificate
    wget https://files.pythonhosted.org/packages/b9/9a/3e9da40ea28b8210dd6504d3fe9fe7e013b62bf45902b458d1cdc3c34ed9/ipaddress-1.0.23.tar.gz --no-check-certificate
    wget https://files.pythonhosted.org/packages/11/c4/2da1f4952ba476677a42f25cd32ab8aaf0e1c0d0e00b89822b835c7e654c/enum34-1.1.10.tar.gz --no-check-certificate
    wget https://files.pythonhosted.org/packages/ac/15/4351003352e11300b9f44a13576bff52dcdc6e4a911129c07447bda0a358/paramiko-2.7.1.tar.gz --no-check-certificate
    wget https://files.pythonhosted.org/packages/60/a7/666cb415b0f5d8d5c99f145e03a6005220090d7b77637871ac52c2cabcba/epydoc-3.0.1.tar.gz --no-check-certificate
    
    wget https://gitee.com/WilliamLeoV/gp-xerces/repository/archive/v3.1.2-p1.zip --no-check-certificate
    wget https://github.com/skvadrik/re2c/archive/refs/tags/2.0.3.tar.gz --no-check-certificate
    wget https://github.com/ninja-build/ninja/archive/refs/tags/v1.10.1.tar.gz --no-check-certificate
    
    
    wget https://gitee.com/WilliamLeoV/gporca/repository/archive/v3.65.3.zip --no-check-certificate
    wget https://gitee.com/mirrors/gpdb/repository/archive/6.0.0.zip --no-check-certificate
    wget https://www.python.org/ftp/python/2.7.18/Python-2.7.18.tgz --no-check-certificate
    
  • 安装脚本:
      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
    153
    154
    155
    156
    157
    158
    159
    160
    161
    162
    163
    164
    165
    166
    #!/bin/bash
    yum -y install curl-devel
    yum -y install bzip2-devel
    yum -y install openssl-devel
    yum -y install readline-devel
    yum -y install perl-ExtUtils-Embed
    yum -y install libxml2-devel
    yum -y install openldap-devel
    yum -y install pam pam-devel
    yum -y install perl-devel
    yum -y install apr-devel    #
    yum -y install libevent-devel
    yum -y install libyaml libyaml-devel    #
    yum -y install libedit-devel
    yum -y install libffi-devel
    yum -y install bison
    yum -y install flex flex-devel  #
    # yum -y install python-devel
    yum -y install cmake
    yum -y install zstd*
    
    # python2
    yum -y install gcc g++ libffi* openssl zlib* bzip2
    # yum -y install libssl
    tar xvf Python-2.7.18.tgz
    cd Python-2.7.18
    ./configure --with-ensurepip=install
    make -j16
    make -j16 install
    cd ..
    
    # gp-xerces
    
    
    unzip v3.1.2-p1.zip
    cd gp-xerces-v3.1.2-p1
    ./configure
    make -j16
    make -j16 install
    cd ..
    
    # re2c
    tar -zxvf 2.0.3.tar.gz
    cd re2c-2.0.3/
    ./autogen.sh
    ./configure
    make -j16
    make -j16 install
    cd ..
    
    # ninja
    tar -zxvf v1.10.1.tar.gz
    cd ninja-1.10.1/
    ./configure.py --bootstrap
    cp ninja /usr/bin/
    cd ..
    
    # python-setuptools
    tar -zxvf v29.0.1.tar.gz
    cd setuptools-29.0.1
    python bootstrap.py
    python setup.py install
    cd ..
    
    # python-psutil
    tar -zxvf psutil-5.7.0.tar.gz
    cd psutil-5.7.0
    python setup.py install
    cd ..
    
    # python-pbr
    tar -zxvf pbr-5.4.4.tar.gz
    cd pbr-5.4.4
    python setup.py install
    cd ..
    
    # python-lockfile
    tar -zxvf lockfile-0.12.2.tar.gz
    cd lockfile-0.12.2
    python setup.py install
    cd ..
    
    # python-pycparser
    tar -zxvf pycparser-2.20.tar.gz
    cd pycparser-2.20
    python setup.py install
    cd ..
    
    # python-cffi
    tar -zxvf cffi-1.14.0.tar.gz
    cd cffi-1.14.0
    python setup.py install
    cd ..
    
    # python-six
    tar -zxvf six-1.14.0.tar.gz
    cd six-1.14.0
    python setup.py install
    cd ..
    
    # python-bcrypt
    tar -zxvf bcrypt-3.1.7.tar.gz
    cd bcrypt-3.1.7
    python setup.py install
    cd ..
    
    # python-pynacl
    tar -zxvf PyNaCl-1.3.0.tar.gz
    cd PyNaCl-1.3.0
    python setup.py install
    cd ..
    
    # python-ipaddress
    tar -zxvf ipaddress-1.0.23.tar.gz
    cd ipaddress-1.0.23
    python setup.py install
    cd ..
    
    # python-enum34
    tar -zxvf enum34-1.1.10.tar.gz
    cd enum34-1.1.10
    python setup.py install
    cd ..
    
    # python-cryptography
    tar -zxvf cryptography-2.8.tar.gz
    cd cryptography-2.8
    python setup.py install
    cd ..
    
    # python-paramiko
    tar -zxvf paramiko-2.7.1.tar.gz
    cd paramiko-2.7.1
    python setup.py install
    cd ..
    
    # python-epydoc
    tar -zxvf epydoc-3.0.1.tar.gz
    cd epydoc-3.0.1
    python setup.py install
    cd ..
    
    # gp-orca
    
    
    unzip v3.65.3.zip
    cd gporca-v3.65.3
    cmake -GNinja -H. -Bbuild
    # vim libgpos/src/common/CStackDescriptor.cpp #注释第167行
    sed -i '167d' libgpos/src/common/CStackDescriptor.cpp
    ninja install -C build
    echo /usr/local/lib >> /etc/ld.so.conf
    ldconfig
    cd ..
    
    # greenplum-6.0.0
    
    unzip 6.0.0.zip
    cd gpdb-6.0.0/
    sed -i '76 s/bool/extern bool/' src/backend/cdb/cdbvars.c
    sed -i '190 s/bool/extern bool/' src/backend/utils/misc/guc_gp.c
    sed -i '196 s/char/extern char/' src/backend/utils/misc/guc_gp.c
    ./configure --with-perl --with-python --with-libxml --prefix=/usr/local/gpdb
    make -j64
    make -j64 install
    cd ..