Upgrade Heroku Postgres DB plan
heroku, postgresql, ruby-on-rails-3
Solution
There is a document on Heroku's site for doing exactly this: Upgrade Heroku postgres with pgbackups.
In short, the steps are as follows:
- setup a new new basic database
- Prevent updates (set maintence mode on)
- Capture your backup
- Restore the backup to the new database
- promote your new database
- make your app active
These are also the same steps to follow if you decide to go to a production plan.
Problem
I'm sorry if this is a dumb question, I'm new to Heroku hosting and was hoping one of the experts on StackOverflow could help me. I originally signed up for a basic free postgres DB for my heroku app, but recently I've hit the 10K row limit and would like to upgrade to the $9/month plan. However, I have absolutely no idea how to do so.Is it a relatively simple process? I feel dumb for having to ask this question. When I log into heroku and click on my app, I see a list of add-ons for my app. When I click on the Postgres add-on, it takes me to a separate webpage but I don't see any options for upgrading my DB plan. Any tips? Thanks!