Upgrade Major Version

Upgrade process

Note

This document only applies when changing the Postgres major version (for example, from 17 to 18). It doesn’t apply when upgrading minor versions (for example, from 18.5 to 18.6).

Nhost supports Postgres 18. To upgrade to Postgres 18, go to Settings -> Database, select the new major version, and start the process:

Caution

Keep in mind that the upgrade process requires downtime. Pay attention to all the information provided to you in the settings page.

After starting the process you can follow it on the same page:

Finally, you can confirm the upgrade by executing the SQL query SELECT version();

Projects with connected repos

This process can only be triggered from the dashboard. If you have a project with a connected repository and want to upgrade postgres to a new major version you will have to follow the steps below:

1. Upgrade the major version using the dashboard
2. Run nhost config pull or edit the nhost.toml by hand.
3. Push to git (this step should be a NOOP and can be skipped)

If you attempt to change major versions via a deployment the deployment will fail. This is done on purpose to avoid unintended upgrades which can lead to downtime.