Comment on Amazon RDS now supports PostgreSQL 9.6.1parentComments−kyleblarson9yAgree 100%. Would be awesome if you could have RDS with FDW connected to a Redshift instance. (don't know if that's possible given the version of Postgres upon which Redshift is based)−yuanchuan9yIt is definitely doable. You can refer to this blog post by AWS (https://aws.amazon.com/blogs/big-data/join-amazon-redshift-a...) to set up FDW to Redshift.What is more exciting is you can leverage Redshift MPP architecture with this method.−numlocked9yYou can definitely do FDWs to Other Postgres instances, and since I think you can just point the same wrapper to redshift and voila.
Comments
Agree 100%. Would be awesome if you could have RDS with FDW connected to a Redshift instance. (don't know if that's possible given the version of Postgres upon which Redshift is based)
It is definitely doable. You can refer to this blog post by AWS (https://aws.amazon.com/blogs/big-data/join-amazon-redshift-a...) to set up FDW to Redshift.
What is more exciting is you can leverage Redshift MPP architecture with this method.
You can definitely do FDWs to Other Postgres instances, and since I think you can just point the same wrapper to redshift and voila.