sincecutoff.com
← all changes

Heroku CLI adds Postgres upgrade run and wait commands

Introduced 2026-04-15 · score 0.96

HOW TO USE IT

For a major-version upgrade of a Heroku Postgres Advanced database, run `data:pg:upgrade:run` with the database and app, optionally specifying a target version. Then run `data:pg:upgrade:wait` for that database and app until the upgrade completes.

heroku data:pg:upgrade:run <DATABASE> --version <VERSION> --app <APP>
heroku data:pg:upgrade:wait <DATABASE> --app <APP>

WHY THIS HELPS

Upgrade a Heroku Postgres Advanced database to a new major version and wait for the upgrade to finish.

REQUIREMENTS AND LIMITATIONS

  • Version: v11.3.0
  • DATABASE (required): Database name, attachment name, or related config var on an app.
  • --app, -a (required): App to run the command against.
  • --version, -v: Postgres version to upgrade to.
  • --confirm, -c: Pass in the app name to skip confirmation prompts.
  • --remote, -r: Git remote of the app to use.
  • --no-notify: Suppress the OS notification while waiting.
  • --wait-interval: Polling interval in seconds; default is 5.
  • Prerequisite: The upgrade command is for a Postgres Advanced database.
  • The commands are for upgrading major versions of Heroku Postgres Advanced databases.
  • `data:pg:upgrade:wait` inherits the behavior of `data:pg:wait` and guides users dealing with a Classic database to run the correct command.

FIRST-PARTY EVIDENCE

Check the installed version and the source before using it. Entry JSON

Report a problem with this card