On Tue, 13 Feb 2018 at 5:55 am, chiru r <chir...@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