oracle_fdw简单使用说明

源码安装

#先配置oracle客户端，参考
mkdir /usr/local/oracle
unzip -d /usr/local/oracle instantclient-basic-linux.x64-19.9.0.0.0dbru.zip
unzip -d /usr/local/oracle instantclient-sdk-linux.x64-19.9.0.0.0dbru.zip

vi /etc/profile
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/oracle/instantclient_19_9
export ORACLE_HOME=/usr/local/oracle/instantclient_19_9

source /etc/profile

#编译安装
export PATH=PostgreSQL-BIN目录:$PATH
make
<