暂无图片
oracle_fdw无法编译
我来答
分享
Asky
2022-11-02
oracle_fdw无法编译

请问如何安装oracle_fdw呢 我这里编译报错误:

[postgres@localhost oracle_fdw-ORACLE_FDW_2_4_0]$ make
gcc -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic -DLINUX_OOM_SCORE_ADJ=0 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -fPIC -I"/usr/lib/oracle/21/client64/sdk/include" -I"/usr/lib/oracle/21/client64/oci/include" -I"/usr/lib/oracle/21/client64/rdbms/public" -I"/usr/lib/oracle/21/client64/" -I/usr/include/oracle/21/client64 -I/usr/include/oracle/19.12/client64 -I/usr/include/oracle/19.12/client -I/usr/include/oracle/19.11/client64 -I/usr/include/oracle/19.11/client -I/usr/include/oracle/19.10/client64 -I/usr/include/oracle/19.10/client -I/usr/include/oracle/19.9/client -I/usr/include/oracle/19.9/client64 -I/usr/include/oracle/19.8/client -I/usr/include/oracle/19.8/client64 -I/usr/include/oracle/19.6/client -I/usr/include/oracle/19.6/client64 -I/usr/include/oracle/19.3/client -I/usr/include/oracle/19.3/client64 -I/usr/include/oracle/18.5/client -I/usr/include/oracle/18.5/client64 -I/usr/include/oracle/18.3/client -I/usr/include/oracle/18.3/client64 -I/usr/include/oracle/12.2/client -I/usr/include/oracle/12.2/client64 -I/usr/include/oracle/12.1/client -I/usr/include/oracle/12.1/client64 -I/usr/include/oracle/11.2/client -I/usr/include/oracle/11.2/client64 -I/usr/include/oracle/11.1/client -I/usr/include/oracle/11.1/client64 -I/usr/include/oracle/10.2.0.5/client -I/usr/include/oracle/10.2.0.5/client64 -I/usr/include/oracle/10.2.0.4/client -I/usr/include/oracle/10.2.0.4/client64 -I/usr/include/oracle/10.2.0.3/client -I/usr/include/oracle/10.2.0.3/client64 -I. -I. -I/usr/include/pgsql/server -I/usr/include/pgsql/internal -D_GNU_SOURCE -I/usr/include/libxml2 -c -o oracle_fdw.o oracle_fdw.c
oracle_fdw.c:11:33: fatal error: access/htup_details.h: No such file or directory
#include "access/htup_details.h"

我来答
添加附件
收藏
分享
问题补充
4条回答
默认
最新
哇哈哈

缺少头文件access/htup_details.h

postgresql-devel有装吗
复制
暂无图片 评论
暂无图片 有用 1
打赏 0
Asky
题主
2022-11-02
安装了的, [root@localhost extension]# rpm -qa|grep postgresql-devel postgresql-devel-9.2.24-8.el7_9.x86_64
哇哈哈
答主
2022-11-02
9.2的pg和你的fdw版本能配上吗,看README.oracle_fdw里面的Installation Requirements
李宏达

参考一下这篇文章操作

https://www.modb.pro/db/181572

暂无图片 评论
暂无图片 有用 0
打赏 0
Asky
题主
2022-11-02
我也做这么操作的,但是我这里就是不行,很奇怪,find / -name htup_details.h 没有这个文件,不知道这个文件是哪里的,系统的还是oracle_fdw里面的
李宏达

不知道你想用哪个版本的看看这里有没有你需要的

https://github.com/laurenz/oracle_fdw/releases

暂无图片 评论
暂无图片 有用 0
打赏 0
彭冲

参考下安装需求:
image.png

较低的版本应该是不支持,上面提示的报错依赖的头文件是postgresql-devel里的,你试试用高一点版本的PG吧。

暂无图片 评论
暂无图片 有用 0
打赏 0
回答交流
Markdown


请输入正文
提交