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: | Raw Message | Whole Thread | 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.
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 |