Garry Chen <gc92(at)cornell(dot)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