On 16.09.2016 17:01, Arun Rangarajan wrote:
Hi Laurenz,
Thanks for your reply.
Sorry for the double posting here and StackOverflow
http://stackoverflow.com/questions/39518417/unable-to-create-oracle-fdw-extension-on-postgres
.
I will update the details on StackOverflow since formatting and
Hi Laurenz,
Thanks for your reply.
Sorry for the double posting here and StackOverflow
http://stackoverflow.com/questions/39518417/unable-to-create-oracle-fdw-extension-on-postgres
.
I will update the details on StackOverflow since formatting and editing are
easier there.
On Fri, Sep 16, 2016 a
Arun Rangarajan wrote:
> But when I try to create the extension, I get the following error:
>
> postgres=# create extension oracle_fdw;
> server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
> The connection to th
Thanks again, Scott. No success yet though.
I uninstalled Oracle instant client 12.1 using dpkg, downloaded RPMs for
instant client 10.2 and installed them with alien.
I also downloaded oracle_fdw 1.4 and installed it, since I was getting this
error with oracle_fdw 1.5:
---
postgres=# create exte
On Thu, Sep 15, 2016 at 4:57 PM, Arun Rangarajan
wrote:
> Thanks, Scott.
>
> oracle_fdw version 1.5.0 from http://pgxn.org/dist/oracle_fdw/
>
> Oracle client version: instantclient 12.1
>
I've had problems using anything > instant client 10. Give it a shot.
--Scott
>
> /usr/lib/postgresql/9
Thanks, Scott.
oracle_fdw version 1.5.0 from http://pgxn.org/dist/oracle_fdw/
Oracle client version: instantclient 12.1
/usr/lib/postgresql/9.4/lib# ldd oracle_fdw.so
linux-vdso.so.1 => (0x7fff50744000)
libclntsh.so.12.1 => /usr/lib/oracle/12.1/client64/lib/libclntsh.so.12.1
(0x7f44769f
On Thu, Sep 15, 2016 at 3:25 PM, Arun Rangarajan
wrote:
> I am following the instructions here:
> http://blog.dbi-services.com/connecting-your-postgresql-
> instance-to-an-oracle-database/
> to install Oracle foreign data wrapper, oracle_fdw, on a PostgreSQL server.
>
> ---
> Oracle version: Orac