From: Garry Chen <gc92@cornell.edu>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Foreign data wrappers for Oracle from Postgresql in RDS environment
Date: Mon, 25 Sep 2017 14:58:35 +0000
Message-ID: <AFD36953-296A-4148-AC92-351A434D2EAB@cornell.edu> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: gc92@cornell.edu
Subject: Re: Foreign data wrappers for Oracle from Postgresql in RDS environment
In-Reply-To: <AFD36953-296A-4148-AC92-351A434D2EAB@cornell.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox