Hi, I compiled oracle_fdw.so on Ubuntu 15.04 Server 64bits and I'm
getting the "No such file or directory" error when I try to create the
oracle_fdw extension.
After doing make and make install on Oracle fdw source oracle_fdw.so is
built and installed correctly (oracle_fdw.so is copied to my $libdir
directory those related files are copied to the extension directory:
ls -lah /usr/share/postgresql/9.4/extension
-rw-r--r-- 1 root root 231 ene 2 12:19 oracle_fdw--1.0--1.1.sql
-rw-r--r-- 1 root root 1003 ene 2 12:19 oracle_fdw--1.1.sql
-rw-r--r-- 1 root root 133 ene 2 12:19 oracle_fdw.control
But, when I try to create the extension I get this:
psql (9.4.4, server 9.4.2)
SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384,
bits: 256, compression: off)
Type "help" for help.
postgres=# create extension oracle_fdw;
ERROR: could not open extension control file
"/usr/share/postgresql/9.4/extension/oracle_fdw.control": No such file
or directory
Any hint?
--
Leonardo M. Ramé
http://leonardorame.blogspot.com