Re: [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
Дата
Msg-id CAKFQuwbE9asoB=pRx+zxdRjpn+XG4+T4VX0m_-a4D0LGHACCDA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [ADMIN] Foreign data wrappers for Oracle from Postgresql in RDS environment  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Дерево обсуждения
On Mon, Sep 25, 2017 at 8:04 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Garry Chen <gc92@cornell.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.
​

В списке pgsql-admin по дате отправления:

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