Re: oracle_fdw Question

On Tue, 13 Feb 2018 at 5:55 am, chiru r <chirupg(at)gmail(dot)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