How to migrate your Heroku Postgres database to Amazon RDS
How to migrate your Heroku Postgres database to Amazon RDS
After created RDS database
Add RDS certificate to your application:
$ cd your_app
$ mkdir -p config
$ curl https://s3.amazonaws.com/rds-downloads/rds-combined-ca-bundle.pem > ./config/rds-combined-ca-bundle.pem
$ git add config/rds-combined-ca-bundle.pem
$ git commit -m "Add RDS certificate to app files"
$ git push heroku master
Dump your Heroku database locally
This will take your application offline.
$ cd your_app
$ heroku maintenance:on
$ heroku pg:backups capture
$ curl -o /tmp/latest.dump `heroku pg:backups public-url`
$ heroku maintenance:on
$ heroku pg:backups capture
$ curl -o /tmp/latest.dump `heroku pg:backups public-url`
Switch the Heroku app to RDS
heroku addons:destroy heroku-postgresql
heroku config:add DATABASE_URL='postgres://rohit:rohit00$$@blogger.cvss58cdh1jm.us-east-1.rds.amazonaws.com:5432/blogger?sslca=config/rds-combined-ca-bundle.pem&sslmode=require&encrypt=true'
heroku config:add DATABASE_URL='postgres://rohit:rohit00$$@blogger.cvss58cdh1jm.us-east-1.rds.amazonaws.com:5432/blogger?sslca=config/rds-combined-ca-bundle.pem&sslmode=require&encrypt=true'
Syntax;
heroku config:add DATABASE_URL='postgres://myrdsusername:myrdspassword@my-instance.bdfsg3dsfg.ap-southeast-2.rds.amazonaws.com:5432/my_db_production?sslca=config/ca/rds-ssl-ca-cert.pem&sslmode=require&encrypt=true'
This will take your application online.
heroku maintenance:offWe can follow the link below :-
Comments