Re: oracle_fdw Question - Mailing list pgsql-general

From Venkata B Nagothi
Subject Re: oracle_fdw Question
Date
Msg-id CAEyp7J9582fWXGk9twQ0r=OJWECyhMkXHaofsVXmEKrbri3Awg@mail.gmail.com
Whole thread Raw
In response to oracle_fdw Question  (chiru r <chirupg@gmail.com>)
List pgsql-general

On Tue, 13 Feb 2018 at 5:55 am, chiru r <chirupg@gmail.com> wrote:
Hi,

I am trying to install and configure the oracle_fdw on PostgreSQL DB servers.
What we are trying is, inorder to install (make, make install) oracle_fdw on all DB servers,we want to compile on one server and want build a package/tar file to copy the library files and required SQL scripts into all other servers.
So that it will reduce the installation efforts.

can we copy the oracle_fdw.so file into "<directory>/9.5/lib/postgresql"
And  oracle_fdw.control,oracle_fdw--1.1.sql and oracle_fdw--1.0--1.1.sql files into "<directory>/9.5/share/postgresql/extension" directory.
Is this the right approach?

Is there any process to create re-locatable binary files for oracle_fdw?

If you are installing same Postgres versions across all the DB servers, then, I would suggest build re-locatable Postgres binaries which includes oracle_fdw as well.

Thanks,
Venkata B

Thanks,
chiru
--

Regards,

Venkata B N
Database Consultant
 

pgsql-general by date:

Previous
From: chiru r
Date:
Subject: oracle_fdw Question
Next
From: Thiemo Kellner
Date:
Subject: I do not get the point of the information_schema