Re: Foreign data wrappers for Oracle from Postgresql in RDS environment

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Garry Chen <gc92(at)cornell(dot)edu>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Foreign data wrappers for Oracle from Postgresql in RDS environment
Date: 2017-09-25 15:08:29
Message-ID: CAKFQuwbE9asoB=pRx+zxdRjpn+XG4+T4VX0m_-a4D0LGHACCDA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Mon, Sep 25, 2017 at 8:04 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Garry Chen <gc92(at)cornell(dot)edu> writes:
> > I am testing a dblink connection from RDS postgresql
> database to a remote oracle instance but I am getting could not establish
> connection error. Where did I do wrong and please help.
>
> As somebody already explained to you, dblink only does
> postgres-to-postgres connections.
>
> What you need for this is oracle_fdw. I do not know how well that's
> maintained, but it exists
> ​.
>

​Maintenance aside I'm not sure whether its been whitelisted for use in
RDS. The OP might need to run an EC2 instance so they can install custom
extensions.

David J.
​

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Carlos Martinez 2017-09-27 07:02:27 dblink_tds or similar for PostgreSQL 10
Previous Message David G. Johnston 2017-09-25 15:05:23 Re: Foreign data wrappers for Oracle from Postgresql in RDS environment