oracle_fdw Question

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

oracle_fdw Question

chiru r
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?

Thanks,
chiru
Reply | Threaded
Open this post in threaded view
|

Re: oracle_fdw Question

Venkata B Nagothi

On Tue, 13 Feb 2018 at 5:55 am, chiru r <[hidden email]> 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
 
Reply | Threaded
Open this post in threaded view
|

Re: oracle_fdw Question

Laurenz Albe
In reply to this post by chiru r
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

Reply | Threaded
Open this post in threaded view
|

Re: oracle_fdw Question

chiru r
Thank you.

On Tue, Feb 13, 2018 at 3:31 AM, Laurenz Albe <[hidden email]> 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

Previous Thread Next Thread