| 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 |