pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedForeign data wrappers for Oracle from Postgresql in RDS environment
4+ messages / 3 participants
[nested] [flat]
* Foreign data wrappers for Oracle from Postgresql in RDS environment
@ 2017-09-25 14:58 Garry Chen <gc92@cornell.edu>
2017-09-25 15:04 ` Re: Foreign data wrappers for Oracle from Postgresql in RDS environment Tom Lane <tgl@sss.pgh.pa.us>
2017-09-25 15:05 ` Re: Foreign data wrappers for Oracle from Postgresql in RDS environment David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 2 replies; 4+ messages in thread
From: Garry Chen @ 2017-09-25 14:58 UTC (permalink / raw)
To: 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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Foreign data wrappers for Oracle from Postgresql in RDS environment
2017-09-25 14:58 Foreign data wrappers for Oracle from Postgresql in RDS environment Garry Chen <gc92@cornell.edu>
@ 2017-09-25 15:04 ` Tom Lane <tgl@sss.pgh.pa.us>
2017-09-25 15:08 ` Re: Foreign data wrappers for Oracle from Postgresql in RDS environment David G. Johnston <david.g.johnston@gmail.com>
1 sibling, 1 reply; 4+ messages in thread
From: Tom Lane @ 2017-09-25 15:04 UTC (permalink / raw)
To: Garry Chen <gc92@cornell.edu>; +Cc: 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 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.
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Foreign data wrappers for Oracle from Postgresql in RDS environment
2017-09-25 14:58 Foreign data wrappers for Oracle from Postgresql in RDS environment Garry Chen <gc92@cornell.edu>
2017-09-25 15:04 ` Re: Foreign data wrappers for Oracle from Postgresql in RDS environment Tom Lane <tgl@sss.pgh.pa.us>
@ 2017-09-25 15:08 ` David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: David G. Johnston @ 2017-09-25 15:08 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Garry Chen <gc92@cornell.edu>; 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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Foreign data wrappers for Oracle from Postgresql in RDS environment
2017-09-25 14:58 Foreign data wrappers for Oracle from Postgresql in RDS environment Garry Chen <gc92@cornell.edu>
@ 2017-09-25 15:05 ` David G. Johnston <david.g.johnston@gmail.com>
1 sibling, 0 replies; 4+ messages in thread
From: David G. Johnston @ 2017-09-25 15:05 UTC (permalink / raw)
To: Garry Chen <gc92@cornell.edu>; +Cc: pgsql-admin
On Mon, Sep 25, 2017 at 7:58 AM, Garry Chen <gc92@cornell.edu> wrote:
> Where did I do wrong and please help.
>
>
>
You didn't read the response to this topic on the email thread you started
on the -novice list...
David J.
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2017-09-25 15:08 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-09-25 14:58 Foreign data wrappers for Oracle from Postgresql in RDS environment Garry Chen <gc92@cornell.edu>
2017-09-25 15:04 ` Tom Lane <tgl@sss.pgh.pa.us>
2017-09-25 15:08 ` David G. Johnston <david.g.johnston@gmail.com>
2017-09-25 15:05 ` David G. Johnston <david.g.johnston@gmail.com>
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