Creating a Redshift database from an RDS PostgreSQL database

Question

The job I'm in has a complete AWS setup. We have an Amazon RDS PostgreSQL database that we are wanting to move into an Amazon Redshift datahub.

The thing is, I'm completely lost on where to go. I have Redshift setup, and properly setup on security, but that is where my googling has led me to a wall.

Can you help me on this? I'm going to be using Kinesis to stream data from our PostgreSQL database to Redshift. Do I have to set up tables to begin the process, or can I just go ahead and do the stream from Kinesis, and that would take the process from there?

Could you please Edit your question and provide additional information about the streaming component? Are you intending to use this just for the initial population of the database, or as an on-going datasource? — John Rotenstein
– John Rotenstein, Commented Nov 2, 2017 at 19:58

John Rotenstein · Accepted Answer · 2017-11-02 20:02:35Z

2

If your goal is to migrate a PostgreSQL database to Redshift, then you can use the AWS Database Migration Service Documentation.

It can do a one-off migration or can perform a continuous migration to keep the databases "in sync".

There should be no need to involve Kinesis for a database migration.

If, however, you wish to continually load data into your Redshift cluster (eg stream data from a website and capture it in Redshift), then you will want to use Amazon Kinesis Firehose, which can stream directly into Redshift.

answered Nov 2, 2017 at 20:02

John Rotenstein

273k28 gold badges456 silver badges541 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Creating a Redshift database from an RDS PostgreSQL database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related