无法加载oracle_fdw的库 [英] could not load library for oracle_fdw

问题描述

创建oracle_fdw时遇到问题.

I am facing issue while creating oracle_fdw.

我已将oracle_fdw.dll复制到postgres lib文件夹* .sql文件和控制文件都应压缩/扩展

I have copied oracle_fdw.dll to postgres lib folder * both .sql file and control file to shrared/extension

现在，当我以超级管理员用户&连接到psql时进行查询

now when I connect to psql with superadmin user & make an query

 create extension oracle_fdw;

我得到回应

ERROR:  could not load library "D:/postgresdb/lib/oracle_fdw.dll": The specified procedure could not be found.

推荐答案

从该错误看来，postGreSQL安装目录的lib文件夹中没有oracle_fdw库.

From the error it seems that the oracle_fdw library is not available in the lib folder of postGreSQL installation directory.

您可以从 https://github.com/laurenz下载Oracle fdw扩展名或库文件. /oracle_fdw/releases/-请下载一个适合您的系统环境的文件(例如:32位Windows/64位).

You may download the Oracle fdw extension/or library file from https://github.com/laurenz/oracle_fdw/releases/ - please download the one suitable to your system environment(eg : 32bit windows/64bit).

解压缩下载的.zip文件.

Extract the downloaded .zip file.

1. 将oracle_fdw.dll从\ oracle_fdw-1.4.0-pg95-win64 \ lib文件夹复制到\ Program Files \ PostgreSQL \ 9.5 \ lib目录 & 2.将所有文件从oracle_fdw-1.4.0-pg95-win64 \ share \ extension复制到\ Program Files \ PostgreSQL \ 9.5 \ share \ extension

1. copy the oracle_fdw.dll from \oracle_fdw-1.4.0-pg95-win64\lib folder to \Program Files\PostgreSQL\9.5\lib dir & 2.copy all the files from oracle_fdw-1.4.0-pg95-win64\share\extension to \Program Files\PostgreSQL\9.5\share\extension

现在重新启动postGreSQL服务器并尝试.

Now restart postGreSQL server and try.

注意:始终下载并使用兼容版本的库；例如:PostgreSQL 9.5版本，您应该下载相同版本的oracle_fdw zip.

Note : Always download and use compatible version of library; e.g.: PostgreSQL 9.5 version you should download same version of oracle_fdw zip.

这篇关于无法加载oracle_fdw的库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！