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
最后修改時間：2022-09-01 15:10:49
「喜歡這篇文章，您的關注和贊賞是給作者最好的鼓勵」
關注作者
【版權聲明】本文為墨天輪用戶原創內容，轉載時必須標注文章的來源（墨天輪），文章鏈接，文章作者等基本信息，否則作者和墨天輪有權追究責任。如果您發現墨天輪中有涉嫌抄襲或者侵權的內容，歡迎發送郵件至：contact@modb.pro進行舉報，并提供相關證據，一經查實，墨天輪將立刻刪除相關內容。
