Foreign data wrappers for Oracle from Postgresql in RDS environment

From: Garry Chen <gc92(at)cornell(dot)edu>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Foreign data wrappers for Oracle from Postgresql in RDS environment
Date: 2017-09-25 14:58:35
Message-ID: AFD36953-296A-4148-AC92-351A434D2EAB@cornell.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi All,
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.

Thank you very much,
Garry

My setup as following:

1. Security groups inbound has an entry for the oracle port and remote IP
2. Psql statement as following

Create extension dblinnk;
CREATE SERVER myOradb FOREIGN DATA WRAPPER dblink_fdw OPTIONS (host ‘my remote host IP’, dbname ' myOradb ', port '1521');
CREATE USER MAPPING FOR PGuser SERVER myOradb OPTIONS (user 'OraUser', password '’mypassword');
SELECT dblink_connect('myOradb');

ERROR: could not establish connection
SQL state: 08001
Detail: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2017-09-25 15:04:16 Re: Foreign data wrappers for Oracle from Postgresql in RDS environment
Previous Message Tom Lane 2017-09-25 13:43:46 Re: Risks of running Postgres as a Docker container?