Re: oracle_fdw Question

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: chiru r <chirupg(at)gmail(dot)com>, Forums postgresql <pgsql-general(at)postgresql(dot)org>
Subject: Re: oracle_fdw Question
Date: 2018-02-13 08:31:44
Message-ID: 1518510704.2525.5.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vinodh NV 2018-02-13 08:58:03 Require assistance in Postgres + Hibernate : Error: java.math.BigInteger cannot be cast to java.math.BigDecimal
Previous Message Samuel Oceguera 2018-02-13 08:16:50