laurenz
commented
3 months ago What is AS12? Is that EDB's proprietary fork? You say that "at AS12, the oracle fdw working fine". So, where is it not working?
It looks like you have Oracle Instant Client 18.3. Can you tell me what else is installed on the machine? Any other Oracle software? What version of PostgreSQL? What is your Linux distribution?
Please tell me how exactly you are installing oracle_fdw, and what the exact messages are.
How did you set the client library path for the PostgreSQL server?
TommyHo1
edmondEDB
Dear Laurenz,
For the upgrade purpose (edu as v12 to edu as v16), we need to install both version in the same server. at AS12, the oracle fdw working fine. we just installed this oracle_fdw by following steps, but it fail to create extension oracle_fdw. the message is could not load library "/usr/edb/as16/lib/oracle_fdw.so"
since we already installed oracle client 18 when we install as12 before, we only do "make install" on this oracle_fdw lib
[root@gzdcedbdev03.css /]# cd /usr/lib/oracle/18.3/client64/lib [root@gzdcedbdev03.css lib]# ls . libipc1.so libocijdbc18.so ojdbc8.jar .. libmql1.so libons.so ottclasses.zip glogin.sql libnnz18.so liboramysql18.so xstreams.jar libclntshcore.so.18.1 libocci.so libsqlplusic.so libclntsh.so libocci.so.18.1 libsqlplus.so libclntsh.so.18.1 libociei.so network [root@gzdcedbdev03.css lib]# ls -l total 229008 drwxr-xr-x 3 root root 4096 Feb 17 2023 . drwxr-xr-x 4 root root 28 Oct 19 2022 .. -rwxr-xr-x 1 root root 342 Jan 24 2019 glogin.sql -rwxr-xr-x 1 root root 8350672 Jan 24 2019 libclntshcore.so.18.1 lrwxrwxrwx 1 root root 17 Jan 24 2019 libclntsh.so -> libclntsh.so.18.1 -rwxr-xr-x 1 root root 77884224 Jan 24 2019 libclntsh.so.18.1 -rwxr-xr-x 1 root root 3537979 Jan 24 2019 libipc1.so -rwxr-xr-x 1 root root 467468 Jan 24 2019 libmql1.so -rwxr-xr-x 1 root root 6636088 Jan 24 2019 libnnz18.so lrwxrwxrwx 1 root root 15 Jan 24 2019 libocci.so -> libocci.so.18.1 -rwxr-xr-x 1 root root 2229347 Jan 24 2019 libocci.so.18.1 -rwxr-xr-x 1 root root 126951384 Jan 24 2019 libociei.so -rwxr-xr-x 1 root root 160875 Jan 24 2019 libocijdbc18.so -rwxr-xr-x 1 root root 394835 Jan 24 2019 libons.so -rwxr-xr-x 1 root root 118171 Jan 24 2019 liboramysql18.so -rwxr-xr-x 1 root root 1655813 Jan 24 2019 libsqlplusic.so -rwxr-xr-x 1 root root 1616347 Jan 24 2019 libsqlplus.so drwxr-xr-x 3 root root 19 Oct 19 2022 network -rw-r--r-- 1 root root 4109057 Jan 24 2019 ojdbc8.jar -rw-r--r-- 1 root root 313026 Jan 24 2019 ottclasses.zip -rw-r--r-- 1 root root 37519 Jan 24 2019 xstreams.jar
I found the pg_config still pointing to as12 , is that the reason? [root@gzdcedbdev03.css lib]# pg_config --pgxs /usr/edb/as12/lib/pgxs/src/makefiles/pgxs.mk
Regards, Tommy