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.
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? |