Re: oracle_fdw Question

Thank you.

On Tue, Feb 13, 2018 at 3:31 AM, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
wrote:

> chiru r wrote:
> > 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?
>
> As long as you have the same version of the same operating system on
> all machines and all required software is installed in the same versions,
> it should be no problem to build it on one machine and install it on the
> others.
>
> The process you describe looks right; just make sure the files end up in
> the
> same directories where "make install" installs them on the build machine.
>
> I am not quite sure what you mean with a "relocatable binary file".
>
> Yours,
> Laurenz Albe
>