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. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin