Heroku - Database Upgrade

17 Sep 25

Heroku announced the deprecation of Postgres v14.
I followed these steps to upgrade to v17. (This was after a bit of a battle to upgrade the Heroku CLI to the latest version due to lots old versions of the Heroku CLI being scattered around my setting and needing deleting before it would upgrade):
  • heroku maintenance:on
  • heroku pg:backups:capture
  • heroku pg:backups:download
  • heroku pg:upgrade:run HEROKU_POSTGRESQL_PUCE
  • heroku pg:upgrade:wait HEROKU_POSTGRESQL_PUCE  [to monitor upgrade progress]
  • heroku maintenance:off