oracle_fdw安装部署(yum方式)

环境:
OS:Centos 7
DB:13.8

1.安装oralce客户端
参考链接(root账号下安装部署)
https://www.cnblogs.com/hxlasky/p/16616404.html

2.安装oracle_fdw
我这里采用yum方式进行安装
[root@localhost]# yum install https://download.postgresql.org/pub/repos/yum/reporpms/non-free/EL-7-x86_64/pgdg-redhat-nonfree-repo-latest.noarch.rpm
[root@localhost]# yum list oracle_fdw* ##查看当前各版本
[root@localhost]# yum install oracle_fdw_13.x86_64 ##安装与PG版本一致的版本

安装完成后可以看到extension相应的控制文件
[root@localhost extension]# ls -al |grep oracle
-rw-r--r--. 1 root root 231 Oct 28 05:43 oracle_fdw--1.0--1.1.sql
-rw-r--r--. 1 root root 240 Oct 28 05:43 oracle_fdw--1.1--1.2.sql
-rw-r--r--. 1 root root 1244 Oct 28 05:43 oracle_fdw--1.2.sql
-rw-r--r--. 1 root root 133 Oct 28 05:43 oracle_fdw.control
[root@localhost extension]# pwd
/usr/pgsql-13/share/extension

3.创建oracle_fdw

postgres=# create extension oracle_fdw;
CREATE EXTENSION
postgres=# \dx
                                                                       List of installed extensions
             Name             | Version |   Schema   |                                                     Descriptio
n                                                     
------------------------------+---------+------------+---------------------------------------------------------------
------------------------------------------------------
 address_standardizer         | 3.2.3   | public     | Used to parse an address into constituent elements. Generally 
used to support geocoding address normalization step.
 address_standardizer_data_us | 3.2.3   | public     | Address Standardizer US dataset example
 dblink                       | 1.2     | public     | connect to other PostgreSQL databases from within a database
 fuzzystrmatch                | 1.1     | public     | determine similarities and distance between strings
 mysql_fdw                    | 1.1     | public     | Foreign data wrapper for querying a MySQL server
 oracle_fdw                   | 1.2     | public     | foreign data wrapper for Oracle access
 plpgsql                      | 1.0     | pg_catalog | PL/pgSQL procedural language
 postgis                      | 3.2.3   | public     | PostGIS geometry and geography spatial types and functions
 postgis_raster               | 3.2.3   | public     | PostGIS raster types and functions
 postgis_sfcgal               | 3.2.3   | public     | PostGIS SFCGAL functions
 postgis_tiger_geocoder       | 3.2.3   | tiger      | PostGIS tiger geocoder and reverse geocoder
 postgis_topology             | 3.2.3   | topology   | PostGIS topology spatial types and functions
 postgres_fdw                 | 1.0     | public     | foreign-data wrapper for remote PostgreSQL servers
(13 rows)