.zd z3n-d3v

## how-to-upgrade-heroku-postgresql.md

      
        
          
            
              
              1 file
            
          
          
            
              
              11 forks
            
          
          
            
              
              20 comments
            
          
          
            
              
              81 stars
            
          
        
        
          
              
          
          
            
                simonw
                / how-to-upgrade-heroku-postgresql.md
            
            
              Last active
              April 29, 2024 05:07
            
              
                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