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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [ADMIN] Foreign data wrappers for Oracle from Postgresql in RDS environment
Дата
Msg-id 27918.1506351856@sss.pgh.pa.us
обсуждение исходный текст
Ответ на [ADMIN] Foreign data wrappers for Oracle from Postgresql in RDS environment  (Garry Chen <gc92@cornell.edu>)
Ответы Re: [ADMIN] Foreign data wrappers for Oracle from Postgresql in RDS environment  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-admin
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 по дате отправления:

Предыдущее
От: Garry Chen
Дата:
Сообщение: [ADMIN] Foreign data wrappers for Oracle from Postgresql in RDS environment
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: [ADMIN] Foreign data wrappers for Oracle from Postgresql in RDS environment