search

thomasweld / ticket_win

1 stars 1 forks source link

Upgrade production db to Basic #35

Closed kyledcline closed 9 years ago

kyledcline commented 9 years ago

We are approaching our limit on the Hobby tier prod db (10,000 rows). Basic provides 10,000,000 for $9/month.

Do this during times of very low traffic, as it will lock up the site during the entire maintenance period (roughly 5 minutes).

To upgrade, do the following from the command line:

heroku addons:create heroku-postgresql:basic
heroku pg:wait

The last command, pg:wait, will let you know once the database is provisioned successfully. Wait until it says available before continuing. Copy onto your clipboard the all caps name of the database it gives you (e.g. HEROKU_POSTGRESQL_YELLOW). You'll paste this in the steps below. (Change out YELLOW with whatever color it gives you.)

heroku maintenance:on
heroku pg:copy DATABASE_URL HEROKU_POSTGRESQL_YELLOW
heroku pg:promote HEROKU_POSTGRESQL_YELLOW
heroku maintenance:off
thomasweld commented 9 years ago

Tried .. here's what I got:

thomass-MacBook-Pro-2:ticket_win thomas$ heroku addons:create heroku-postgresql:basic ! That add-on plan is only available to select users. thomass-MacBook-Pro-2:ticket_win thomas$

kyledcline commented 9 years ago

Looks like it is only in beta still. Our only option is to upgrade to standard, which is $50/mo.

I've deleted alot of unused tickets, so we're good for now. Won't last long though.

Moving this to a later date.

thomasweld commented 9 years ago

Upgraded.