Re: Ubuntu 15.04 Installing Oracle_fdw

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(dot)klaver(at)aklaver(dot)com