Postgres Pro
Downloads
Home   >   mailing lists

Re: [ADMIN] Foreign data wrappers for Oracle from Postgresql in RDS environment - Mailing list pgsql-admin

From Tom Lane
Subject Re: [ADMIN] Foreign data wrappers for Oracle from Postgresql in RDS environment
Date
Msg-id 27918.1506351856@sss.pgh.pa.us
Whole thread Raw
In response to [ADMIN] Foreign data wrappers for Oracle from Postgresql in RDS environment  (Garry Chen <gc92@cornell.edu>)
Responses Re: [ADMIN] Foreign data wrappers for Oracle from Postgresql in RDS environment  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-admin
Tree view 
Garry Chen <gc92@cornell.edu> writes:
>                 I am testing a dblink connection from RDS postgresql database to a remote oracle instance but I am
gettingcould 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


--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

pgsql-admin by date:

Previous
From: Garry Chen
Date:
Subject: [ADMIN] Foreign data wrappers for Oracle from Postgresql in RDS environment
Next
From: "David G. Johnston"
Date:
Subject: Re: [ADMIN] Foreign data wrappers for Oracle from Postgresql in RDS environment