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.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general