
14 PYTHONHOME="$GPHOME/ext/python"
15 exportPYTHONHOME
16 fi
17 PYTHONPATH=$GPHOME/lib/python
18 PATH=$GPHOME/bin:$PYTHONHOME/bin:$PATH
19 LD_LIBRARY_PATH=$GPHOME/lib:$PYTHONHOME/lib:${LD_LIBRARY_PATH‐}
20 exportLD_LIBRARY_PATH
21 if[‐e$GPHOME/etc/openssl.cnf];then
22 OPENSSL_CONF=$GPHOME/etc/openssl.cnf
23 exportOPENSSL_CONF
24 fi
25 exportGPHOME
26 exportPATH
27 exportPYTHONPATH
28 #增加JAVA_HOMELD_LIBRARY_PATH
29 exportJAVA_HOMELD_LIBRARY_PATH=/usr/lib/jvm/java‐1.8.0‐openjdk‐1.8.0.33
2.b09‐1.el7_9.x86_64
30 #增加:MASTER_DATA_DIRECTORY
31 exportMASTER_DATA_DIRECTORY=/u05/master/gpseg‐1
32 [gpadmin@gp_master~]$source/usr/local/greenplum‐db/greenplum_path.sh
3、安装GreenplumPL/Java扩展
在安装PL/Java扩展之前,请确保您的Greenplum数据库正在运行
下载VMwareTanzu™Greenplum®—VMwareTanzuNetwork(pivotal.io)
greenplum为6.4版本,对应下载:pljava-2.0.2-gp6-rhel7_x86_64.gppkg
pljava.rar-墨天轮资源(modb.pro)
通过运行该命令安装软件扩展包。此示例在Linux系统上安装PL/Java扩展包
1 [gpadmin@gp_master~]$gppkg‐ipljava‐2.0.2‐gp6‐rhel7_x86_64.gppkg
2 20220712:13:35:49:018820gppkg:gp_master:gpadmin‐[INFO]:‐Startinggppkgw
ithargs:‐ipljava‐2.0.2‐gp6‐rhel7_x86_64.gppkg
3 20220712:13:35:49:018820gppkg:gp_master:gpadmin‐[INFO]:‐Installingpacka
gepljava‐2.0.2‐gp6‐rhel7_x86_64.gppkg
4 20220712:13:35:49:018820gppkg:gp_master:gpadmin‐[INFO]:‐Validatingrpmi
nstallationcmdStr='rpm‐‐test‐i/usr/local/greenplum‐db‐6.4.0/.tmp/pljava
‐2.0.0‐0.x86_64.rpm‐‐dbpath/usr/local/greenplum‐db‐6.4.0/share/packages/d
atabase‐‐prefix/usr/local/greenplum‐db‐6.4.0'
5 20220712:13:35:49:018820gppkg:gp_master:gpadmin‐[INFO]:‐Installingpljav
a‐2.0.2‐gp6‐rhel7_x86_64.gppkglocally
6 20220712:13:35:49:018820gppkg:gp_master:gpadmin‐[INFO]:‐Validatingrpmi
nstallationcmdStr='rpm‐‐test‐i/usr/local/greenplum‐db‐6.4.0/.tmp/pljava
‐2.0.0‐0.x86_64.rpm‐‐dbpath/usr/local/greenplum‐db‐6.4.0/share/packages/d
atabase‐‐prefix/usr/local/greenplum‐db‐6.4.0'
评论