On 01/02/2016 08:22 AM, Leonardo M. Ramé wrote:
El 02/01/16 a las 12:51, Leonardo M. Ramé escribió:
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?
hehe, sorry, I was connected to a remote host using psql.
So that would explain this:
psql (9.4.4, server 9.4.2)
I take it then that connecting locally solved the problem?
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general