jdbc2_fdw icon indicating copy to clipboard operation
jdbc2_fdw copied to clipboard

Installation success but error when create extension

Open virgaramada opened this issue 9 years ago • 1 comments

Hi Heimir, I have successfully compiled jdbc2_fdw, but when I tried to create extension within postgres postgres=# CREATE EXTENSION jdbc2_fdw; ERROR: incompatible library "/usr/local/pgsql/lib/jdbc2_fdw.so": magic block mismatch DETAIL: Server has FUNC_MAX_ARGS = 256, library has 100. note : libjvm.so is already in library path server detail: OS : Centos 7 64 Bit Postgres 9.4.5 JDK jdk1.7.0_79 64 Bit

Please help Rgrds

virgaramada avatar Nov 27 '15 08:11 virgaramada

Hi virgaramada, I also have this error on another work (oracle foreign data wrapper for postgres http://pgxn.org/dist/oracle_fdw/), on the following platform; OS : Oracle Linux 6.7 64 Bit Postgres : 9.5.5 (PPAS) I have successfully created extension by recompiling the source code as following option: [postgres@primary ~/oracle_fdw-1.4.0]$ make FUNC_MAX_ARGS=256 then copy the binary to destination (replace old one) May help you too..

rdnkrkmz avatar May 05 '16 13:05 rdnkrkmz