Postgres Pro
Downloads
Home   >   mailing lists

Thread: Ubuntu 15.04 Installing Oracle_fdw

Ubuntu 15.04 Installing Oracle_fdw

From
Leonardo M. Ramé
Date:
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

Re: Ubuntu 15.04 Installing Oracle_fdw

From
Leonardo M. Ramé
Date:
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.

Re: Ubuntu 15.04 Installing Oracle_fdw

From
Adrian Klaver
Date:
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.klaver@aklaver.com