PostgresToRedshift
This gem copies data from postgres to redshift. It's especially useful to copy data from postgres to redshift in heroku.
Installation
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
Usage
export REDSHIFT_URI='postgres://username:password@host:port/database-name'
export S3_DATABASE_EXPORT_ID='yourid'
export S3_DATABASE_EXPORT_KEY='yourkey'
export S3_DATABASE_EXPORT_BUCKET='some-bucket-to-use'
postgres_to_redshift $MY_SOURCE_DATABASE
Contributing
- Fork it ( https://github.com/kitchensurfing/postgres_to_redshift/fork )
- Create your feature branch (
git checkout -b my-new-feature
) - Commit your changes (
git commit -am 'Add some feature'
) - Push to the branch (
git push origin my-new-feature
) - Create a new Pull Request