Search code examples
herokuheroku-postgres

Upgrade from Heroku Hobby to Standard and retroactive Postgres DB rollback possible?


Becuase of reasons beyond our/my control we need to roll back our Postgres DB that was in the Postgres Hobby tier.

However, rollback (4 days) is not offered in Hobby, but on the next level, Postgres Standard tier.

My questions are will an upgrade perform allow me to access "retroactive" backups (if any) or is the Hobby tier totally void of any backups/data at all?


Solution

  • Upgrading your database will give you the ability to complete a point-in-time recovery only as far back as the time you upgraded or the length provided by that database plan (whichever is longer). To answer your question, no. upgrading will not let you perform a 'retroactive' rollback since you'll be dealing with an entirely new database.