databases

POST `/v1/databases/{databaseId}/upgrade`

Move the database to a newer PostgreSQL major.

Uthibitishaji

Tuma ufunguo wa API kama tokeni ya kubeba. Sehemu hii ya mwisho haitaji ruhusa maalum katika maelezo, kwa hivyo ipe ufunguo wako kiwango cha chini kabisa kinachohitajika na uangalie jibu badala ya kukisia.

Endpoint hii haichukui kitambulisho cha shirika. Ufunguo wako tayari unalitambua shirika linalohusika, na jibu limewekewa kikomo kwa shirika hilo pekee.

Jaribu

Badilisha chochote kilicho ndani ya mabano ya pembe na maadili yako mwenyewe, na kishikiliaji cha ufunguo na ufunguo kutoka kwa dashibodi yako.

curl -X POST https://api.zinndigital.com/v1/databases/{databaseId}/upgrade \
  -H "Authorization: Bearer zdk_live_…" \
  -H "Content-Type: application/json" \
  -d '{ "engine_version": <string> }'

Umeingia kwenye akaunti? Dashibodi yako ya kiweko cha API inajaza kitambulisho chako halisi cha shirika na ufunguo wako mwenyewe, na kuendesha ombi dhidi ya API ya moja kwa moja ili uweze kuona jibu halisi. Fungua sehemu hii ya mwisho (endpoint) kwenye konsole ya API

Maelezo

Gated on `databases.manage`. Returns `202` — the upgrade runs as a durable workflow because the operator rolls the primary over to an upgraded replica, which takes minutes and must survive a deploy or the customer closing the tab. ⛔ Refused with 422 when the target is not a major we run, when it is not newer than the current one (downgrading is not possible), and — importantly — when **the database has never been backed up**: if a switchover goes wrong the way back is a restore, and a restore with no backup is not a way back.

Vigezo

Jina	Aina	Inayohitajika	Kilicho hiki
`databaseId (path)`	`string`	Ndiyo	—

Mwili wa ombi

Jina	Aina	Inayohitajika	Kilicho hiki
`engine_version`	`string`	Ndiyo	The engine major to move to. Must be one this platform offers for the database's own engine, and newer than its current one. ⛔ Compared as version numbers, not as text: `"9.7" <…

Majibu

Jina	Aina	Inayohitajika	Kilicho hiki
`id`	`string`	Ndiyo	—
`label`	`string`	Ndiyo	The customer's own name for it. Never sent to the infrastructure.
`engine`	`string<postgres, mysql>`	Ndiyo	Which engine this database runs (`docs/497`). Modelled as a field from the start, which is why MySQL was additive rather than a migration of every row.
`engine_version`	`string`	Ndiyo	The engine's major — `"18"`, `"8.4"`. The patch level is ours to keep current and is deliberately not customer-selectable: choosing your own patch level means choosing to ru…
`engine_label`	`string`	Hapana	The engine and version as a customer sees them — "PostgreSQL 18", "MySQL 8.4". Assembled by the API so three frontends cannot disagree about a product name.
`size`	`string`	Ndiyo	A code from `GET /v1/databases/catalogue`.
`status`	`string<provisioning, available, failed, suspended, deleting, deleted>`	Ndiyo	—
`status_detail`	`string`	Hapana	Why a `failed` instance failed. Empty otherwise.
`host`	`string`	Hapana	Empty until the instance is `available`.
`port`	`integer`	Ndiyo	—
`database_name`	`string`	Ndiyo	—
`username`	`string`	Ndiyo	—
`high_availability`	`boolean`	Ndiyo	Whether a standby replica is held with automatic failover. The property customers actually choose on — stated rather than inferred from the size, because an inference goes w…
`vcpu`	`integer`	Hapana	—
`ram_gb`	`integer`	Hapana	—
`storage_gb`	`integer`	Hapana	—
`tls_required`	`boolean`	Ndiyo	Always true. TLS is a precondition of selling a publicly reachable database, not a feature that can be turned off.
`created_at`	`string`	Ndiyo	—
`last_backup_at`	`string`	Hapana	When a backup last completed. `null` means none has ever run.
`order_line_id`	`object`	Hapana	The paid basket line this database fulfils, or `null` for one that predates the purchase path or that staff tooling created. The subscription that bills it carries the same id.
`billing`	`ManagedDatabaseBilling`	Hapana	The subscription paying for this database — what it costs, and when it next renews. ⛔ `null` means no subscription pays for it, which is a real state (a row created before d…
`restore_verified_at`	`string`	Hapana	When a backup of this database was last proved restorable by restoring it and reading a row back over a client connection. ⛔ Deliberately separate from `last_backup_at`: a b…

Hitilafu ambazo mwisho huu unaweza kurudisha

401 · 403 · 404 · 422

POST /v1/databases/{databaseId}/upgrade