Managed databases: major version upgrades

Posted on May 5, 2020

**Are major version upgrades **(e.g. PG v11 -> PG v12) handled automatically by DigitalOcean?

Otherwise, do you manually have to export the dump and import it in a new updated cluster?

I can’t find any information in the documentation.

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Priyanka Malik

May 22, 2021

Hi @collimarco

You can upgrade earlier versions of PostgreSQL clusters or nodes to newer versions without any downtime using the DigitalOcean Control Panel. You will be able to upgrade to the next major version without the manual work of forking and redirecting your traffic. To upgrade a cluster to a newer version of PostgreSQL, open the Databases page and then click on the cluster you want to upgrade.

On the cluster’s Overview page, scroll down to the CURRENT VERSION section and then click Upgrade Now.

Select the version of PostgreSQL you want to use.

The control panel will run an upgrade compatibility check to ensure the new version is safe to install. If the check returns Cluster Check found no issues - Safe to install, click Upgrade Now. The cluster is upgraded to the selected version. I am including the document link on how to upgrade the postgresql version:

https://docs.digitalocean.com/products/databases/postgresql/how-to/upgrade-version/

Regards, Priyanka