Garry Chen <gc92@xxxxxxxxxxx> 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.
