Hi I am moving from using PostgreSQL to Redshift as my data store. Would like to ask suggestion on how best to do this.
I am planning to do either of this:
- Dump all postgresql DBs data (
pg_dump dbname > dumpfile) and restore them to Redshift (
psql dbname < dumpfile).
- Moving all the runs in
shredded:goodand re-run the storage loading process in EmrEtlRunner using
--resume_from rdb_load(or step 13 in the Batch Pipeline Diagram. Do I have to move runs from
enriched:goodtoo if I use this method?
Would like to know which method is best to use as well as the advantage and disadvantage of both.