Ran into this request just today, in short, we need to create a downstream Database for our Data Warehouse for better scalability, security, and performance for our internal users.
- An Amazon Redshift cluster as an Upstream Database.
- An Amazon RDS (PostgreSQL) instance as a Downstream Database
Note: currently - July 2014 - there is a bug that prevents the following query to finish, when you try to do it from an RDS instance type M2, M3 or R3 - the query would run on Redshift for about 15 minutes (you can’t even kill it) and ends with a blank error message. Just choose RDS Instance type M1 and it would be just fine.
- Connect to your instance (Remember to set your instance permission / firewall properly):
- Configuring dblink:
- Copy a table from Redshift to RDS:
Do it with aws-redshift-to-rds:
In case you need to solve this problem ASAP, here is a little command-line interface tool (named: aws-redshift-to-rds) that I’ve developed while working at Zalora :).