Re: Ubuntu 15.04 Installing Oracle_fdw

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.