Upgrade Heroku Postgres DB plan

Question

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!

Bruno Casali · Accepted Answer · 2021-01-05 14:59:49Z

28

In pratical ways you can do this to upgrade your postgres database plan:

heroku config

// It will show current database URL
HEROKU_POSTGRESQL_COPPER_URL: postgres://xxxddxxdx:[email protected]:5432/xdfdsxdxxxx
HEROKU_POSTGRESQL_SILVER_URL: postgres://fasdfsad:[email protected]:5432/sdfasdfdasfds

// Default database set
DATABASE_URL:  postgres://fasdfsad:[email protected]:5432/dsfsdf

Create a new database heroku addons:create heroku-postgresql:hobby-basic (but I recommend that you go in server resource section and click Edit Addon and add pgsql and change plan from Free to your required plan)
Run these commands to prevent database updates: heroku maintenance:on and heroku ps:scale worker=0

Copy current db to new db: heroku pg:copy DATABASE_URL HEROKU_POSTGRESQL_COPPER_URL --app prod-test

Note:

DATABASE_URL = It is config veriable which point default current db
HEROKU_POSTGRESQL_COPPER_URL = This is config variable for which db I just created
prod-test = It is my APP name

Promote new database (Make new db as default db) heroku pg:promote HEROKU_POSTGRESQL_COPPER_URL
Re-enable worker/dynos heroku ps:scale worker=1 and heroku maintenance:off
remove old database heroku addons:remove HEROKU_POSTGRESQL_SILVER_URL

edited Jan 5, 2021 at 14:59

Bruno Casali

1,3902 gold badges17 silver badges32 bronze badges

answered Jul 25, 2015 at 5:20

Dhiraj

1,1191 gold badge13 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

tomb Over a year ago

This should be the selected answer. The heroku documentation with pg:dump is silly in this specific case, thank you Dhiraj! Saved me some time.

Robert H · Accepted Answer · 2013-03-19 16:15:28Z

10

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.

answered Mar 19, 2013 at 16:15

Robert H

11.7k19 gold badges72 silver badges112 bronze badges

Comments

davidrac · Accepted Answer · 2013-03-19 16:15:03Z

1

It's a straight forward process. They have an article just for that here.

answered Mar 19, 2013 at 16:15

davidrac

10.8k3 gold badges45 silver badges71 bronze badges

Collectives™ on Stack Overflow

Upgrade Heroku Postgres DB plan

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related