Re: oracle db reads from postgresql

From: Andrea Suisani <sickpig(at)opinioni(dot)net>
To: Ray Stell <stellr(at)vt(dot)edu>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: oracle db reads from postgresql
Date: 2016-02-17 14:59:56
Message-ID: 56C48AEC.5080501@opinioni.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 02/17/2016 03:42 PM, Ray Stell wrote:
> I've dreaded this task coming my way for years. An Oracle developer wants to read postgresql data from his Oracle db. Is there a current, successful path to making this work or is it fools errand? I find this description:
> https://dbaspot.wordpress.com/2013/05/29/how-to-access-postgresql-from-oracle-database/ which is 3 yrs old. I see they want me to load an v8 rpm for the odbc driver so I tried to compile the latest and failed out of the gate. Just wondering if anyone has it working or not? Is there a more current
> howto?
>
>

if you're using postgresql 9.1+ you could give oracle_fwd a try:

http://laurenz.github.io/oracle_fdw/

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Dave Johansen 2016-02-17 15:02:14 Re: Setting up streaming replication with new server as master?
Previous Message Scott Whitney 2016-02-17 14:53:00 Re: oracle db reads from postgresql