gem-hunterThis gem copies data from postgres to redshift. It's especially useful to copy data from postgres to redshift in heroku.
Add this line to your application's Gemfile:
gem 'postgres_to_redshift'
And then execute:
$ bundle
Or install it yourself as:
$ gem install postgres_to_redshift
Set your source and target databases, as well as your s3 intermediary.
export POSTGRES_TO_REDSHIFT_SOURCE_URI='postgres://username:password@host:port/database-name' export POSTGRES_TO_REDSHIFT_TARGET_URI='postgres://username:password@host:port/database-name' export POSTGRES_TO_REDSHIFT_TARGET_SCHEMA='testing-data' export S3_DATABASE_EXPORT_ID='yourid' export S3_DATABASE_EXPORT_KEY='yourkey' export S3_DATABASE_EXPORT_BUCKET='some-bucket-to-use' postgres_to_redshift
git checkout -b my-new-feature)git commit -am 'Add some feature')git push origin my-new-feature)