Skip to content

Instantly share code, notes, and snippets.

@ijrodrigues
ijrodrigues / how-to-upgrade-heroku-postgresql.md
Created Sep 10, 2020 — forked from simonw/how-to-upgrade-heroku-postgresql.md
How to upgrade a Heroku PostgreSQL database to a new plan
View how-to-upgrade-heroku-postgresql.md

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
View start-to-work.sh
#!/bin/bash
echo "Abrindo sites comuns"
google-chrome https://github.com > /dev/null 2>&1 &
echo "Iniciando editores de texto"
~/Downloads/idea-IU-201.7846.76/bin/idea.sh > /dev/null 2>&1 &
echo "Iniciando containers do docker"
docker restart mysql > /dev/null 2>&1 &