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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Garry Chen <gc92(at)cornell(dot)edu>
Cc: "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:04:16
Message-ID: 27918.1506351856@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2017-09-25 15:05:23 Re: Foreign data wrappers for Oracle from Postgresql in RDS environment
Previous Message Garry Chen 2017-09-25 14:58:35 Foreign data wrappers for Oracle from Postgresql in RDS environment