Skip to content

Instantly share code, notes, and snippets.

View ltw-freedom's full-sized avatar

ltw-freedom ltw-freedom

  • mylittledata
  • seoul
View GitHub Profile
@ltw-freedom
ltw-freedom / how-to-upgrade-heroku-postgresql.md
Created June 15, 2022 19:12 — forked from simonw/how-to-upgrade-heroku-postgresql.md
How to upgrade a Heroku PostgreSQL database to a new plan

How to upgrade a Heroku PostgreSQL database to a new plan

I started a project on a Hobby Dev plan (free, limit 10,000 rows), and then later needed to upgrade it to Hobby Basic ($9/month, limit 10,000,000 rows).

After assigning the new database, I had two databases attached to the application. They looked something like this:

  • HEROKU_POSTGRESQL_OLIVE (postgresql-dimensional-3321) Old, free-tier (Hobby Dev) database