pg_upgrade
Upgrade PostgreSQL database versions safely for Heroku apps. Plan migration paths, verify compatibility, and execute controlled upgrades with confirmation protection to ensure a secure transition.
Instructions
Upgrade PostgreSQL database version. Use this tool when you need to: 1) Migrate to a newer PostgreSQL version, 2) Plan version upgrade paths, 3) Execute controlled version migrations, 4) Verify upgrade compatibility. The tool manages safe database version upgrades with confirmation protection.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| app | Yes | The name of the Heroku app whose database to upgrade. | |
| confirm | No | Confirmation string required for this potentially destructive operation. | |
| database | No | Config var containing the connection string, unique name, ID, or alias of the database. To access another app's database, prepend the app name to the config var or alias with `APP_NAME::`. If omitted, DATABASE_URL is used. | |
| version | No | PostgreSQL version to upgrade to |
Input Schema (JSON Schema)
{
"$schema": "http://json-schema.org/draft-07/schema#",
"additionalProperties": false,
"properties": {
"app": {
"description": "The name of the Heroku app whose database to upgrade.",
"type": "string"
},
"confirm": {
"description": "Confirmation string required for this potentially destructive operation.",
"type": "string"
},
"database": {
"description": "Config var containing the connection string, unique name, ID, or alias of the database. To access another app's database, prepend the app name to the config var or alias with `APP_NAME::`. If omitted, DATABASE_URL is used.",
"type": "string"
},
"version": {
"description": "PostgreSQL version to upgrade to",
"type": "string"
}
},
"required": [
"app"
],
"type": "object"
}