gem-hunter
Language: Ruby
Copies postgres databases to redshift
This 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)