create extension about oracle_fdw HOT 8 CLOSED

You are using a version of oracle_fdw that was built with PostgreSQL 16. You have to find and install a package that supports PostgreSQL 15 instead. oracle_fdw is always compiled for one specific (major) version of PostgreSQL and the result only works with that one version.

You can also build it yourself from source. Please see the README file; it explains in detail how to do this.

from oracle_fdw.

Another possibility is that your PostgreSQL version is 15.0 or 15.1.
That won't work, and you have to update to a later minor release.

See #596 and the commit message for 5727908.

from oracle_fdw.

you mean if i install postgres 12 this error won't appear

from oracle_fdw.

No. Update your PostgreSQL v15 server to 15.6 and try again.

from oracle_fdw.

i'm new on postgres and i dont have any idea about upgrading so i tried using postgresql 12 and face this error :

create extension oracle_fdw;
ERROR: could not load library "/usr/pgsql-12/lib/oracle_fdw.so": /usr/pgsql-12/lib/oracle_fdw.so: undefined symbol: errstart_cold

from oracle_fdw.

See the documentation:

Since the Oracle client shared library is probably not in the standard library path, you have to make sure that the PostgreSQL server will be able to find it. How this is done varies from operating system to operating system; on Linux you can set LD_LIBRARY_PATH or use /etc/ld.so.conf.

But you definitely should not use PostgreSQL v12. Updating is trivial: install 15.6 over your existing 15.0 installation and restart the server. If that is too much for you, perhaps you shouldn't use oracle_fdw, which involves compiling from source...

from oracle_fdw.

@MajdRamadan how are you installing oracle_fdw, and what is the OS?

from oracle_fdw.

Could you resolve the problem?

from oracle_fdw.