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
- https://github.com/heroku/cli/releases/tag/v11.3.0
- https://github.com/heroku/cli/pull/3551
- https://devcenter.heroku.com/articles/heroku-cli-commands
Check the installed version and the source before using it. Entry JSON