Mogdb 3.0插件安装

MogDB提供了gs_install_plugin工具用于安装插件,也可以使用无编译安装插件，本文章将介绍2种方法安装插件

1.工具安装

(1)安装命令介绍

gs_install_plugin [-h] [-X XML] [-p] [--all] [--force] [--plugins] [--PLUGIN_NAME] [--debug]
-h, --help 显示帮助信息
-X 指定xml文件路径
-p 指定plugins安装包位置，默认在$GPHOME/script/static寻找plugins安装包
--all 安装全部插件
--force 指定覆盖旧的插件
--plugins 可安装多个插件，--plugins后跟插件名
--PLUGIN_NAME 指定安装某一个插件，如：--dblink
--debug 输出debug信息

(2)安装步骤

[omm@node1 ~]$ cd $GPHOME/script/
[omm@node1 script]$ mkdir -p static
[omm@node1 script]$ cd static/
--官网下载插件包
[omm@node1 static]$ wget https://cdn-mogdb.enmotech.com/mogdb-media/3.0.1/Plugins-3.0.1-CentOS-x86_64.tar.gz
--2022-08-31 20:20:14--  https://cdn-mogdb.enmotech.com/mogdb-media/3.0.1/Plugins-3.0.1-CentOS-x86_64.tar.gz
Resolving cdn-mogdb.enmotech.com (cdn-mogdb.enmotech.com)... 124.236.20.228
Connecting to cdn-mogdb.enmotech.com (cdn-mogdb.enmotech.com)|124.236.20.228|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 74443447 (71M) [application/gzip]
Saving to: ‘Plugins-3.0.1-CentOS-x86_64.tar.gz’
100%[============================================================================================================================================>] 74,443,447  9.12MB/s   in 5.9s

2022-08-31 20:20:20 (11.9 MB/s) - ‘Plugins-3.0.1-CentOS-x86_64.tar.gz’ saved [74443447/74443447]
[omm@node1 static]$ chmod +x Plugins-3.0.1-CentOS-x86_64.tar.gz
[omm@node1 static]$ ll
total 72700
-rwx------ 1 omm dbgrp 74443447 Aug  5 19:36 Plugins-3.0.1-CentOS-x86_64.tar.gz
--执行命令，安装插件
[omm@node1 static]$ gs_install_plugin -X /opt/software/mogdb/clusterconfig.xml --all
SUCCESS: pg_trgm
SUCCESS: dblink
SUCCESS: orafce
SUCCESS: wal2json
SUCCESS: pg_repack
SUCCESS: pg_bulkload
SUCCESS: pg_prewarm
SUCCESS: dolphin
SUCCESS: whale
SUCCESS: postgis
[omm@node1 static]$
查看是否安装成功
MogDB=# \dx
                               List of installed extensions
      Name       | Version |   Schema   |                   Description
-----------------+---------+------------+--------------------------------------------------
 dist_fdw        | 1.0     | pg_catalog | foreign-data wrapper for distfs access
 file_fdw        | 1.0     | pg_catalog | foreign-data wrapper for flat file access
 hdfs_fdw        | 1.0     | pg_catalog | foreign-data wrapper for flat file access
 hstore          | 1.1     | pg_catalog | data type for storing sets of (key, value) pairs
 log_fdw         | 1.0     | pg_catalog | Foreign Data Wrapper for accessing logging data
 mot_fdw         | 1.0     | pg_catalog | foreign-data wrapper for MOT access
 plpgsql         | 1.0     | pg_catalog | PL/pgSQL procedural language
 security_plugin | 1.0     | pg_catalog | provides security functionality
(8 rows)

MogDB=# create extension pg_trgm;
CREATE EXTENSION
MogDB=# \dx
                                        List of installed extensions
      Name       | Version |   Schema   |                            Description
-----------------+---------+------------+-------------------------------------------------------------------
 dist_fdw        | 1.0     | pg_catalog | foreign-data wrapper for distfs access
 file_fdw        | 1.0     | pg_catalog | foreign-data wrapper for flat file access
 hdfs_fdw        | 1.0     | pg_catalog | foreign-data wrapper for flat file access
 hstore          | 1.1     | pg_catalog | data type for storing sets of (key, value) pairs
 log_fdw         | 1.0     | pg_catalog | Foreign Data Wrapper for accessing logging data
 mot_fdw         | 1.0     | pg_catalog | foreign-data wrapper for MOT access
 pg_trgm         | 1.0     | public     | text similarity measurement and index searching based on trigrams
 plpgsql         | 1.0     | pg_catalog | PL/pgSQL procedural language
 security_plugin | 1.0     | pg_catalog | provides security functionality

2.无编译安装

(1)下载数据库插件包

这里的插件包的位置可以任意位置
[omm@node1 static]$ wget https://cdn-mogdb.enmotech.com/mogdb-media/3.0.1/Plugins-3.0.1-CentOS-x86_64.tar.gz
--2022-08-31 20:20:14--  https://cdn-mogdb.enmotech.com/mogdb-media/3.0.1/Plugins-3.0.1-CentOS-x86_64.tar.gz
Resolving cdn-mogdb.enmotech.com (cdn-mogdb.enmotech.com)... 124.236.20.228
Connecting to cdn-mogdb.enmotech.com (cdn-mogdb.enmotech.com)|124.236.20.228|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 74443447 (71M) [application/gzip]
Saving to: ‘Plugins-3.0.1-CentOS-x86_64.tar.gz’
100%[============================================================================================================================================>] 74,443,447  9.12MB/s   in 5.9s

(2)安装插件

--这里举orafce插件无编译安装进行示例，其他的插件无编译安装方法与此类似
--进入orafce插件包中
[omm@node1 plugins]$ cd orafce/
[omm@node1 orafce]$ ll
total 7000
-rw------- 1 omm dbgrp  117202 Aug  5 17:51 orafce--3.17.sql
-rw------- 1 omm dbgrp     205 Aug  5 17:51 orafce.control
-rwx------ 1 omm dbgrp 7044896 Aug  5 17:51 orafce.so
[omm@node1 orafce]$ pwd
/opt/enmo/wisequery/script/static/plugins/plugins/orafce
--将orafce中的3个文件分别拷贝到如下目录
[omm@node1 orafce]$ cp orafce.so $GAUSSHOME/lib/postgresql
[omm@node1 orafce]$ cp orafce.control $GAUSSHOME/share/postgresql/extension
[omm@node1 orafce]$ cp orafce--3.17.sql $GAUSSHOME/share/postgresql/extension
--查看是否安装成功
MogDB=# create extension orafce ;
CREATE EXTENSION
MogDB=# \dx
                                                      List of installed extensions
      Name       | Version |   Schema   |                                          Description
-----------------+---------+------------+-----------------------------------------------------------------------------------------------
 dist_fdw        | 1.0     | pg_catalog | foreign-data wrapper for distfs access
 file_fdw        | 1.0     | pg_catalog | foreign-data wrapper for flat file access
 hdfs_fdw        | 1.0     | pg_catalog | foreign-data wrapper for flat file access
 hstore          | 1.1     | pg_catalog | data type for storing sets of (key, value) pairs
 log_fdw         | 1.0     | pg_catalog | Foreign Data Wrapper for accessing logging data
 mot_fdw         | 1.0     | pg_catalog | foreign-data wrapper for MOT access
 orafce          | 3.17    | public     | Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS
 plpgsql         | 1.0     | pg_catalog | PL/pgSQL procedural language
 security_plugin | 1.0     | pg_catalog | provides security functionality