Installation success but error when create extension

heimir-sverrisson / jdbc2_fdw

JDBC Foreign Data Wrapper for PostgreSQL

26 stars 16 forks source link

Installation success but error when create extension #3

Open virgaramada opened 8 years ago

virgaramada commented 8 years ago

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

rdnkrkmz commented 8 years ago

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..