Skip to content

Upgrade major version

This page describes how to upgrade the major version of your PostgreSQL database.

Preparations

Before doing a major version upgrade, consult the Google Cloud SQL documentation for any preparation that needs to be done.

Warning

Upgrading requires the instance to become unavailable for a period of time, depending on the size of your database. Expect a downtime of 10 minutes or more.

We recommend that you schedule your upgrade to a time when your application can be offline.

Choose a new major version

Select a new major version of PostgreSQL that you want to upgrade to. For safe upgrades, it is recommended to only do one major version at a time.

The full list of supported versions can be found in the application spec reference.

Change the major version

To change the major version, modify the type field in your application manifest:

app.yaml
spec:
  gcp:
    sqlInstances:
      - type: POSTGRES_16

Commit and push the changes to your application repository.

The upgrade will start the next time you deploy your application.