I have same issue. Look like dblink is not table to utilize public IP to make connections. I see this even when using same connection string as psql on console. Workaround is you need to use private ip to connect. I believe this is a bug in AWS, not sure in what though.