create extension

[MajdRamadan]

after finish install for oracle_fdw this error raised

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

[chrullrich]

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.

[laurenz]

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

[MajdRamadan]

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

[laurenz]

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

[MajdRamadan]

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

[laurenz]

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

[devrimgunduz]

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

[laurenz]

Could you resolve the problem?