Thank you. On Tue, Feb 13, 2018 at 3:31 AM, Laurenz Albe <laurenz.a...@cybertec.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 >
