CODEWITHSUNDEEP
heroku
Yunti
Yunti

Reputation: 7448

Downgrade Heroku Postgres from standard to hobby

enter image description hereI'm trying to downgrade a heroku postgres db from standard to hobby basic. As I'm not fully using the web app currently but there is still some data in there that needs to be kept. How can I downgrade? (some downtime is fine).

Update: managed to setup and promote a new database based on the inststructions below, but i can't deprovision the old one. heroku info shows:

Upvotes: 1

Views: 2225

Answers (1)

Adam McCrea
Adam McCrea

Reputation: 1112

Heroku's instructions for upgrading with pg:copy will also work for downgrading. Here's the summary:

  1. Provision a new database
  2. Enter maintenance mode to prevent database writes
  3. Transfer data to the new database
  4. Promote the new database
  5. Exit maintenance mode

If your app isn't live (not being actively written to), you can skip the maintenance mode steps.

Once you've done that, you can deprovision your old database.

Upvotes: 6

Related Questions