Skip to content

Instantly share code, notes, and snippets.

@casagrande86
casagrande86 / how-to-upgrade-heroku-postgresql.md
Created November 17, 2020 22:33 — 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
@casagrande86
casagrande86 / how-to-upgrade-heroku-postgresql.md
Created November 17, 2020 22:30 — forked from ArnoutDevos/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

original: https://gist.github.com/simonw/50e14b9a3e829355d6d43f0f12f91e74

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).

⚠️ In the following, replace <appname> with the name of your Heroku app.

What database(s) are connected?